📊 Microsoft Excel Shortcut Keys You Should Know

🟢 Basic Shortcuts
• Ctrl + N: New workbook
• Ctrl + O: Open workbook
• Ctrl + S: Save
• Ctrl + Shift + S: Save As
• Ctrl + P: Print
• Ctrl + W: Close workbook
• Alt + F4: Close Excel
• Ctrl + Z: Undo
• Ctrl + Y: Redo / Repeat
• Ctrl + C: Copy
• Ctrl + X: Cut
• Ctrl + V: Paste
• Ctrl + A: Select all
• Ctrl + F: Find
• Ctrl + H: Find & Replace

🟡 Navigation
• Arrow Keys: Move one cell
• Ctrl + Arrow Key: Jump to edge of data region
• Home: Beginning of row
• Ctrl + Home: Go to A1
• Ctrl + End: Go to last used cell
• Page Up: Move one screen up
• Page Down: Move one screen down
• Alt + Page Up: Move one screen left
• Alt + Page Down: Move one screen right
• F5 / Ctrl + G: Go To

🔵 Selecting Data
• Shift + Arrow: Extend selection
• Ctrl + Shift + Arrow: Select to edge of data
• Ctrl + Space: Select entire column
• Shift + Space: Select entire row
• Ctrl + A: Select current data region / all data
• Ctrl + Shift + Space: Select entire worksheet

🟣 Editing Cells
• F2: Edit active cell
• Enter: Confirm entry / move down
• Shift + Enter: Confirm / move up
• Tab: Confirm / move right
• Shift + Tab: Move left
• Esc: Cancel entry
• Delete: Clear cell contents
• Ctrl + Enter: Fill selected cells with current entry
• Alt + Enter: New line inside a cell

🟠 Formatting
• Ctrl + B: Bold
• Ctrl + I: Italic
• Ctrl + U: Underline
• Ctrl + 1: Format Cells
• Ctrl + Shift + ~: General format
• Ctrl + Shift + $: Currency format
• Ctrl + Shift + %: Percentage format
• Ctrl + Shift + #: Date format
• Ctrl + Shift + @: Time format
• Ctrl + Shift + !: Number format
• Ctrl + 5: Strikethrough

🟤 Rows & Columns
• Ctrl + +: Insert cells/rows/columns
• Ctrl + -: Delete cells/rows/columns
• Ctrl + 9: Hide selected rows
• Ctrl + Shift + 9: Unhide rows
• Ctrl + 0: Hide selected columns
• Ctrl + Shift + 0: Unhide columns
• Alt + H, O, I: AutoFit column width
• Alt + H, O, A: AutoFit row height

On some Windows configurations, Ctrl + Shift + 0 may be intercepted by the operating system.

🟧 Formula Shortcuts
• =: Start a formula
• F4: Toggle absolute/relative references while editing a formula
• Ctrl + `: Show/hide formulas
• Shift + F3: Insert Function
• Alt + =: AutoSum
• F9: Calculate formulas
• Ctrl + Shift + Enter: Enter legacy array formula
• Ctrl + ': Copy formula from cell above
• Ctrl + Shift + ": Copy value from cell above

🟥 Data & Tables
• Ctrl + T: Create Table
• Ctrl + Shift + L: Turn filters on/off
• Alt + Down Arrow: Open filter/drop-down menu
• Ctrl + E: Flash Fill
• Alt + A, S, A: Sort A to Z
• Alt + A, S, D: Sort Z to A
• Alt + A, M: Remove Duplicates
• Alt + A, V, V: Data Validation
• Alt + A, Q: Quick Analysis

🟦 Worksheet Shortcuts
• Shift + F11: Insert new worksheet
• Alt + Shift + F1: Insert new worksheet
• Ctrl + Page Up: Previous worksheet
• Ctrl + Page Down: Next worksheet
• Alt + H, O, R: Rename worksheet
• Alt + H, D, S: Delete worksheet

🟪 PivotTable Shortcuts
• Alt + N, V: Insert PivotTable
• Alt + F5: Refresh selected PivotTable
• Ctrl + Alt + F5: Refresh all data
• Alt + Down Arrow: Open field/filter menu
• Ctrl + -: Collapse/remove selected items depending on context

⚡ Power User Shortcuts
• Ctrl + Shift + L: Filter
• Ctrl + E: Flash Fill
• Ctrl + T: Excel Table
• Alt + =: AutoSum
• Ctrl + 1: Format Cells
• F4: Repeat action / lock cell reference in formulas
• F7: Spelling
• F11: Create chart
• Alt + F1: Create chart in current worksheet
• Ctrl + K: Insert hyperlink
• Ctrl + ;: Insert current date
• Ctrl + Shift + ;: Insert current time

Double Tap ❤️ For More