天气预报 > 生活 > excel办公技巧
excel办公技巧
更新时间: 2021-02-28 21:23:48  

1、输入当前日期和时间,当前日期:按快捷键【Ctrl+;】,当前时间:按快捷键【Ctrl+Shift+;】。

2、同时显示日期和星期,打开Excel表格,选中单元格并右击,点击【设置单元格格式】,然后点击【数字】——【自定义】,输入类型: yyyy-mm-dd aaaa。

3、快速调整两列位置,选中整列,长按Shift键不放,使鼠标指针变为十字,即可移动位置。

4、删除重复值,直接选中区域,然后点击【数据】——【删除重复值】,找出重复数据并删除。

关键词: excel 办公 技巧

excel办公技巧相关经验

天气预报

最新推荐

页面:/news/view-3425108/ | 耗时:0.1490 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=3425108 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3425108 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3425108 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1155105,506000,1066082,1080531,562654,418441,378350,391169,369781,583405,1059765,514841,391601,509728,523072,537948,546740,475034,538139,460444,471669,457447,500826,380227,504497,434818,463129,533467,389613,520117) ORDER BY field (ArticleID,1155105,506000,1066082,1080531,562654,418441,378350,391169,369781,583405,1059765,514841,391601,509728,523072,537948,546740,475034,538139,460444,471669,457447,500826,380227,504497,434818,463129,533467,389613,520117)