Regardless of which Microsoft Excel version you have, these shortcut keys work flawlessly in any of them. Here are some essential and advanced Excel keyboard shortcuts to help you work faster and more efficiently:

See also how to copy a list of file names and paste as text in Excel.

Essential and advanced Excel keyboard shortcut keys

🟢 Basic Excel shortcuts

• Ctrl + C → Copy
• Ctrl + X → Cut
• Ctrl + V → Paste
• Ctrl + Z → Undo
• Ctrl + Y → Redo
• Ctrl + S → Save
• Ctrl + P → Print
• Ctrl + F → Find
• Ctrl + H → Replace

📊 Navigation & selection

• Arrow Keys → Move between cells
• Ctrl + Arrow Keys → Jump to the edge of the data range
• Shift + Arrow Keys → Select cells
• Ctrl + Shift + Arrow Keys → Select a range of cells
• Ctrl + Home → Move to cell A1
• Ctrl + End → Move to the last used cell
• Page Up / Page Down → Move one screen up/down
• Alt + Page Up / Page Down → Move one screen left/right

🔢 Formatting & editing

• Ctrl + B → Bold
• Ctrl + I → Italic
• Ctrl + U → Underline
• Ctrl + 1 → Open Format Cells dialog
• Ctrl + Shift + $ → Apply currency format
• Ctrl + Shift + % → Apply percentage format
• Ctrl + Shift + # → Apply date format
• Ctrl + Shift + @ → Apply time format
• Ctrl + Shift + L → Toggle filters

📑 Working with worksheets

• Ctrl + N → Create a new workbook
• Ctrl + O → Open a file
• Ctrl + W → Close the workbook
• Ctrl + Page Up / Page Down → Switch between sheets
• Shift + F11 → Insert a new sheet
• Alt + H + O + R → Rename a worksheet

📈 Formulas & Functions

• = (Equal sign) → Start a formula
• Alt + = (Equal sign) → AutoSum (Sum up a range)
• F2 → Edit a formula in a cell
• Shift + F3 → Open Insert Function dialog
• Ctrl + Shift + Enter → Enter an array formula
• Ctrl + `[Backtick] → Show all formulas
• F4 → Repeat last action or toggle absolute/relative cell references ($A$1 → A1 → $A1 → A$1)

📌 Special shortcuts

• Ctrl + T → Convert data into a table
• Ctrl + Space → Select the entire column
• Shift + Space → Select the entire row
• Ctrl + Shift + “+” → Insert a new row or column
• Ctrl + “-“ → Delete a row or column
• Ctrl + Alt + V → Open Paste Special dialog
• Ctrl + 9 → Hide selected rows
• Ctrl + 0 → Hide selected columns

🔄 Data & Pivot Table shortcuts

• Alt + D + P → Open PivotTable Wizard
• Alt + N + V → Insert PivotTable
• F9 → Refresh all calculations
• Alt + A + R → Refresh PivotTable
• Ctrl + Shift + L → Turn on/off filters

🔥 Bonus: Power user shortcuts

• Alt + H + H → Open Fill Color menu
• Ctrl + Alt + F9 → Force calculate all worksheets
• Ctrl + ; (semicolon) → Insert the current date
• Ctrl + Shift + ; (semicolon) → Insert the current time
• Alt + Enter → Insert a new line in a cell

There’s a ton more, but these should speed up your workflow significantly!