X
⌨️

Keyboard Shortcuts & Formula Cheat Sheets

Every keyboard shortcut for Excel, Word, PowerPoint, Windows, Chrome, Gmail & VS Code — plus the most-used Excel formulas and ready-to-use formula ideas. Search it, learn it, and download a colorful or print-ready PDF.

Advertisement

About this cheat sheet

This is a fast, searchable keyboard shortcuts cheat sheet for the apps people use every day — Microsoft Excel, Word and PowerPoint, plus Windows, Google Chrome, Gmail and VS Code. Excel also includes a complete list of the most-used formulas and functions with ready-to-copy examples. Pick an app, search for what you need, and you have it in seconds — no signup, nothing to install.

How to use it

  1. Tap the app you want at the top (Excel, Word, PowerPoint, Windows, Chrome, Gmail or VS Code).
  2. For Excel, switch between Shortcuts and Formulas with the toggle.
  3. Search to instantly filter — type "save", "paste", "VLOOKUP" or any action.
  4. Click any key combo or formula to copy it to your clipboard.
  5. Download a Colorful PDF to keep or share, or a black-and-white PDF that saves ink when you print it.

Colorful or printable PDF — your choice

Every app's sheet exports two ways. The colorful PDF is designed for your screen and for sharing with a team. The black-and-white (B&W) PDF is a clean, ink-friendly layout made for printing and pinning next to your desk.

Which shortcuts are included?

Hundreds of them — covering workbook and file actions, navigation, selection, editing, formatting, formulas, window management, browser tabs, email and code editing. The Excel formula list spans math, statistical, logical, text, lookup (including VLOOKUP, XLOOKUP and INDEX/MATCH), date, and financial functions.

Excel formula ideas you can copy

Beyond the plain formula list, the Excel tab has a Formula Ideas view — real-world recipes that show you when to use each formula, not just what it is. Instead of numbering rows by hand, you can auto-number rows, look up a price, count or sum by condition, split a full name, flag overdue dates, remove duplicates or work out a percentage — each idea comes with a ready-made formula you click to copy, plus a plain-English explanation. It is the practical "how to use Excel formulas" guide, and it downloads as its own PDF too.

Do the Gmail shortcuts need turning on?

Yes. Open Gmail → SettingsSee all settingsGeneral → set Keyboard shortcuts to on, then save. The VS Code keys are shown for Windows and Linux; on a Mac, use Cmd in place of Ctrl (and Option for Alt).

More tools