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. Whether you are looking for a free printable excel cheat sheet pdf or a quick digital guide, our resource is organized by category so you can find exactly what you need in seconds.

Download Free Cheat Sheet Browse Shortcuts Below
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.

Total shortcuts: 0

Replace Ctrl with ⌘ Cmd on macOS

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 download your wps office shortcut keys pdf . Saving this shortcut reference or our comprehensive excel shortcuts cheat sheet as a high-quality PDF file ensures you always have the best cheat sheet at your fingertips.

2

Print or Save

Print the free excel cheat sheet pdf and keep it beside your keyboard. Having this physical sheet makes mastering every shortcut much faster. You can also save the excel cheat sheet on your desktop for instant access to every shortcut you need.

3

Practice Daily

Pick 3–5 keys from this microsoft excel shortcuts cheat sheet each day to practice. By focusing on one shortcut at a time from the sheet, you'll build solid muscle memory within two weeks. This cheat sheet strategy is the fastest way to become an expert.

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. This shortcut is a must-have for any excel cheat sheet. 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.It’s one of the most versatile tools in our excel shortcuts cheat sheet.

💡 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 your sheet is set up, 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. This shortcut helps you apply color scales, data bars, icon sets, or custom rules to visually highlight trends, outliers, and KPIs in your data on your sheet.

💡 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 — this shortcut logic simplifies complex calculations across your entire sheet. 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 featured on this microsoft excel shortcuts cheat sheet. This comprehensive cheat sheet allows you to master every shortcut within a single sheet. If you need to download wps office shortcut keys pdf , you’ll also get Writer, Presentation, and PDF tools — an 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.

Download Free Cheat Sheet Back to Shortcuts

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