Excel Shortcut Keys: The Complete List for Windows & Mac (2026)

Excel shortcut keys are combinations of keys that run a command instantly, without reaching for the mouse. The most-used Excel shortcuts are Ctrl + C (copy), Ctrl + V (paste), Ctrl + Z (undo), and Ctrl + S (save). On a Mac, these use the Command key instead: Cmd + C, Cmd + V, Cmd + Z, and Cmd + S. Excel has more than 200 shortcuts across both platforms, and learning even 20 of them noticeably speeds up everyday work.

This guide covers 200+ Excel shortcut actions across 18 categories, with Windows and Mac keys side by side verified against Microsoft’s official documentation for Excel 2024 and Microsoft 365. You can also download the full list as a free PDF.

Key Takeaways

  • Excel shortcut keys trigger commands using key combinations instead of the mouse.
  • The four most-used shortcuts are Copy (Ctrl+C), Paste (Ctrl+V), Undo (Ctrl+Z), and Save (Ctrl+S).
  • On Mac, replace Ctrl with Command (Cmd) for most shortcuts but not all; some use Control or Option.
  • A plus sign (+) means press keys together; a comma (,) means press them in sequence (e.g. Alt, H, A, C).
  • Excel has 200+ shortcuts; knowing 20–30 covers the vast majority of daily tasks.

What Are Excel Shortcut Keys?

Excel shortcut keys are key combinations that perform a command like copying, saving, or formatting without using the mouse or navigating the ribbon. Instead of clicking through menus, you press two or three keys at once and the action happens instantly.

They matter for one simple reason: speed compounds. A single shortcut saves only a second or two, but across hundreds of repeated actions in a workday, that adds up to real time. Keyboard shortcuts also reduce strain from constant mouse use, and for people with mobility or vision needs they are an essential alternative to a touchscreen or mouse.

Excel has more than 200 shortcuts in total (over 400 if you count Windows and Mac versions separately). You do not need to memorize them all. Most people rely on the same 20 to 30 shortcuts for nearly everything, and pick up specialized ones for pivot tables, formulas, or macros only when their work calls for them. The fastest way to learn is to add two or three new shortcuts at a time until they become muscle memory.

How to Read Excel Shortcuts (+ vs , and the Alt Key)

Excel shortcuts use two separators, and the difference matters:

  • A plus sign (+) means press the keys at the same time. For example, Ctrl + Shift + L means hold Ctrl, then Shift, then press L, all together, then release.
  • A comma (,) means press the keys one after another, in order. For example, Alt, H, A, C means press and release Alt, then H, then A, then C not held down together.

The Alt key and Key Tips (Windows)

On Windows, pressing and releasing the Alt key turns on Key Tips small letters that appear over each ribbon tab and command. Press the letter shown to open that tab, then press the next letter for the command you want. For example, Alt then H opens the Home tab; press H again to open Fill Color. This is why many Windows shortcuts are written as sequences like Alt, H, A, C (Home → Alignment → Center).

Windows vs Mac keys

Most Windows shortcuts that use Ctrl map to Command (Cmd) on a Mac for example, Ctrl+C becomes Cmd+C. But this is not universal: some Mac shortcuts keep the Control key, and Alt on Windows becomes Option on Mac. The tables below show the correct key for each platform, so you do not have to guess.

Most-Used Shortcuts (Essentials)

ActionWindowsMac
CopyCtrl + CCmd + C
PasteCtrl + VCmd + V
CutCtrl + XCmd + X
UndoCtrl + ZCmd + Z
RedoCtrl + YCmd + Y
Repeat last actionF4Cmd + Y
SaveCtrl + SCmd + S
Save AsF12Cmd + Shift + S
OpenCtrl + OCmd + O
New workbookCtrl + NCmd + N
PrintCtrl + PCmd + P
FindCtrl + FCmd + F
Find and ReplaceCtrl + HCtrl + H
Paste SpecialCtrl + Alt + VCmd + Option + V
Open context (right-click) menuShift + F10Shift + F10
Open Format Cells dialogCtrl + 1Cmd + 1

File & Workbook Shortcuts

ActionWindowsMac
Create new workbookCtrl + NCmd + N
Open workbookCtrl + OCmd + O
Save workbookCtrl + SCmd + S
Save AsF12Cmd + Shift + S
PrintCtrl + PCmd + P
Print previewCtrl + F2Cmd + P
Close current workbookCtrl + WCmd + W
Close ExcelAlt + F4Cmd + Q
Insert new worksheetShift + F11Shift + F11
Go to next worksheetCtrl + Page DownCtrl + Page Down
Go to previous worksheetCtrl + Page UpCtrl + Page Up
Go to next workbook windowCtrl + TabCmd + `
Expand or collapse the ribbonCtrl + F1Cmd + Option + R
Toggle full screenCtrl + Shift + F1Cmd + Ctrl + F

Navigation Shortcuts

ActionWindowsMac
Move one cell up / down / left / rightArrow keysArrow keys
Move to edge of data regionCtrl + Arrow keyCmd + Arrow key
Move to beginning of rowHomeHome (MacBook: Fn + Left)
Move to first cell of worksheet (A1)Ctrl + HomeCtrl + Home
Move to last used cellCtrl + EndCtrl + End
Move one screen downPage DownPage Down (MacBook: Fn + Down)
Move one screen upPage UpPage Up (MacBook: Fn + Up)
Move one screen rightAlt + Page DownOption + Page Down
Move one screen leftAlt + Page UpOption + Page Up
Open Go To dialogCtrl + GCtrl + G
Turn End mode on/offEnd

Selection Shortcuts

ActionWindowsMac
Select entire worksheetCtrl + ACmd + A
Select entire rowShift + SpacebarShift + Spacebar
Select entire columnCtrl + SpacebarCtrl + Spacebar
Extend selection by one cellShift + Arrow keyShift + Arrow key
Extend selection to last cellCtrl + Shift + Arrow keyCmd + Shift + Arrow key
Extend selection to start of worksheetCtrl + Shift + HomeCtrl + Shift + Home
Extend selection to last used cellCtrl + Shift + EndCtrl + Shift + End
Select current regionCtrl + Shift + *Cmd + Shift + *
Toggle extend selection modeF8F8
Add non-adjacent cells to selectionShift + F8Shift + F8
Select visible cells onlyAlt + ;
Cancel selectionEscEsc

Data Entry Shortcuts

ActionWindowsMac
Complete entry, move downEnterReturn
Complete entry, move upShift + EnterShift + Return
Complete entry, move rightTabTab
Complete entry, move leftShift + TabShift + Tab
Complete entry, stay in same cellCtrl + EnterCtrl + Return
Fill the same data into multiple cellsCtrl + EnterCtrl + Return
Insert current dateCtrl + ;Ctrl + ;
Insert current timeCtrl + Shift + :Cmd + ;
Fill down from cell aboveCtrl + DCmd + D
Fill right from cell on leftCtrl + RCmd + R
Copy formula from cell aboveCtrl + ‘Ctrl + ‘
Copy value from cell aboveCtrl + Shift + “Ctrl + Shift + “
Insert hyperlinkCtrl + KCmd + K
Flash FillCtrl + ECtrl + E
Start a new line in the same cellAlt + EnterOption + Return

Cell Editing Shortcuts

ActionWindowsMac
Edit active cellF2F2
Insert or edit a noteShift + F2Shift + F2
Insert or reply to a threaded commentCtrl + Shift + F2Cmd + Shift + F2
Cancel entryEscEsc
Select one character right / leftShift + Right / LeftShift + Right / Left
Move one word right / leftCtrl + Right / LeftOption + Right / Left
Delete to end of lineCtrl + DeleteCtrl + Delete
Delete character left of cursorBackspaceDelete
Delete character right of cursorDeleteFn + Delete

Text Formatting Shortcuts

ActionWindowsMac
BoldCtrl + BCmd + B
ItalicCtrl + ICmd + I
UnderlineCtrl + UCmd + U
StrikethroughCtrl + 5Cmd + Shift + X
Open Format Cells dialogCtrl + 1Cmd + 1
Format Cells with Font tabCtrl + Shift + F
Align centerAlt, H, A, CCmd + E
Align leftAlt, H, A, LCmd + L
Increase font sizeAlt, H, F, GCmd + Shift + >
Decrease font sizeAlt, H, F, KCmd + Shift + <

Number Formatting Shortcuts

ActionWindowsMac
General formatCtrl + Shift + ~Ctrl + Shift + ~
Currency formatCtrl + Shift + $Ctrl + Shift + $
Percentage formatCtrl + Shift + %Ctrl + Shift + %
Scientific formatCtrl + Shift + ^Ctrl + Shift + ^
Date formatCtrl + Shift + #Ctrl + Shift + #
Time formatCtrl + Shift + @Ctrl + Shift + @
Number format (2 decimals)Ctrl + Shift + !Ctrl + Shift + !

Cell Borders Shortcuts

ActionWindowsMac
Add outline borderCtrl + Shift + &Cmd + Option + 0
Remove bordersCtrl + Shift + _Cmd + Option + –
Add/remove border rightAlt, H, B, RCmd + Option + Right
Add/remove border leftAlt, H, B, LCmd + Option + Left
Add/remove border topAlt, H, B, TCmd + Option + Up
Add/remove border bottomAlt, H, B, BCmd + Option + Down

Rows, Columns & Grid Shortcuts

ActionWindowsMac
Insert cells, rows, or columnsCtrl + Shift + +Ctrl + Shift + =
Delete cells, rows, or columnsCtrl + –Cmd + –
Hide columnsCtrl + 0Cmd + )
Unhide columnsCtrl + Shift + 0Cmd + Shift + )
Hide rowsCtrl + 9Ctrl + 9
Unhide rowsCtrl + Shift + 9Ctrl + Shift + (
Group rows or columnsAlt + Shift + RightCmd + Shift + K
Ungroup rows or columnsAlt + Shift + LeftCmd + Shift + J
Show/hide outline symbolsCtrl + 8Ctrl + 8
Delete cell contentsDeleteDelete

Formulas & Functions Shortcuts

ActionWindowsMac
AutoSumAlt + =Shift + Cmd + T
Toggle formulas on/offCtrl + `Ctrl + `
Insert functionShift + F3Shift + F3
Insert function argumentsCtrl + Shift + A
Enter array formulaCtrl + Shift + EnterCtrl + Shift + Return
Calculate all worksheetsF9F9
Calculate active worksheetShift + F9Shift + F9
Toggle absolute/relative referenceF4Cmd + T or F4
Define a nameCtrl + F3Cmd + F3
Paste a name into a formulaF3
Expand or collapse formula barCtrl + Shift + UCtrl + Shift + U
Open Power Query EditorAlt + F12Option + F12

Filters & Tables Shortcuts

ActionWindowsMac
Toggle AutoFilterCtrl + Shift + LCmd + Shift + F
Activate filter dropdownAlt + Down ArrowOption + Down Arrow
Insert tableCtrl + TCmd + T
Toggle table total rowCtrl + Shift + T
Select table columnCtrl + SpacebarCtrl + Spacebar
Select table rowShift + SpacebarShift + Spacebar

Charts & Pivot Shortcuts

ActionWindowsMac
Create embedded chartAlt + F1Option + F1
Create chart in new sheetF11F11
Quick Analysis optionsCtrl + Q

Macros & VBA Shortcuts

ActionWindowsMac
Open Macro dialogAlt + F8Option + F8
Open VBA EditorAlt + F11Option + F11
Open spelling checkF7F7
Open thesaurusShift + F7Shift + F7

Ribbon Access Keys (Alt Key Tips)

Press and release Alt to show Key Tips, then press the letter for the tab. On Excel for the web, start with Alt + Windows key.

ActionWindows
Show Key Tips on the ribbonAlt (or F10)
Go to Tell Me / Search fieldAlt + Q
Open the File menuAlt + F
Open the Home tabAlt + H
Open the Insert tabAlt + N
Open the Page Layout tabAlt + P
Open the Formulas tabAlt + M
Open the Data tabAlt + A
Open the Review tabAlt + R
Open the View tabAlt + W
Switch to Page Layout viewAlt, W, P
Switch to Normal viewAlt, W, L
Switch to Page Break PreviewAlt, W, I

Paste Special Options Shortcuts

After copying, press Ctrl + Alt + V (Windows) or Cmd + Option + V (Mac) to open Paste Special, then press the letter for the option.

ActionWindowsMac
Open Paste Special dialogCtrl + Alt + VCmd + Option + V
Paste all contents and formattingAA
Paste formulas onlyFF
Paste values onlyVV
Paste formatting onlyTT
Paste comments and notes onlyCC
Paste data validation onlyNN
Paste all without bordersXX
Paste column widths onlyWW
Paste formulas and number formatsRR
Paste values and number formatsUU

Power Pivot Shortcuts

For the Power Pivot window in Microsoft 365 and Office.

ActionWindowsMac
Open context menuShift + F10Shift + F10
Select entire tableCtrl + ACmd + A
Copy selected dataCtrl + CCmd + C
Delete the tableCtrl + DCmd + D
Move the tableCtrl + MCmd + M
Rename the tableCtrl + RCmd + R
Save the fileCtrl + SCmd + S
Redo last actionCtrl + YCmd + Y
Undo last actionCtrl + ZCmd + Z
Select current columnCtrl + SpacebarCtrl + Spacebar
Select current rowShift + SpacebarShift + Spacebar
Select to last cell of columnShift + Page DownShift + Page Down
Select to first cell of columnShift + Page UpShift + Page Up
Move to previous tableCtrl + Page UpCtrl + Page Up
Move to next tableCtrl + Page DownCtrl + Page Down
Open AutoFilter menuAlt + Down ArrowOption + Down Arrow
Open Go To dialogF5F5
Recalculate all formulasF9F9

Function Keys (Quick Reference)

ActionKey (Windows/Mac)
HelpF1
Edit active cellF2
Repeat / toggle referenceF4
Go To dialogF5
SpellingF7
Calculate workbooksF9
New chart sheetF11
Save AsF12

Frequently Asked Questions

What is the most used Excel shortcut?

The most used Excel shortcut is Ctrl + C (copy), closely followed by Ctrl + V (paste), Ctrl + Z (undo), and Ctrl + S (save). On a Mac, these are Cmd + C, Cmd + V, Cmd + Z, and Cmd + S. These four cover the majority of everyday actions in Excel.

How many keyboard shortcuts does Excel have?

Excel has more than 200 keyboard shortcuts, and over 400 if you count Windows and Mac versions separately. Most users rely on the same 20 to 30 shortcuts for nearly all of their daily work, and learn specialized ones for pivot tables, formulas, or macros only as needed.

What is the difference between + and , in Excel shortcuts?

A plus sign (+) means press the keys at the same time for example, Ctrl + Shift + L is held together. A comma (,) means press the keys one after another in sequence for example, Alt, H, A, C is pressed and released one key at a time.

Do Excel shortcuts work on Mac?

Yes. Most Excel shortcuts work on Mac, with Ctrl usually replaced by Command (Cmd) and Alt replaced by Option. However, some shortcuts differ for example, AutoSum is Alt + = on Windows but Shift + Cmd + T on Mac. The tables in this guide list the correct key for each platform.

What does Ctrl + Shift + L do in Excel?

Ctrl + Shift + L turns the AutoFilter on or off for your data. When on, filter arrows appear on each column header, letting you sort and filter. On a Mac, the equivalent is Cmd + Shift + F.

How do I create my own keyboard shortcut in Excel?

Excel does not let you reassign built-in shortcuts directly, but you can record a macro and assign it a shortcut key. Go to the View tab, select Macros → Record Macro, enter a shortcut letter in the “Shortcut key” box, perform your actions, then stop recording. On Mac, you can also create custom shortcuts in System Settings.

What is the Alt key used for in Excel?

On Windows, pressing and releasing the Alt key shows Key Tips letters that appear over each ribbon tab and command. Pressing those letters in sequence runs the command, which is why many shortcuts are written as sequences like Alt, H, A, C (Home → Alignment → Center).

Conclusion

You do not need to memorize all 200+ Excel shortcut keys. Start with the 20 most-used shortcuts above, build them into muscle memory, then add category-specific ones formulas, pivot tables, filters as your work demands. Keep this page bookmarked as a reference, or download the free PDF cheat sheet to keep the full list at hand.

READ NEXT:

Pratik

Pratik is the founder of Tutorial Tactic and a productivity tools specialist with 15 years of hands-on experience in Google Workspace, Microsoft Office, and software automation. He has published over 1,500 guides on keyboard shortcuts, software commands, how-to tutorials and workflow optimization, helping readers across the US and India work faster with the tools they use every day. Tutorial Tactic was founded in 2021 with one goal: cut through the noise and give readers exactly what they need fast, verified, and beginner-friendly.
Back to top button