Here is a comprehensive list of more than 125 keyboard shortcuts in Excel. You can download the entire list of keyboard shortcut keys as an Excel workbook here. These shortcuts cover formatting cells and worksheets, inserting rows and columns, calculations, handling workbooks and a number of other useful keys that will make you an Excel Keyboard expert in no time.
Shortcut key | Action |
Alt or F10 | Activate menu |
Alt + ’ | Format Style dialog box |
Alt + = | AutoSum |
Alt + Down arrow | Display AutoComplete list |
Alt + Enter | Start a new line in the same cell |
Alt + Esc | Toggle Between most recent two applications in taskbar |
Alt + F1 | Insert a Chart sheet |
Alt + F11 | Open Visual Basic Editor |
Alt + F2 | Save As |
Alt + F4 | Exit Workbook |
Alt + F8 | Macro dialog box |
Alt + i + c | Insert column |
Alt + i + r | Insert row |
Alt + Shift + F1 | New worksheet |
Alt + Shift + F2 | Save Workbook |
Ctrl W | Close Workbook |
Ctrl + – | Delete |
Ctrl + " | Copy Value from Cell Above |
Ctrl + : | Insert Current Time |
Ctrl + ; | Insert Current Date |
Ctrl + 0 | Hide columns |
Ctrl + 1 | Format cells dialog box |
Ctrl + 2 | Bold |
Ctrl + 3 | Italic |
Ctrl + 4 | Underline |
Ctrl + 5 | Strikethrough |
Ctrl + 6 | Show/Hide objects |
Ctrl + 7 | Show/Hide Standard toolbar |
Ctrl + 8 | Toggle Outline symbols |
Ctrl + 9 | Hide rows |
Ctrl + A | Select All Cells in range |
Ctrl + Alt + F9 | Forces FULL calculation of all worksheets in all open workbooks |
Ctrl + Alt + Shift + F9 | Forces FULL calculation with dependency tree rebuild |
Ctrl + B | Bold |
Ctrl + C | Copy |
Ctrl + D | Fill Down |
Ctrl + End | Move to last used cell in a worksheet |
Ctrl + Enter | Fill the selected cell range with the current entry. |
Ctrl + F | Find |
Ctrl + F10 | Maximize or restore window |
Ctrl + F11 | Inset 4.0 Macro sheet |
Ctrl + F12 | File Open |
Ctrl + F3 | Define name |
Ctrl + F4 | Close |
Ctrl + F5 | XL, Restore window size |
Ctrl + F6 | Next workbook window |
Ctrl + F7 | Move window |
Ctrl + F8 | Resize window |
Ctrl + F9 | Minimize workbook |
Ctrl + G | Goto |
Ctrl + H | Replace |
Ctrl + Home | Move to the first non-header cell of the sheet |
Ctrl + I | Italic |
Ctrl + K | Insert Hyperlink |
Ctrl + N | New Workbook |
Ctrl + N | New Workbook |
Ctrl + O | Open |
Ctrl + P | |
Ctrl + Page Down | Move to next worksheet |
Ctrl + Page Up | Move to previous worksheet |
Ctrl + R | Fill Right |
Ctrl + Right Arrow | Move to right end of range |
Ctrl + Right Arrow | Move to right end of range |
Ctrl + S | Save |
Ctrl + Shift + ! | Comma format |
Ctrl + Shift + + | Insert Cells, Rows, Columns |
Ctrl + Shift + # | Date format |
Ctrl + Shift + $ | Currency format |
Ctrl + Shift + % | Percent format |
Ctrl + Shift + & | Place outline border around selected cells |
Ctrl + Shift + ( | Unhide rows |
Ctrl + Shift + ) | Unhide columns |
Ctrl + Shift + * | Select current region |
Ctrl + Shift + @ | Time format |
Ctrl + Shift + ^ | Exponential format |
Ctrl + Shift + _ | Remove outline border |
Ctrl + Shift + ~ | General format |
Ctrl + Shift + 1 | Format cell to two decimal places |
Ctrl + Shift + 2 | Format cell to time |
Ctrl + Shift + 3 | Format cell to date |
Ctrl + Shift + 4 | Format cell to currency |
Ctrl + Shift + 5 | Format cell to percentage |
Ctrl + Shift + 6 | Format cell to scientific notation |
Ctrl + Shift + 7 | Draws outline around your selection |
Ctrl + Shift + A | Insert argument names into formula |
Ctrl + Shift + Enter | Used to enter an array formula |
Ctrl + Shift + F12 | |
Ctrl + Shift + F3 | Create name by using names of row and column labels |
Ctrl + Shift + F6 | Previous Window |
Ctrl + Spacebar | Select the current column |
Ctrl + Tab | In a workbook: activate next workbook |
Ctrl + U | Underline |
Ctrl + V | Paste |
Ctrl + X | Cut |
Ctrl + Y | Repeat |
Ctrl + Z | Undo |
Enter | Do the command |
F1 | Help |
F10 | Activate Menubar |
F11 | New Chart |
F12 | Save As |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat last action |
F4 | While typing a formula, switch between absolute/relative refs |
F5 | Goto |
F6 | Next Pane |
F7 | Spell check |
F8 | Extend mode |
F9 | Recalculate all workbooks |
Shift | Hold down shift for additional functions in Excel’s menu |
Shift + Ctrl + F | Font Drop Down List |
Shift + Ctrl + F + F | Font tab of Format Cell Dialog box |
Shift + Ctrl + F6 | Previous workbook window |
Shift + Ctrl + P | Point size Drop Down List |
Shift + Ctrl + Tab | In toolbar: previous toolbar |
Shift + Ctrl + Tab | In a workbook: activate previous workbook |
Shift + Enter | Go to previous cell |
Shift + F1 | What’s This? |
Shift + F10 | Display shortcut menu |
Shift + F11 | New worksheet |
Shift + F12 | Save |
Shift + F2 | Edit cell comment |
Shift + F3 | Paste function into formula |
Shift + F4 | Find Next |
Shift + F5 | Find |
Shift + F6 | Previous Pane |
Shift + F8 | Add to selection |
Shift + F9 | Re-calculate active worksheet |
Shift + Spacebar | Select the current row |
Shift + Tab | Previous application in taskbar |
Tab | Next tool |
Wow…Great collection. I see a lot of good information here. I will come back for more.
April 29th, 2009 at 2:11 pmGood very very useful ……………
April 2nd, 2018 at 6:41 amYour information is use full and very creative for office professional but advance Excel more use full by graphicaion
June 19th, 2018 at 11:54 amThat’s nice to learn
October 2nd, 2018 at 2:47 amtotal advance excel keys alt , ctrl , shift keys 2010 least excel keys total
March 17th, 2019 at 4:09 am