天气预报 > 其他 > excel如何两列乱序姓名对齐
excel如何两列乱序姓名对齐
更新时间: 2020-11-19 00:00:00  

excel姓名有长短不一,看来很杂乱。那么excel如何两列乱序姓名对齐,其实也不难,下面来给大家介绍一下具体对齐的操作步骤;

工具/原料电脑型号:联想笔记本U31-70操作系统:win7Excel:2019方法/步骤1打开excel表格,选中两列乱序姓名;

2然后,鼠标右击—设置单元格格式;

3下一步,选择对齐;

4然后,在水平对齐方式里,选择分散对齐;

5之后,点击确定;

6返回表格,表格中姓名就对齐成功,

总结:1、打开excel表格—选中两列乱序姓名;

2、鼠标右击—设置单元格格式—对齐;

3、在水平对齐—选择分散对齐—确定;

4、返回表格,表格中姓名就对齐成功;

关键词: excel 如何 姓名

excel如何两列乱序姓名对齐相关经验

天气预报

最新推荐

页面:/news/view-834447/ | 耗时:0.3415 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=834447 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=834447 LIMIT 0,1
select * from tbl_Articles_sphinx where id=834447 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(206668,1117850,351397,1079007,1337276,2714794,260008,170521,834943,1128910,1126782,326375,1082485,1079952,1123227,1087713,1102036,290076,1113736,1382795,498507,1132159,1130444,1481703,160865,912307,1801592,851868,434401,220810) ORDER BY field (ArticleID,206668,1117850,351397,1079007,1337276,2714794,260008,170521,834943,1128910,1126782,326375,1082485,1079952,1123227,1087713,1102036,290076,1113736,1382795,498507,1132159,1130444,1481703,160865,912307,1801592,851868,434401,220810)