List of Microsoft Excel Shortcut keys
Quick Tasks Made Easy: Discover Microsoft Excel Shortcut Keys
| Tab Left cell to right cell | Shift + Tab Right cell to left cell |
| Ctrl + END Moves to last used cell | Ctrl + HOME Moves to the first used cell |
| Ctrl + Page Down Moves to the next sheet in a workbook | Ctrl + Page Up Moves to the previous sheet in a workbook |
| Alt + Page Down Moves one screen to the right in a worksheet | Alt + Page Up Moves one screen to the left in a worksheet |
| Ctrl + G or F5 Go to dialog box/Go to specific cell | Ctrl + Spacebar Select an entire column |
| Shift+ Spacebar Select an entire row | F2 Edit the selected cell |
| F7 Spell Check | F11 Create Chart |
| Ctrl + O Open option | Ctrl + N Open New Document |
| Ctrl + P Open the print dialog box | Ctrl + F2 Print Preview |
| Ctrl + S Save | Ctrl + Z Undo the last action |
| Ctrl + F9 Minimize current window | Ctrl + F10 Maximize the currently selected window |
| Ctrl + F6 Switch between open workbooks/windows | Ctrl + W Close the selected workbook |
| Ctrl + A Select all contents | Ctrl + B Bold Highlighted selected text |
| Ctrl + B Italic Highlighted selected text | Ctrl + C Copy selected text |
| Ctrl + V Paste | Ctrl + D Fill |
| Ctrl + K Insert Link | Ctrl + F Open the Find and Replace option |
| Ctrl + 5 Strikethrough highlighted text | Ctrl + Shift + ; Enter the current time |
| Ctrl + ; Enter the current date | Alt + Shift + F1 Insert new worksheet |
| Shift + F3 Open the Excel formula window | Shift + F5 Bring up the search box |
| Ctrl + 1 Displays the format cell box | Ctrl + Shift + ~ Applies general format |
| Ctrl + Shift + $ Applies currency format(2 decimal) | Ctrl + Shift + % Applies percentage format(no decimal) |
| Ctrl + Shift + # Applies date format | Ctrl + Shift + @ Applies time format |
| Ctrl + Shift +! Applies number format(2 decimal, thousand separator) | Ctrl + Alt + V Paste Special dialog box |
| Alt + = Autosum | Alt + F8 Open the Macro Dialog box |
| Alt + F11 Open VB editor | Alt + D + L Data validation |
| Alt + D + P Open pivot table wizard | F12 Displays Save as dialog box |
