Excel keyboard shortcuts are essential for working efficiently. Here’s a categorized list of the most useful shortcuts:
1. General Shortcuts
- Ctrl + N: Create a new workbook
- Ctrl + O: Open an existing workbook
- Ctrl + S: Save the current workbook
- Ctrl + P: Open the print menu
- Ctrl + W: Close the current workbook
- Ctrl + Z: Undo last action
- Ctrl + Y: Redo last undone action
- Alt + F4: Close Excel
2. Navigation
- Arrow Keys: Move one cell up, down, left, or right
- Ctrl + Arrow Key: Jump to the edge of data (row/column)
- Ctrl + Home: Go to the beginning of the worksheet
- Ctrl + End: Go to the last cell with data
- Page Up/Page Down: Move one screen up or down
- Alt + Page Up/Alt + Page Down: Move one screen left or right
3. Editing and Formatting
- F2: Edit the active cell
- Ctrl + X: Cut selected cells
- Ctrl + C: Copy selected cells
- Ctrl + V: Paste copied/cut cells
- Ctrl + B: Apply or remove bold formatting
- Ctrl + I: Apply or remove italic formatting
- Ctrl + U: Apply or remove underline formatting
- Ctrl + Shift + $: Apply currency format
- Ctrl + Shift + %: Apply percentage format
- Ctrl + Shift + #: Apply date format
4. Selection and Highlighting
- Shift + Arrow Key: Extend selection one cell
- Ctrl + Shift + Arrow Key: Extend selection to the end of the range
- Ctrl + A: Select entire worksheet or table
- Shift + Space: Select the entire row
- Ctrl + Space: Select the entire column
5. Working with Formulas
- =: Start a formula
- Alt + =: Insert the SUM function
- Ctrl + `: Show/hide formulas
- F4: Toggle absolute/relative cell references in a formula
- Ctrl + Shift + Enter: Enter an array formula
6. Data Management
- Ctrl + T: Convert a range into a table
- Ctrl + Shift + L: Toggle filters
- Ctrl + ;: Enter the current date
- Ctrl + Shift + :: Enter the current time
- Alt + Down Arrow: Open the drop-down menu for a filtered column
7. Insert and Delete
- Ctrl + “+”: Insert cells/rows/columns
- Ctrl + “-“: Delete cells/rows/columns
- Shift + F10: Open the context menu
- Alt + H, R, A: Rename a worksheet
8. Advanced Features
- Alt + F1: Create a default chart from selected data
- Alt + F8: Open the Macro dialog box
- Ctrl + Shift + U: Expand or collapse the formula bar
- Alt + H, O, I: Auto-fit column width
9. PivotTables
- Alt + N, V: Insert a PivotTable
- Alt + F5: Refresh the PivotTable
- Alt + J, T, S: Select PivotTable data
10. File and Workbook Management
- Ctrl + Tab: Switch between open workbooks
- Ctrl + F: Open the Find dialog box
- Ctrl + H: Open the Replace dialog box
- Ctrl + Shift + N: Open the format cell dialog box
Pro Tip:
Learn the Alt Key Shortcuts to access menu items quickly. For example:
- Alt + H: Open the Home tab
- Alt + N: Open the Insert tab
- Alt + P: Open the Page Layout tab
Printable Excel Shortcuts PDF
Download the complete list of Excel Keyboard Shortcuts for offline use.
At The Coding College, we help learners master Excel efficiently. Use these shortcuts to boost your productivity and save time!