Excel Cheat Sheet

Every essential Excel shortcut & top formula on one page.

A free, printable-style Excel cheat sheet: all the keyboard shortcuts that save you hours (copy, fill, AutoSum, format, navigate) plus the 15 most-used formulas — SUM, IF, VLOOKUP, XLOOKUP, COUNTIF, INDEX/MATCH and more — each with a ready-to-copy example. Works in Excel for Windows and Mac. Runs fully in your browser, no sign-up, no API.

Frequently asked questions

What are the most useful Excel keyboard shortcuts?

The everyday essentials are Ctrl+C/X/V (copy/cut/paste), Ctrl+Z/Y (undo/redo), Ctrl+S (save), Ctrl+Arrow (jump to the edge of data), Ctrl+Shift+Arrow (select to the edge), Alt+= (AutoSum), Ctrl+E (Flash Fill), Ctrl+; (today's date) and Ctrl+1 (Format Cells). They're all listed with descriptions on this Excel cheat sheet.

How do I insert today's date with a shortcut?

Press Ctrl + ; (semicolon) to insert today's static date, and Ctrl + Shift + : (colon) for the current time. Unlike the =TODAY() formula, these insert a fixed value that doesn't change tomorrow.

What is the F4 key used for in Excel?

While editing a formula, F4 locks a cell reference — pressing it cycles A1 → $A$1 → A$1 → $A1, adding the $ signs for absolute/mixed references. Outside a formula, F4 repeats your last action.

What do Excel errors like #N/A, #REF! and #SPILL! mean?

#N/A means a lookup found no match; #REF! means a referenced cell was deleted; #VALUE! is a wrong data type; #DIV/0! is dividing by zero; #NAME? is a misspelled function; and #SPILL! means a dynamic array can't spill because cells below aren't empty. The cheat sheet lists each error with its fix.

Do these Excel shortcuts work on Mac?

Yes — the actions are the same, but on Mac replace Ctrl with ⌘ (Cmd) for most shortcuts (⌘+C to copy, ⌘+S to save). A few still use Control on Mac; if one doesn't respond, try the Control key.

Related tools — Guides & Tutorials