Categorized | excel tips

Excel Keyboard Shortcuts – A list of 125+ Keyboard Shortcuts in Excel

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 Print
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 Print
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


What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Comments and Trackbacks

  1. Amit wrote:

    Wow…Great collection. I see a lot of good information here. I will come back for more.

  1. Keyboard Shortcuts in Excel to Sort, Add, Hide Pivot Table Items and Fields | Excel & VBA - da Tab Is On wrote:

    […] And now here’s the bonus – a list of more than 125 keyboard shortcuts in Excel […]


Chinese (Simplified)DutchEnglishFilipinoFrenchGermanHebrewHindiItalianJapanesePortugueseRussianSpanish

treeemap software for excel