Free, source-checked, and built to be reused

The Excel cheat sheet you'll actually keep open

Search 71 Windows and Mac shortcuts, copy 19 essential formulas, print a one-page desk reference, or practise in a working Excel workbook. No signup. No email gate.

Search shortcuts Download one-page PDF

Shortcuts: 71
Formulas: 19
File formats: 4

Choose your edition

More useful than a screenshot

Print it, edit it, teach from it, or load the structured data into your own project. Every edition is ungated.

PDF

One-page A4 PDF

Landscape desk reference with essential shortcuts and all 19 formulas.

Download A4 PDF PDF

One-page US Letter PDF

The same print-friendly reference sized for US Letter paper.

Download Letter PDF PDF

Complete reference PDF

Every shortcut, formula example, tip, source note, and license detail.

Download complete PDF XLSX

Practice workbook

Five real sheets: shortcuts, formulas, practice data, exercises, and notes.

Download Excel workbook

Structured data:Shortcuts CSV Formulas CSV Complete JSON File checksums

Interactive reference

Find an Excel shortcut in seconds

Search by task or keys, switch platforms, and narrow the list to the shortcuts worth memorising first.

Essentials only

Showing 42 of 71 shortcuts for Windows.

FileEssential

Save the workbook

Ctrl+S

FileEssential

Open a workbook

Ctrl+O

FileEssential

Create a new workbook

Ctrl+N

FileEssential

Print the workbook

Ctrl+P

EditingEssential

Copy selected cells

Ctrl+C

EditingEssential

Cut selected cells

Ctrl+X

EditingEssential

Paste copied cells

Ctrl+V

EditingEssential

Open Paste Special

Ctrl+Alt+V

On Mac, Ctrl+Option+V and Cmd+Option+V are also documented.

EditingEssential

Undo the last action

Ctrl+Z

EditingEssential

Redo the last action

Ctrl+Y

Cmd+Shift+Z is also documented on Mac.

EditingEssential

Find text or values

Ctrl+F

EditingEssential

Find and replace

Ctrl+H

Cmd+Shift+H is also documented on Mac.

EditingEssential

Clear selected cell contents

Delete

EditingEssential

Fill the top cell down

Ctrl+D

EditingEssential

Insert cells, rows, or columns

Ctrl+Shift+=

EditingEssential

Delete cells, rows, or columns

Ctrl+-

NavigationEssential

Open the Go To dialog

Ctrl+G

NavigationEssential

Move to the start of the sheet

Ctrl+Home

On a MacBook, use Ctrl+Fn+Left Arrow.

NavigationEssential

Move to the last used cell

Ctrl+End

On a MacBook, use Ctrl+Fn+Right Arrow.

NavigationEssential

Jump to the edge of a data region

Ctrl+Arrow

NavigationEssential

Move to the next worksheet

Ctrl+Page Down

NavigationEssential

Move to the previous worksheet

Ctrl+Page Up

Data entryEssential

Edit the active cell

F2

Data entryEssential

Complete an entry and move down

Enter

Data entryEssential

Start a new line inside a cell

Alt+Enter

Data entryEssential

Insert the current date

Ctrl+;

FormattingEssential

Open Format Cells

Ctrl+1

FormattingEssential

Apply or remove bold

Ctrl+B

FormattingEssential

Apply Currency number format

Ctrl+Shift+$

FormattingEssential

Apply Percentage number format

Ctrl+Shift+%

FormattingEssential

Create a table

Ctrl+T

SelectionEssential

Select the entire column

Ctrl+Space

SelectionEssential

Select the entire row

Shift+Space

SelectionEssential

Select the current data region

Ctrl+A

SelectionEssential

Extend selection to the edge of data

Ctrl+Shift+Arrow

DataEssential

Turn filters on or off

Ctrl+Shift+L

DataEssential

Open the active filter list

Alt+Down Arrow

DataEssential

Run Flash Fill

Ctrl+E

FormulasEssential

Show or hide formulas

Ctrl+`

FormulasEssential

Cycle absolute and relative references

F4

FormulasEssential

Insert an AutoSum formula

Alt+=

WorkbookEssential

Insert a new worksheet

Shift+F11

Copy-ready formulas

The Excel formulas people actually use

Each example is ready to copy, with a practical warning that helps you avoid the most common mistake.

Showing 19 of 19 formulas.

Math

SUM

Add values

=SUM(B2:B10)

Pro tip: SUM ignores text and blank cells.

See syntax and worked examples

Math

AVERAGE

Calculate the arithmetic mean

=AVERAGE(B2:B10)

Pro tip: Blank cells are ignored; zero values are included.

See syntax and worked examples

Math

SUMIF

Add values that meet one condition

=SUMIF(A2:A20, "West", B2:B20)

Pro tip: Use SUMIFS when you need multiple conditions.

See syntax and worked examples

Math

SUMIFS

Add values that meet several conditions

=SUMIFS(C2:C20, A2:A20, "West", B2:B20, ">100")

Pro tip: SUMIFS puts the sum range first; SUMIF puts it last.

See syntax and worked examples

Math

COUNTIF

Count cells that meet one condition

=COUNTIF(C2:C100, "Complete")

Pro tip: Wildcards work: * matches any text and ? matches one character.

See syntax and worked examples

Math

COUNTIFS

Count rows that meet several conditions

=COUNTIFS(A2:A50, "West", B2:B50, ">100")

Pro tip: Every criteria range must be the same size.

See syntax and worked examples

Logic

IF

Return one result when true and another when false

=IF(B2>=70, "Pass", "Review")

Pro tip: Use AND or OR inside the logical test for multiple rules.

See syntax and worked examples

Logic

IFERROR

Replace formula errors with a fallback

=IFERROR(A2/B2, 0)

Pro tip: Do not hide errors until you understand their cause.

See syntax and worked examples

Lookup

XLOOKUP

Find a match and return a related value

=XLOOKUP(E2, A2:A100, C2:C100, "Not found")

Pro tip: Unlike VLOOKUP, XLOOKUP can return values from either side.

See syntax and worked examples

Lookup

VLOOKUP

Find a value in the first column of a table

=VLOOKUP(E2, A2:C100, 3, FALSE)

Pro tip: Use FALSE for an exact match unless you deliberately need approximate matching.

See syntax and worked examples

Lookup

INDEX

Return a value by its row and column position

=INDEX(C2:C100, MATCH(E2, A2:A100, 0))

Pro tip: Pair INDEX with MATCH for a flexible lookup in older Excel versions.

See syntax and worked examples

Lookup

MATCH

Return the position of a matching value

=MATCH(E2, A2:A100, 0)

Pro tip: Use 0 for an exact match.

See syntax and worked examples

Text

TEXTJOIN

Join text with a chosen delimiter

=TEXTJOIN(", ", TRUE, A2:C2)

Pro tip: Set ignore_empty to TRUE to skip blank cells.

See syntax and worked examples

Text

CONCAT

Combine text from several cells or ranges

=CONCAT(A2, " ", B2)

Pro tip: Use TEXTJOIN when you need a separator inserted automatically.

See syntax and worked examples

Text

LEFT / RIGHT / MID

Extract characters from text

=LEFT(A2, 3)

Pro tip: Use MID when the text you need begins in the middle of a value.

See syntax and worked examples

Text

TRIM

Remove extra spaces from text

=TRIM(A2)

Pro tip: TRIM keeps single spaces between words.

See syntax and worked examples

Date

TODAY

Return the current date

=TODAY()-A2

Pro tip: TODAY recalculates when the workbook recalculates.

See syntax and worked examples

Date

DATEDIF

Calculate elapsed years, months, or days

=DATEDIF(A2, TODAY(), "y")

Pro tip: Use y, m, or d for complete years, months, or days.

See syntax and worked examples

Math

AVERAGEIF

Average values that meet a condition

=AVERAGEIF(A2:A20, "West", B2:B20)

Pro tip: The criteria and average ranges should be the same size.

See syntax and worked examples

Learn by doing

The download is a real workbook, not a poster in disguise

Open the workbook to browse every shortcut and formula, then work through invented sales data with live SUM, AVERAGE, COUNTIF, SUMIF, IF, and XLOOKUP examples. Cached results are included for viewers that do not calculate formulas.

Get the practice workbook Open it in our Excel editor

Workbook contents

01
Shortcuts
All 71 rows with filters and platform keys
02
Formulas
Syntax, examples, purpose, and practical tips
03
Practice Data
Invented sales data with calculated revenue
04
Formula Practice
Six working exercises with expected results
05
Read Me
Version, source, license, and attribution

Built for teachers and publishers

Share it. Adapt it. Link to it.

The compiled cheat sheet is released under CC BY 4.0. You can reuse it in a course, company wiki, blog post, video description, or printed handout with attribution.

Suggested attribution

Excel Cheat Sheet by ExcelTool.io — https://www.exceltool.io/excel-cheat-sheet

Methodology

Useful, current, and honest about limits

Shortcut keys were checked against Microsoft's official Excel shortcut reference on July 30, 2026.
Windows and Mac are separated because the same task often uses different keys.
Keyboard layout, Excel version, and macOS system shortcuts can change behavior. Microsoft remains the source of truth.
The JSON dataset and SHA-256 manifest make updates auditable and reuse straightforward.

Excel cheat sheet FAQ

Is this Excel cheat sheet free?

Yes. The web reference, printable PDFs, Excel workbook, CSV files, and JSON dataset are free to use without an account or email gate.

Does the cheat sheet cover both Windows and Mac?

Yes. The interactive reference lets you switch between Windows and Mac, and every shortcut card shows the keys documented for that platform.

Can I print the Excel cheat sheet on one page?

Yes. Separate landscape editions are provided for A4 and US Letter paper. A complete multi-page PDF is available when you want all 71 shortcuts.

Can I reuse the cheat sheet in a class, blog post, or company wiki?

Yes. The compiled resource is available under CC BY 4.0. You may share and adapt it, including commercially, with attribution to ExcelTool.io and a link to this page.

Are the keyboard shortcuts verified?

The shortcut list was checked against Microsoft's official Excel keyboard-shortcut reference on July 30, 2026. Behavior can still vary by Excel version, keyboard layout, and macOS system settings.

Ready to do the work?

Generate a formula from plain English or open a workbook in the browser—both free, private, and available without signup.

Generate an Excel formula Open the Excel editor