As every application has its own keyboard shortcut keys, Microsoft Excel also has a variety of keyboard shortcuts you can use to boost your work speed and make things more easy.
Here is a list of 100+ Excel Keyboard Shortcuts that will enable you to your lots of time.
Excel Workbook related shortcuts: Here are very common shortcut keys to do operations on workbook.
- Ctrl+N: Create a new workbook
- Ctrl+O: Open an existing workbook
- Ctrl+S: Save a workbook
- F12: Open the Save As dialog box
- Ctrl+W: Close a workbook
- Ctrl+F4: Close Excel
- Shift+F11: Insert a new worksheet
- F7: Check spelling
- Ctrl+F1: Show or hide the ribbon
- Ctrl+Shift+U: Expand or collapse the formula bar
- Ctrl+F9: Minimize the workbook window
- Ctrl+F10: Maximize or Restore Selected Workbook Window.
- Ctrl+Tab: Switch between open workbooks
- Shift+F3: Insert a function
- Alt+F8: Create, run, edit, or delete a macro
- Alt+F11: Open the Microsoft Visual Basic For Applications Editor
Excel Keyboard Shortcuts for Navigation: Here is the list of shortcut keys that you can use to easily navigate throughout your worksheet, within a cell, or throughout your entire workbook.
- Left Arrow: Move One Cell to the left.
- Right Arrow: Move One Cell to the right.
- Up Arrow: Move One Cell Up.
- Down Arrow: Move One Cell Down.
- Page Down: Down One Screen.
- Page Up: Up One Screen.
- ALT+Page Down: Move One Screen to the Right.
- ALT+Page Up: Move One Screen to the Left.
- Ctrl+Left Arrow: Move to the leftmost cell that contains data.
- Ctrl+Right Arrow:Move to the rightmost cell that contains data.
- Ctrl+Up Arrow: Move to the topmost cell that contains data.
- Ctrl+Down Arrow: Move to the downmost cell that contains data.
- Ctrl+Home: Move to the first cell of a worksheet
- Home: Move to the leftmost cell in the current row.
- Tab: Move to the next cell in the current row.
- Shift+Tab: Move to the previous cell in the current row.
- Ctrl+End: Move to the most bottom right used cell.
- Ctrl+Page Down: Move to Next Worksheet.
- Ctrl+Page Up: Move to the Previous Worksheet.
Excel Keyboard Shortcuts for Selecting Cells: Using the below given combination of keys, you can extend selection of cells.
- Shift+Right Arrow: Extend the cell selection to the right.
- Shift+Left Arrow: Extend the cell selection to the left.
- Shift+Space: Select the entire row.
- Ctrl+Space: Select the entire column.
- Ctrl+Shift+Space: Select the entire worksheet.
- Ctrl+A: Select the Current Data Region.
- Ctrl+Shift+*: Select the Current Data Region around the active cell.
Excel Keyboard Shortcuts for Formatting Cells: These combinations of keys would make formatting of cells easier for you.
- Ctrl+B: Add or remove bold to the contents of a cell, selected data, or selected cell range
- Ctrl+I: Add or remove italics to the contents of a cell, selected data, or selected cell range
- Ctrl+U: Add or remove underline to the contents of a cell, selected data, or selected cell range
- Ctrl+5:Apply or remove strikethrough
- Ctrl+1: Open the Format Cells dialog box
- Ctrl+Shift+%: Apply percent format with No Decimal Places.
- Ctrl+Shift+$: Apply currency format with Two Decimal Places.
- Ctrl+Shift+~: Apply the General Number Format.
- Ctrl+Shift+!: Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values.
- Ctrl+Shift+#: Apply the Date format with the Day, Month, and Year.
- Alt+H+F+G: Increase Font Size by One Step.
- Alt+H+F+K: Decrease Font Size by One Step.
Excel Keyboard Shortcuts for Editing Cells: These shortcut keys will enable you edit cells.
- F2: Edit a cell
- Shift+F2: Add or edit a cell comment
- Delete: Remove the contents of a cell, selected data, or selected cell range
- Esc: Cancel an entry in a cell or the formula bar
- Enter: Complete an entry in a cell or the formula bar
Excel Keyboard Shortcuts to Hide/Unhide Rows or Columns: These shortcut keys will enable you hide, unhide rows or columns.
- Ctrl+9: Hide Selected Rows.
- Ctrl+Shift+9: Unhide Selected Rows in selection.
- Ctrl+0: Hide Selected Columns.
- Ctrl+Shift+0: Unhide Selected Columns in selection.
Excel Keyboard Shortcuts to Conditional Formatting: These shortcut keys allow you to apply conditional formatting on cells.
- ALT+O+D: Open Conditional Formatting Dialogue Box.
- ALT+H+L:+C+S: Clear Conditional from Selected Cells.
- ALT+H+L:+C+S+E: Clear Conditional from the Entire Worksheet.
- Enter: Enter and Move Down.
- Ctrl+Enter: Enter and Remain on the Same Cell.
- Shift+Enter: Enter and Move Up.
- Tab: Enter and Move right.
- Shift+Tab: Enter and Move left.
- Ctrl+Enter: Enter Same Data in All Selected Cells.
- Alt+Down Arrow: Display AutoComplete list.
- Ctrl+D: Fill Down.
- Ctrl+R: Fill Right.
- Ctrl+;: Insert Current Date.
- Ctrl+Shift+;: Insert Current Time.
- Ctrl+T: Insert Table.
- Ctrl+K: Insert Hyperlinks.
Excel Keyboard Shortcuts to Clear: These shortcut keys allow you to clear content, format and hyperlinks from the cells.
- Alt+H+E+F: Clear Formats Only.
- Alt+H+E+C: Clear Content Only.
- Alt+H+E+L: Clear Hyperlinks Only.
- Alt+H+E+M: Clear Comments Only.
- Alt+H+E+A: Clear Everything.
Other Useful Keyboard Shortcuts for Excel: Here is the list of many useful shortcut keys that will enable you to perform many useful tasks of Excel application with a boosted speed.
- Ctrl+Shift+L: Apply Data Filter.
- Alt+A+T: Apply Data Filter.
- Alt+Down Arrow: Activate Filter.
- Ctrl+Plus: Insert row or column.
- Ctrl+Minus: Delete row or column
- Ctrl+Alt+V: Display Paste Special Dialogue Box.
- Alt+E+S:Display Paste Special Dialogue Box.
- Ctrl+Shift+U: Expand or Collapse Formula Bar.
- F4: Switch Cell Reference from Absolute to Relative.
- Alt+N+V: Display Insert Pivot Table Dialogue Box.
It’s not easy to remember all shortcut keys and no one expects you remember all of them. However, frequent use of shortcut keys will make it easy for you remember them.