Learn All About New Microsoft Excel Shortcut Keys : MS Excel is a very popular and most used product of Microsoft Office throughout world, Excel used for data analysis, creating charts, doing calculation, organizing, reporting and used for many more things, but excel is not user-friendly as MS Word, because in Excel many shortcut keys different compared to word.
But why we used shortcut keys, using mouse sometime click on wrong options and take time and energy to perform the task, but using shortcut keys save lot of time and energy and perform task accurately, helps speedup work, increase efficiency, consistency, productivity. Below the complete shortcut keys list of Microsoft Excel some are new and some are old, these shortcut keys will support all the version of MS Excel including Microsoft Excel 365.
Microsoft Excel Shortcut Keys
| Ctrl+PageDown | Go to next sheet |
| Ctrl+PageUp | Goto previous sheet |
| Alt+H,A,C | Center Alignment |
| Alt+H,A,L | Left Alignment |
| Alt+H,A,R | Right Alignment |
| Ctrl + Shift + 1 | Insert 00 |
| Ctrl+Shift+Tilde (~) | Remove 00 |
| Ctrl+N | Create new workbook |
| Ctrl+O | Open File |
| Ctrl+S | Save |
| Ctrl+W | Close File |
| Ctrl+F4 | Close Excel |
| F2 | Edit cell |
| F7 | Spell Check |
| Alt+P,I | Row & column repeat |
| Alt+P,V,G | Hide & Show Girdlines |
| Alt+H,H | Fill color |
| Alt+H,F,C | Text color |
| Alt+H,B | Add border |
| Tab | Move to next cell |
| Shift+Tab | Move to previous cell |
| Ctrl+Shift+Right arrow | Select all cells (right) |
| Ctrl+Shift+Left Arrow | Select all cells (left) |
| Ctrl+Shift+Down Arrow | Select column (top) |
| Ctrl+Shift+Up Arrow | Select column (bottom) |
| Shift+F2 | Add comment |
| Ctrl+H | Open find & replace |
| Ctrl+Shift + L | Activate filter |
| Ctrl+(;) | Insert current date |
| Ctrl+Shift+(:) | Insert current time |
| Ctrl+K | Insert hyperlink |
| Ctrl+Shift+ $ | Add currency symbol |
| Ctrl+Shift+% | Add percent symbol |
| Alt+Q | Go to Search box |
| Shift+Space | Select entire row |
| Ctrl+Space | Select entire column |
| Alt+H+D+C | Delete column |
| Shift+Space, Ctrl + (-) | Delete a row |
| Ctrl+9 | Hide row |
| Ctrl+Shift+9 | Unhide row |
| Alt+P,S,P | Open Page setup |
| Alt+H,F,F | Font Style |
| Alt+H,F,S | Font size |
| Alt+H,F,C | Text Color |
| Alt+H,M | Merge cell |
| Alt+H,T | Table style |
| Alt+H,O,A | Autofit Cell |
| Ctrl+0 | Hide column |
| Ctrl+Shift+0 | Unhide column |
| Alt+F1 | Create chart |
| F11 | Create chart on new worksheet |
| Ctrl+W | Close a workbook. |
| Ctrl+O | Open a workbook. |
| Ctrl+Home | Move to beginning |
| Ctrl+Home | Move to end |
| Ctrl+Page Sown & Up | Move between workbook. |
| Ctrl+Alt+Equal (=) | Zoom in. |
| Ctrl+Alt+Minus (-) | Zoom out |
| Ctrl+1 | Open Format Cells |
| Ctrl+Alt+V | Open the Paste Special dialog box. |
| Ctrl+D | Apply cell format |
| Ctrl+Q | Open Quick Analysis options |
| Ctrl+L | Create Table dialog box. |
| Ctrl+Shift+G | Workbook Statistics |
| Ctrl+A | Select entire worksheet. |
| Ctrl+Shift+Arrow key | Select cell next to blank |
| Alt+Enter | New line in same cell. |
| Ctrl+Y | Redo |
| Ctrl+Z | Undo |
| Ctrl+Shift+U | Expand or collapse formula bar. |
| Ctrl+Shift+End | Select all text to the end |
| Alt+Equal sign (=) | Add AutoSum formula |
| Shift+F3 | Insert a function. |
| Alt+F8 | Open Macro |
| Alt+F11 | Open Visual Basic |
| Ctrl+F1 | Show/hides ribbon |
| Shift+F7 | Displays Reference task |
| Shift+F11 | Inserts new sheet |
| Shift+Tab | Move previous cell |
| Alt+’ (single quote) | Open Style dialog box |
| Ctrl+(-) | Delete Cells dialog box |
| Ctrl+Shift+ (+) | Insert Cells dialog box |
| Ctrl+Alt+V | Displays the Paste Special dialog box |
| Alt+E,L | Delete worksheet |
| Alt+I,S | Insert symbol |
| =* | Select cell do product (Into) |
| = Page up | Link formula between sheet |
| F5 | Go to a specific cell |
| Ctrl+S | Save a workbook. |
| Ctrl+C | Copy selection. |
| Ctrl+V | Paste selection. |
| Ctrl+Z | Undo |
| Ctrl+X | Cut |
| Ctrl+B | Apply bold formatting. |
| Alt+P | Go to the Page Layout tab. |
| Alt+H,E,F | Clear Text Formatting |
| Alt+H,S | Sort & Filter |
| Alt+H,F,E | Analyz Data |
| Alt+N,H1 | Header & Footer |
| Alt+P,O | Landscape & Portrait |
| Alt+P,B | Insert & Remove page break |
| Alt+P,G | Insert background image |
| Alt+M,H | Show Formulas |
| Alt+W,I | View Page break |
| Alt+W,L | View normal |
| Alt+W,P | View Page Layout |
| Alt+W,F,R | Freeze top row |
| Alt+W,S | Split window |