Excel: 数据处理时常用的快捷键

文章背景：Excel的快捷键可以帮助我们提高数据分析的效率。下面介绍在Excel中常用的一些快捷键。

The list is by no means exhaustive. If different, Mac shortcuts are listed in second position.

（1）基本操作

• Undo/Redo CTRL+Z and CTRL+Y | CMD+Z or CMD+Y. Z stands for undo and Y for redo.
• New File/ New Workbook CTRL+N | CMD+N
• Open file / Open Workbook CTRL+O | CMD+O To open the dialogue box and select an existing file (workbook)
• Close file / Close Workbook CTRL+W | CMD+W
• Save file / Save Workbook CTRL+S | CMD+S
• Select all CTRL+A | CMD+A
• Enter a new line of Text ALT + Enter Sometimes when entering data into a cell, you may want to go to a new line below your current one, within the same cell.
• Moving around the worksheet
  • Page Up and Page Down will move one "page" (the number of rows shown on the screen) up or down.
  • CTRL+arrow keys will move to the next blank cell in that direction.
  • CTRL+Home takes you to the first cell that contains data in the top-left corner of the sheet.
  • CTRL+End goes to the last cell in the bottom-right.

（2）公式计算

• F4 (fn + F4 / CMD + T) — Cycle through all 4 types of cell references. (Absolute, Mixed x2, Relative)
• SHIFT + F3 (CTRL + A) — Open Formula Builder/ Function Wizard
• CTRL + PgUp (CMD + PgUp) — Go to the previous sheet.
• CTRL + PgDn (CMD + PgDn) — Go to the next sheet.

（3）单元格格式

• CTRL + SHIFT + & (CMD + OPTION + 0) -- Add a border around the outside of selected cells
• CTRL + B (CMD + B) -- Change selection to Bold Text

（4）数据处理

• CTRL + 0 (CMD + 0) -- Hide the column containing the selected cell.
• CTRL + 9 (CMD + 9) -- Hide the row containing the selected cell.
• CTRL + SHIFT + 0 (CMD + SHIFT + 0) -- Unhide the column containing the selected cell. (Select cells surrounding hidden column)
• CTRL + SHIFT + 9 (CMD + SHIFT + 9) -- Unhide the row containing the selected cell. (Select cells surrounding hidden row)
• CTRL + SHIFT + L (CMD + SHIFT + F) -- Add or remove a filter

（5）表格打印

• CTRL + P | CMD + P: Open Print dialogue
• CTRL + X | CMD + X: Cut selection
• CTRL + C | CMD + C: Copy selection
• CTRL + V | CMD + V: Paste data (from previous cut/copy action)
• CTRL + F2: Open Print Preview window

参考资料：

[1] Excel Skills for Business: Essentials（https://www.coursera.org/learn/excel-essentials?）

延伸阅读：

[1] Windows Shortcuts: Microsoft Office Support pages（https://support.office.com/en-us/article/Excel-keyboard-shortcuts-and-function-keys-for-Windows-1798d9d5-842a-42b8-9c99-9b7213f0040f?ui=en-US&rs=en-US&ad=US）

[2] Mac Shortcuts: Microsoft Office Support pages（https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd）