EXCEL中的快捷键

u      功能键

F1                                                           打开帮助

F2                                                           修改单元格内容

F4                                                           重复上一步的操作

F7                                                           拼写检查

F11                                                          插入图表

u      Ctrl+

Ctrl+0                                                      隐藏列

Ctrl+1                                                      打开单元格格式窗口

Ctrl+2                                                      黑体

Ctrl+3                                                      斜体

Ctrl+4                                                      下画线   

Ctrl+5                                                      删除线

Ctrl+6                                                      好象没事发生

Ctrl+7                                                      隐藏显示"常用"工具栏

Ctrl+8                                                      建立分级显示（干什么的？请教高手）

Ctrl+9                                                      隐藏行

Ctrl+A                                                      选定整个工作表

Ctrl+B                                                      加粗字体格式

Ctrl+C                                                      复制

Ctrl+D                                                     填充上一单元格内容（向下填充）

Ctrl+F                                                      跳出查找窗口

Ctrl+G                                                     跳出定位窗口

Ctrl+H                                                      跳出替换窗口

Ctrl+I                                                       字体倾斜

Ctrl+J                                                      跳出超级连接编辑窗口

Ctrl+N                                                     增加一个新的工作薄

Ctrl+O                                                     跳出打开文件窗口

Ctrl+P                                                      跳出打印窗口

Ctrl+P(或insert)两次                                复制并调出剪贴板。

Ctrl+R                                                      填充左单元格的内容（向右填充）

Ctrl+S                                                      保存文件

Ctrl+U                                                      字体加下划线

Ctrl+V                                                      粘贴

Ctrl+W                                                     关闭当前工作薄

Ctrl+X                                                     剪切

Ctrl+Y                                                      恢复撤消的操作（注：保存文件后不能使用）

Ctrl+Z                                                      撤消上一步操作（注：保存文件后不能使用）

Ctrl+END                                                 去到文件最后面

Ctrl+F1                                                    调出任务窗格（仅限2003版）

Ctrl+F2                                                    预览（仅限2003版）

Ctrl+F6                                                    激活已经打开的EXCEl的各工作簿

Ctrl+F9                                                    最小化窗口

Ctrl+F10                                                  最大化和还原窗口

Ctrl+F11                                                   插入宏表

Ctrl+TAB                                                  激活已经打开的EXCEl的各工作簿

Ctrl+*                                                      Activecell.CurrentRegion.Select

Ctrl+；                                                    输入当前曰期

Ctrl+~                                                      隐藏或显示公式（有点怪异，调好的列宽都变了）

Ctrl+’                                                       填充上一单元格内容（向下填充）

Ctrl+“-”                                                    删除单元格/行/列

Ctrl+"+"                                                   插入单元格/行/列

Ctrl+↓或↑                                                 快速到达列头或尾

Ctrl+←或→                                             快速到达行头或尾

Ctrl+HOME                                              回到文件最前面

Ctrl+INSERT                                            复制

Ctrl+PAGE                                               DOWN   进入后一个工作表

Ctrl+PAGE                                               UP   进入前一个工作表

u      AIt+

AIt+215                                                   ×乘号

AIt+41420                                                √打勾

AIt+41409                                                打叉

Alt+41446                                                ℃摄氏度       （在WORD中成了?，郁闷...）

Alt+247                                                    ÷除号

Alt+128                                                    输入欧元符号

Alt+137                                                    输入千份号‰

Alt+153                                                           商标(tm)

Alt+165                                                    人民币￥

Alt+174                                                    商标(r)

Alt+177                                                    输入正负符号±

Alt+178                                                    上标2

Alt+179                                                    上标3

Alt+185                                                    上标1

Alt+186                                                    上标o

Alt+188                                                    1/4

Alt+189                                                    1/2  

Alt+190                                                    3/4

Alt+ENTER                                              可以在一个单元格里换行。

Alt+；                                                      选定可见单元格(具体做什么的?请教各位高手)

Alt+=                                                       自用输入求和公式

Alt+F11                                                    打开VB编辑器

Alt+Shift+F11                                           打MICROSOFT脚本编辑器

u      Ctrl+Shift+

Ctrl+Shift+；                                            输入当前时间

Ctrl+Shift+_                                             删除选定单元格区域的边框

Ctrl+Shift+↓或↑                                        列的单元格快速选取

Ctrl+Shift+←或→                                     行的单元格快速选取

Ctrl+Shift++8                                           选定相连区域的整个工作表。

Ctrl+shift+9或0                                       取消隐藏

u      Shift+

Shift+F2                                                   在选中单元格插入批注

shift+F3                                                   插入函数

shift+F5                                                   查找/替换

shift+F10                                                 相当于点击鼠标右键。

shift+F11                                                  插入工作表

shift+F11                                                  新建表页

Shift+SPACER                                         可以将自选图形变成文本框，外形不变。