一、EXCEL:
1 Ctrl+D 向下填充相同内容
2 Ctrl+E "一键提取单元格内容
(2013以上才有此功能)"
3 Ctrl+G 定位
4 Ctrl+J 输入换行符
5 Ctrl+M 左缩进
![](https://img.haomeiwen.com/i15053100/a495d7a9cb039768.jpg)
6 Ctrl+Q 启动快速分析
7 Ctrl+T 快速创建工作表
![](https://img.haomeiwen.com/i15053100/e5e18b3b2419d3b0.jpg)
二、EXCEL\WORD\PPT三者共有:
1 Ctrl+A 全选
2 Ctrl+B 加粗(=Ctrl+2)
3 Ctrl+C 复制
4 Ctrl+F 查找
5 Ctrl+H 替换
![](https://img.haomeiwen.com/i15053100/62535a6a7f88ee7f.jpg)
6 Ctrl+I 斜体(=Ctrl+3)
7 Ctrl+K插入超链接
8 Ctrl+L 左对齐
9 Ctrl+N 创建新文档
10 Ctrl+O 打开文档
![](https://img.haomeiwen.com/i15053100/38ae424dda2aae30.jpg)
11Ctrl+P 打印
12 Ctrl+U 下划线(= Ctrl+4)
13 Ctrl+V 粘贴
14 Ctrl+W 关闭当前文档
15 Ctrl+X 剪切
![](https://img.haomeiwen.com/i15053100/92c61bf2899c32f3.jpg)
16 Ctrl+Y 恢复上一步骤
17 Ctrl+Z 撤销上一步骤
![](https://img.haomeiwen.com/i15053100/bd31be5575b1c085.jpg)
![](https://img.haomeiwen.com/i15053100/af3d4017548042f7.jpg)
网友评论