1、该操作步骤使用的软件为Excel,版本为office家庭和学生版2016,其他版本的office或WPS均可参考本方法。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b17eca8065380cd751250cc1af44ad34598281e7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、首先新建一张Excel表格并在表格中输入姓名日期,然后插入一行模拟数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/503d269759ee3d6ddef029e74d166d224f4adeec?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、讲我们想要靠左下角显示的姓名和年月日等数据选中,然后右键在弹出的列表中,选择设置单元格格式选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0824ab18972bd4070db77dd175899e510fb309ad?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在弹出的设置单元格格式窗口中,我们将选项卡切换到对齐,然后将水平对齐方式设置为靠右,将垂直对齐方式设置为靠下,然后点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/738b4710b912c8fce22359e1f2039245d78821cd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、可以看到被我们选中的数据,现在已经在右下角显示了,如果想选择一行或一列设置成该格式,可以在列标或行标上直接单击选中,然后进行设置即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d31b0ef41bd5ad6ef0d4cac68fcb39dbb6fd3ce8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳