Free Printable PDF — Updated for 2026

The Ultimate Excel Shortcuts Cheat Sheet

Stop wasting time clicking through menus. Our comprehensive Excel shortcuts cheat sheet includes 80+ essential keyboard shortcuts for Windows and Mac — organized by category so you can find exactly what you need in seconds.

100% Free
Windows & Mac
Printable PDF
Excel Shortcuts Cheat Sheet

Complete Excel Keyboard Shortcuts Reference

All the essential Excel shortcut keys organized by category. Windows keys shown.

Why It Matters

Why Learn Excel Keyboard Shortcuts?

Mastering Excel shortcut keys is the single fastest way to boost your spreadsheet productivity. Here's what the data shows:

8 Days

Average time saved per year by using Excel hotkeys instead of mouse clicks

40%

Faster task completion when you use keyboard shortcuts in Excel

80+

Essential Excel shortcuts covered in our free cheat sheet

Pro-Level

Stand out at work by mastering Excel cheat sheet shortcuts

Quick Guide

How to Use This Excel Shortcuts Cheat Sheet

Follow these three simple steps to start mastering Excel keyboard shortcuts today.

1

Download the PDF

Click the download button to get your free printable Excel shortcuts cheat sheet as a high-quality PDF file.

2

Print or Save

Print the Excel cheat sheet and keep it beside your keyboard, or save it on your desktop for instant access.

3

Practice Daily

Pick 3–5 Excel shortcuts each day to practice. Within two weeks, you'll have built solid muscle memory.

Must-Know

Top 10 Excel Shortcuts Every User Should Know

If you're new to Excel keyboard shortcuts, start with these ten. They're the most frequently used shortcuts by professionals worldwide.

1 Copy selected cells
Ctrl+C
2 Paste from clipboard
Ctrl+V
3 Undo last action
Ctrl+Z
4 Save workbook
Ctrl+S
5 Bold text
Ctrl+B
6 Select all cells
Ctrl+A
7 Find and replace
Ctrl+H
8 AutoSum selected range
Alt+=
9 Print workbook
Ctrl+P
10 Edit active cell
F2

💡 Pro tip: On macOS, replace Ctrl with ⌘ Cmd

Beyond the Basics

Advanced Excel Techniques & Power-User Shortcuts

Once you've mastered the basics from our Excel shortcuts cheat sheet, these advanced techniques will take your spreadsheet skills to the next level.

Flash Fill — Instant Pattern Recognition

Ctrl+E

Flash Fill automatically detects patterns in your data and fills the remaining cells. Type one example in a column adjacent to your data, then press Ctrl + E.

💡 Use case:

Extract first names from full names, reformat phone numbers, split or combine text — all without writing a single formula.

Paste Special — Granular Control

Ctrl+Alt+V

Paste Special lets you choose exactly what to paste: values only, formulas, formatting, column widths, or even perform math operations (add, subtract, multiply, divide) during paste.

💡 Pro shortcuts inside the dialog:

V Values only · F Formulas · T Formats · E Transpose

Named Ranges & Name Manager

Ctrl+F3

Named ranges replace cryptic cell references like $B$2:$B$500 with meaningful names like Revenue. This makes formulas self-documenting and dramatically easier to debug.

💡 Quick define:

Select a range → click the Name Box (left of the formula bar) → type a name → press Enter. Use Ctrl + F3 to manage all names.

Pivot Table Power Moves

Alt+N+V

Create a Pivot Table instantly with Alt + N + V. Once inside, use these shortcuts to manipulate data like a pro without ever touching the mouse.

💡 Inside a Pivot Table:

Alt + ↓ Filter menu · Alt + Shift + → Group items · Alt + F5 Refresh · Double-click a value to drill down

Conditional Formatting via Ribbon Keys

Alt+H+L

Use Alt + H + L to access conditional formatting rules. Apply color scales, data bars, icon sets, or custom rules to visually highlight trends, outliers, and KPIs in your data.

💡 Data validation shortcut:

Alt + A + V + V opens data validation — create dropdown lists, restrict cell inputs to dates/numbers, and add input messages for clean data entry.

Dynamic Arrays & Spill Formulas

Ctrl+Shift+Enter

Modern Excel supports dynamic arrays — a single formula that returns multiple values and "spills" into adjacent cells. Functions like UNIQUE(), SORT(), FILTER(), and XLOOKUP() leverage this.

💡 Legacy vs Modern:

In older Excel (2019 and below), use Ctrl + Shift + Enter for array formulas. In Excel 365/2021+, just press Enter — spill is automatic.

Pro Tip: The Alt Key is Your Ribbon Remote Control

Press Alt by itself to reveal letter keys overlaid on every Ribbon tab and button. You can then type those letters in sequence to access any command — insert charts, apply filters, freeze panes, group rows — all without a mouse. This is how power users navigate Excel entirely from the keyboard.

100% Free Office Suite

Get a Free Excel Alternative — Use All These Shortcuts Today

WPS Spreadsheets is a free, fully compatible alternative to Microsoft Excel that supports every shortcut on this cheat sheet. Plus, you get Writer, Presentation, and PDF tools — all in one lightweight app.

  • 100% Free to Use
  • Excel Shortcut Compatible
  • Windows, Mac, Linux, Mobile
  • Built-in AI Assistant
Download WPS Office Free No subscription needed
FAQ

Frequently Asked Questions

Everything you need to know about our Excel shortcuts cheat sheet.

Ready to Master Excel Shortcuts?

Download your free Excel shortcuts cheat sheet now and start working faster in spreadsheets today. Compatible with Microsoft Excel and WPS Spreadsheets.

✓ 80+ shortcuts · ✓ Windows & Mac · ✓ Printable PDF · ✓ 100% Free