Keyboard Shortcuts for Microsoft Excel
Table compiled by Patricia I. Kwan
|
Formatting |
|
|
To alter text/entries
within a cell rather than moving to the entry box at top |
F2 |
|
Open Format Cells dialog box |
CTRL+1 (one) |
|
Strike through text
in cell |
CTRL+5 |
|
Currency format |
CTRL+SHIFT+$ |
|
General number format |
CTRL+SHIFT+~ |
|
Comma number format |
CTRL+SHIFT+! |
|
Percentage number format |
CTRL+SHIFT+% |
|
Apply Borders |
|
|
Apply or remove top border |
ALT+T |
|
Apply or remove bottom border |
ALT+B |
|
Apply or remove left border |
ALT+L |
|
Apply or remove right order |
ALT+R |
|
If cells in multiple rows are selected, apply or remove horizontal
divider |
ALT+H |
|
If cells in multiple columns are selected, apply or remove vertical
divider |
ALT+V |
|
Apply or remove downward diagonal border |
ALT+D |
|
Apply or remove upward diagonal border |
ALT+U |
|
Cell Content |
|
|
Fill to the Right |
CTRL+R |
|
Fill Down |
CTRL+D |
|
Copy the value from the cell above the current cell |
CTRL+SHIFT+" (quotation mark) |
|
Copy the formula from the cell above the current cell |
CTRL+' (apostrophe) |
|
Enter
date |
CTRL+; (semicolon) |
|
Enter time |
CTRL+: (colon) |
|
Moving around sheets/cells |
|
|
Move between worksheets |
CTRL+PageUp or PageDown |
|
Move to first cell in current column |
CTRL+Up Arrow |
|
Move to last cell in current column |
CTRL+Down Arrow |
|
Move to first cell in current row |
CTRL+Left Arrow |
|
Move to last cell in current row |
CTRL+Right Arrow |
|
Go to first cell in sheet (A1) |
CTRL+Home |
|
Go to last cell (last row, last column) |
CTRL+End |
|
Rows and Columns |
|
|
Hide column |
CTRL+0 (zero) |
|
Unhide column |
SHIFT+CTRL+( |
|
Hide row |
CTRL+9 |
|
Unhide row |
SHIFT+CTRL+( |
|
Insert row |
CTRL+Plus Sign |
|
Delete row |
CTRL+Minus Sign |
|
Hide column |
CTRL+0 (zero) |
|
Select from active cell to last cell in used range |
CTRL+SHIFT+End |
|
Select from active cell to first cell in sheet (A1) |
CTRL+SHIFT+Home |
|
Select row(s) corresponding to selected cell(s) |
SHIFT+Spacebar |
|
Select column(s) corresponding to selected cell(s) |
CTRL+Spacebar |
|
Miscellaneous |
|
|
Alternate between displaying cell values and displaying formulas |
CTRL+` (single left quotation mark) |
|
Create a graph |
Select data range in worksheet. Press F11 key. |
|
AutoSum |
ALT+= |
|
To attach Comment to a cell |
SHIFT+F2 |
|
Insert Function dialog box |
SHIFT+F3 |
|
Insert new worksheet |
SHIFT +F11 |
|
Close Excel |
ALT+F4 |
July 2006