Excel Shortcuts Cheat Sheet (2026 Edition)

You're reading this because you want to be faster in Excel. Fair enough. Keyboard shortcuts are the single quickest way to cut minutes off repetitive spreadsheet work — no macros, no add-ins, no learning curve beyond muscle memory.

This cheat sheet covers the shortcuts that actually matter for day-to-day work. Not every obscure key combination Excel supports, but the ones you'll use often enough to memorize. Windows and Mac, side by side.

But there's a question worth asking once you've got these down: if you're doing the same task often enough to need shortcuts, should you be doing that task at all?

We'll get to that. First, the shortcuts.

Navigation Shortcuts

Moving around a spreadsheet is where most people waste the most time — scrolling, clicking, hunting for the right cell. These shortcuts eliminate that.

Action	Windows	Mac
Move to the edge of a data region	Ctrl + Arrow Key	⌘ + Arrow Key
Move to cell A1	Ctrl + Home	⌘ + Fn + ←
Move to the last used cell	Ctrl + End	⌘ + Fn + →
Go to a specific cell	Ctrl + G or F5	⌘ + G or F5
Switch between worksheets	Ctrl + Page Up/Down	⌥ + → / ←
Move one screen up/down	Page Up / Page Down	Fn + ↑ / ↓
Move one screen left/right	Alt + Page Up/Down	Fn + ⌥ + ↑ / ↓
Open the Name Box (type a cell ref)	Ctrl + F5	—

The one to learn first: Ctrl + Arrow Key (⌘ + Arrow on Mac). It jumps to the edge of whatever data block you're in. Combine it with Shift to select everything in between. Once this is in your muscle memory, you'll never drag-select a column again.

Formatting & Selection Shortcuts

Formatting is the second biggest time sink. Most people reach for the mouse, click the ribbon, hunt for the button. These shortcuts skip all of that.

Action	Windows	Mac
Select entire row	Shift + Space	Shift + Space
Select entire column	Ctrl + Space	⌃ + Space
Select all (entire sheet)	Ctrl + A	⌘ + A
Select to last used cell in column	Ctrl + Shift + End	⌘ + Shift + End
Bold	Ctrl + B	⌘ + B
Italic	Ctrl + I	⌘ + I
Underline	Ctrl + U	⌘ + U
Format as currency	Ctrl + Shift + $	⌃ + Shift + $
Format as percentage	Ctrl + Shift + %	⌃ + Shift + %
Format as date	Ctrl + Shift + #	⌃ + Shift + #
Open Format Cells dialog	Ctrl + 1	⌘ + 1
Add/remove borders (outline)	Ctrl + Shift + &	⌘ + ⌥ + 0
Remove all borders	Ctrl + Shift + _	—
Toggle strikethrough	Ctrl + 5	⌘ + Shift + X

Pro tip: Ctrl + 1 (⌘ + 1) opens the full Format Cells dialog, which is often faster than hunting through the ribbon for a specific formatting option. Learn this one and you can stop memorizing individual format shortcuts.

Formula & Data Shortcuts

These are the shortcuts that separate casual users from people who actually get work done in Excel.

Action	Windows	Mac
Start a formula	=	=
AutoSum	Alt + =	⌘ + Shift + T
Toggle absolute/relative reference ($)	F4	⌘ + T
Insert function	Shift + F3	Shift + F3
Enter formula in all selected cells	Ctrl + Enter	⌘ + Return
Fill down	Ctrl + D	⌘ + D
Fill right	Ctrl + R	⌘ + R
Find	Ctrl + F	⌘ + F
Find and Replace	Ctrl + H	⌘ + H
Insert new row/column	Ctrl + Shift + +	⌘ + Shift + +
Delete row/column	Ctrl + -	⌘ + -
Show formulas (toggle)	Ctrl + `	⌃ + `
Name a range	Ctrl + F3	⌘ + F3
Flash Fill	Ctrl + E	⌘ + E
Create a Table	Ctrl + T	⌘ + T

The underrated one: Flash Fill (Ctrl + E). Type a pattern in the first cell — say, extracting a first name from a full name — and Flash Fill figures out what you're doing and fills the rest. It's basically Excel's built-in pattern recognition, and it works surprisingly well.

Workbook & File Shortcuts

Action	Windows	Mac
Save	Ctrl + S	⌘ + S
Save As	F12	⌘ + Shift + S
Open	Ctrl + O	⌘ + O
New workbook	Ctrl + N	⌘ + N
Close workbook	Ctrl + W	⌘ + W
Print	Ctrl + P	⌘ + P
Undo	Ctrl + Z	⌘ + Z
Redo	Ctrl + Y	⌘ + Y
Copy	Ctrl + C	⌘ + C
Paste	Ctrl + V	⌘ + V
Paste Special	Ctrl + Alt + V	⌘ + ⌃ + V
Cut	Ctrl + X	⌘ + X

Paste Special deserves its own callout. Standard paste brings everything — formatting, formulas, column widths. Paste Special lets you paste just values, just formatting, or just formulas. If you've ever pasted data into a formatted table and watched your formatting vanish, Paste Special is the fix.

The Shortcuts Nobody Remembers (and Why That's a Sign)

Here's the thing about cheat sheets: if you need one, the shortcut isn't in your muscle memory yet. And if it's not in your muscle memory, you're probably not using it often enough for it to matter.

Most Excel users actually need about 15–20 shortcuts. The rest are nice to know but never stick because you use them once a month — if that. Here are the ones people always bookmark and never memorize:

• Ctrl + Shift + L (toggle filters) — useful, but how often do you toggle filters?
• Alt + H + O + I (auto-fit column width) — you'll Google this every time
• Ctrl + Shift + ~ (general number format) — exists, but Ctrl + 1 does more
• Alt + Enter (new line within a cell) — actually useful, but feels wrong

This isn't a memory problem. It's a signal. If you can't remember a shortcut, you probably don't do that task often enough for the shortcut to pay off. And if you do that task often enough, the shortcut will learn itself.

The deeper question is: why are you spending enough time in Excel that a 2-second shortcut makes a meaningful difference in your day?

When Shortcuts Aren't the Answer

Shortcuts optimize individual actions. They make Ctrl+C half a second faster than right-click → Copy. They save you the trip to the ribbon for bold formatting.

But they don't change what you're doing. They just make you faster at it.

Consider a typical weekly report:

1. Open five source files — 30 seconds saved with shortcuts
2. Copy data from each into a master sheet — maybe a minute saved
3. Clean up formatting — another minute
4. Build a pivot table — shortcuts don't help much here
5. Export as PDF — two clicks either way
6. Email to stakeholders — zero shortcut advantage

Total time saved by knowing every shortcut cold: maybe 3–4 minutes out of a 40-minute process. The other 36 minutes are the task itself — opening files, making decisions about structure, adjusting things that changed since last week.

Shortcuts are a local optimization. If the global problem is that you're doing the same manual work every week, a faster keyboard isn't the answer.

Skip the Shortcuts: Describe the Task Instead

There's a different approach. Instead of getting faster at the steps, eliminate the steps.

If you build the same report every week — pull data from these files, consolidate into this format, export as PDF, send to these people — you don't need faster keyboard shortcuts. You need to describe that workflow once and let it run on its own.

That's what AI agents like Reflexion are built for. You describe the outcome in plain English:

"Every Monday at 8 AM, pull the latest sales data from our five regional files on OneDrive, consolidate into a summary with region totals, export as PDF, and email it to the ops team."

No shortcuts to memorize. No macro to maintain. No manual steps at all. For a comparison of how this stacks up against VBA, Python, and Zapier, see I Tried Automating the Same Excel Report with VBA, Python, Zapier, and an AI Agent.

This isn't about replacing Excel knowledge — understanding spreadsheets makes you better at describing what you need and verifying the results. But if you're spending your mornings doing keyboard gymnastics through the same workflow, that time is better spent on the work that actually needs a human brain.

Learn the shortcuts. Use them when you're in Excel. But if you find yourself wishing for a shortcut to automate an entire workflow — that exists too. If you're not sure where to start, Excel Reporting: 7 Automation Patterns breaks down the most common workflows that benefit from automation.

---

Want to stop repeating the same Excel work every week? Try Reflexion free and describe the task you want automated. If you want to go beyond shortcuts, macros are the next step — though you might not need them either.