| Menu | Keyboard | Toolbar |
| File, New | Ctrl + N |
|
| File, Open | Ctrl + O |
|
| File, Close |
Ctrl + W or Ctrl + F4 |
|
| To close all files without exiting Excel |
Shift
key + File/Close All (on menu) |
|
| File, Save | Ctrl + S |
|
| File, Save as | F12 | |
| File, Print | Ctrl + P |
|
| File, Exit | Alt + F4 | |
| File, Print Preview |
|
|
| Edit, Undo | Ctrl + Z |
|
| Edit, Redo | Ctrl + Y |
|
| Edit, Cut | Ctrl + X |
|
| Edit, Copy |
Ctrl + C or Ctrl + Insert |
|
| Edit, Paste |
Ctrl + V or Shift + Insert |
|
| Edit, Select All | Ctrl + A |
|
| Edit, Fill, Down | Ctrl + D | |
| Edit, Fill, Right | Ctrl + R | |
| Edit, Find | Ctrl + F | |
| Edit, Replace | Ctrl + H | |
|
Edit,
Go to (to go to a particular cell) |
Ctrl +
G or F5 |
|
|
Format, Font |
|
|
|
Format, Font (size) |
|
|
|
Format, Font (bold) |
Ctrl + B (toggles on and off) |
|
|
Format, Font (underline) |
Ctrl + U (toggles on and off) |
|
|
Format, Font (italics) |
Ctrl + I (toggles on and off) |
|
|
Format, Font (color) |
|
|
| Display Format, Cells Dialog Box | Ctrl + 1 |
|
Format,
Cells, Alignment |
|
|
|
Format,
Cells, Alignment |
|
|
|
Format,
Cells, Alignment |
|
|
|
Format,
Cells, Alignment |
|
|
|
Format,
Cells, Alignment |
|
|
|
Format,
Cells, Alignment |
|
|
|
Format,
Cells, Numbering |
Ctrl
+ Shift + $ |
|
|
Calculate all worksheets in all open workbooks |
F9 |
|
|
Calculate the active worksheet |
Shift + F9 |
|
|
Create a chart using the current selected range |
F11 |
|
|
Insert today's date |
Ctrl + ; |
|
| Insert current time | Ctrl + Shift + ; | |
| Go to beginning of row | Home | |
| Go to beginning of worksheet | Ctrl + Home | |
| Go to last cell with data in worksheet | Ctrl + End | |
| Insert, Comment/Edit Comment | Shift + F2 | |
| Insert, Row/Column | Ctrl and Shift and + | |
| Delete Row/Column | Ctrl and - | |
|
Insert, Hyperlink |
Ctrl + K |
|
| Insert, Function | Shift + F3 |  |
| Insert, Chart |  |
|
| Tools, Spelling | F7 |  |
|
Help, Microsoft Excel Help |
F1 |
|
|
Help, What's this? |
Shift + F1 |
|
|
Select the entire current column |
Ctrl + Spacebar |
|
|
Select the entire current row |
Shift + Spacebar |
|
|
Select the region around the active cell (area enclosed by blank rows and blank columns) |
Ctrl + Shift + * |
|
|
Extend selection by one cell |
Shift + Arrow Key |
|
|
Extend selection to last non-blank cell (column or row) |
Ctrl + Shift + Arrow Key |
|
|
Select to beginning of row |
Shift + Home |
|
|
Select to beginning of worksheet |
Ctrl + Shift + Home |
|
|
Select to end of worksheet |
Ctrl + Shift + End |
|
|
Select down one screen view |
Shift + Page Down |
|
|
Select up one screen view |
Shift + Page Up |
|
|
Select all objects on worksheet (one must be selected first) |
Ctrl + Shift + Spacebar |
|
| Show or Hide Standard Toolbar | Ctrl + 7 | |
| Select all cells with comments | Ctrl + Shift + O | |
| Select the array to which the current active cell belongs | Ctrl + / | |
|
Select only cells that are directly referred to by formulas in the selection |
Ctrl + [ |
|
| Select only cells with formulas that refer directly to the active cell | Ctrl + ] | |
| View all formulas in worksheet |
Ctrl + ~ |
Note: Press again to return to normal. |
| Move to next sheet in workbook | Ctrl + Page Down | |
| Move to previous sheet in workbook | Ctrl + Page Up | |
|
Copy formula from cell above |
Ctrl + ' |
|
|
Copies contents of cell above |
Ctrl + Shift + ' |
Note: If a formula is present, copies result of formula only and not the formula itself. |