Excel Keyboard Shortcuts Cheat Sheet

The first five sections match LearnExcel's own graded Shortcuts drills; the last three add the everyday shortcuts, Mac differences and ribbon key tips people look up most. Windows and Mac combos are listed side by side because they genuinely differ for several of these (AutoSum is the biggest gap: Alt+= on Windows versus Cmd+Shift+T on Mac), and a cheat sheet that only covers one platform is only half useful.

Reading a shortcut here is the easy part. The point is building the muscle memory to stop reaching for the mouse at all, which is exactly what the graded drills linked at the bottom are for: a real grid, one task, keyboard only.

Navigation

Getting across a big sheet without ever touching the scrollbar.

• Jump back to cell A1: On a 2,000-row sheet, scrolling back to the top by hand is the single most common wasted motion. This is instant.
• Jump to the bottom of a column: This is how you actually navigate a real dataset, not by holding down the arrow key.
• Jump straight to a value with Find: Ctrl+F (Cmd+F on Mac) opens Find. It's the fastest way to land on one specific value in a sheet with hundreds or thousands of rows, without scrolling or reading every cell along the way.

Selection

Selecting a whole row or column in one keystroke instead of dragging.

• Select an entire row: Selecting a whole row or column by keyboard keeps your hands on the keys when you're about to format, delete, or copy a whole record.
• Select an entire column: On some Macs this one gets intercepted by a system shortcut (Microsoft's own docs flag it), a good first real example of a shortcut conflict.

Editing

Copy, paste, undo, and fill, the moves you repeat the most while building a sheet.

• Copy a value, keyboard only: Copy/paste by keyboard is the single highest-leverage habit for spreadsheet speed. Every mouse trip costs half a second you don't get back.
• Undo a typo, keyboard only: Undo is the safety net that makes moving fast in a real spreadsheet possible. Reaching for the mouse to click a toolbar icon defeats the point.
• Fill a value down a column: Fill Down is how you copy a label or a formula down hundreds of rows in one keystroke instead of dragging a tiny fill handle.

Formatting

Bold, italic, underline, and number formats, applied without opening a single menu.

• Bold a cell, keyboard only: Formatting shortcuts save the most time on headers and totals, the cells you touch over and over while building a sheet.
• Italicize a cell, keyboard only: Italics are the usual way to mark a note, footnote, or draft figure as "different" from the real data around it.
• Underline a cell, keyboard only: Underlining section titles and subtotal rows by keyboard keeps you from breaking your typing flow to reach for the mouse.
• Format a cell as a percentage: Number-format shortcuts (Ctrl+Shift+the-symbol-row) are the same physical keys on Mac and Windows, one of the few places the two platforms actually agree.
• Format a cell as currency: Same symbol-row pattern as Percent (Ctrl+Shift+4 for Currency, Ctrl+Shift+5 for Percent). Once one of these is muscle memory, the rest follow the same logic.

Formulas

AutoSum, absolute references, dates, and filters, from the keyboard.

• Insert AutoSum without the ribbon: This is the biggest split between platforms in this whole list, worth knowing cold if you switch between a Windows lab computer and your own Mac.
• Insert today's date: One of the rare Excel shortcuts that's the literal same physical keys on both platforms. Mac Excel keeps this one on Control, not Command.
• Lock a reference to absolute: F4 cycles relative → absolute → mixed → mixed, the fastest way to fix a formula before you copy it across a row.
• Turn on AutoFilter, keyboard only: AutoFilter's drop-down arrows are what make Data → Filter usable without ever opening a menu. Toggling it on from the keyboard means you never have to break flow just to filter a table.

More everyday shortcuts

Not drilled in the app yet, but worth knowing on day one.

Mac differences that trip people up

• Cmd+T toggles absolute references. On a Mac, select a reference in the formula bar and press Cmd+T to cycle $A$1, A$1, $A1 and A1, the same as F4 on Windows.
• Function keys need Fn. On most Mac keyboards F2, F4 and the other F keys only reach Excel with Fn held down, unless "Use F1, F2, etc. keys as standard function keys" is on in System Settings.
• AutoSum is Cmd+Shift+T, not Alt+=, and Mac Excel has no Alt ribbon key tips, so the sequences below are Windows only.

Ribbon key tips: Alt sequences (Windows)

Press and release Alt, then type the letters one at a time. Letters appear on the ribbon as you go, so you can discover the rest yourself.