FormulaCamp
Completed
All Excel how-to articles
Practical Excel how-to

Excel Shortcuts Cheat Sheet

Excel shortcuts cheat sheet for Windows and Mac: reliable keys for navigation, selection, formatting, formulas, and everyday data work.

Excel shortcuts for Windows and Mac

Navigation
ActionWindowsMac
Move one cellArrow keysArrow keys
Move to the edge of the current data regionCtrl+Arrow keyCommand+Arrow key
Go to a named cell or rangeCtrl+GControl+G
Move to the next worksheetCtrl+Page DownOption+Right Arrow
Move to the previous worksheetCtrl+Page UpOption+Left Arrow
Selection
ActionWindowsMac
Extend selection by one cellShift+Arrow keyShift+Arrow key
Extend to the edge of the current data regionCtrl+Shift+Arrow keyCommand+Shift+Arrow key
Select an entire columnCtrl+SpaceControl+Space
Select an entire rowShift+SpaceShift+Space
Select the current region; press again for the sheetCtrl+ACommand+A
Formatting and editing
ActionWindowsMac
Open Format CellsCtrl+1Command+1
BoldCtrl+BCommand+B
ItalicCtrl+ICommand+I
UnderlineCtrl+UCommand+U
Edit the active cellF2Control+U
UndoCtrl+ZCommand+Z
RedoCtrl+YCommand+Y
Formulas
ActionWindowsMac
Start a formula==
Insert AutoSumAlt+=Command+Shift+T
Toggle relative and absolute references while editingF4Command+T
Show or hide formulasCtrl+grave accentControl+grave accent
Recalculate all open workbooksF9F9
Data
ActionWindowsMac
Create a tableCtrl+TControl+T
Turn filters on or offCtrl+Shift+LCommand+Shift+F
Open the Sort dialogAlt+A, S, S—
Fill downCtrl+DCommand+D
Insert the current dateCtrl+;Control+;
Insert the current timeCtrl+Shift+;Command+;

How to use this cheat sheet

Keyboard shortcuts are most useful when they replace an action you repeat, not when you try to memorize an entire list. Choose three commands from one group, use them for a week, then add another group. Navigation and selection usually save the most time first because they reduce long mouse trips across a worksheet.

A plus sign means hold the keys together. A comma in Alt+A, S, S means press the first combination and then the following keys in sequence. On compact keyboards, function keys such as F2, F4, and F9 may require the Fn key. Mac keyboard settings can also assign function keys to system controls, so use Fn when the workbook does not receive the command.

The tables describe current desktop Excel behavior. Excel for the web, remote desktops, browser shortcuts, keyboard layouts, and macOS system assignments can intercept some combinations. If a shortcut opens the browser or operating system instead, use the ribbon command and check the application’s shortcut settings.

Navigation and selection belong together

Ctrl+Arrow on Windows and Command+Arrow on Mac jump to the boundary of the current data region. Add Shift to extend the selection to that boundary. This pair is useful for reviewing imports, selecting formula ranges, and finding where a supposedly continuous column contains a blank.

The boundary depends on the active cell and nearby blanks. From inside a filled block, the command stops at its edge; from a blank beside the block, it jumps toward the next nonblank cell. Look at the Name Box and the highlighted range before deleting, formatting, or filling. Whole-column and whole-row selections are powerful but can make formulas slower when used carelessly in large workbooks.

Ctrl+A or Command+A first selects the current region when the active cell is inside data. Pressing it again can expand the selection to the worksheet. That two-stage behavior is why you should pause before applying Delete or a format to the result.

Formatting and formula keys worth learning

Ctrl+1 on Windows and Command+1 on Mac open Format Cells, where you can set number formats, alignment, borders, fills, and protection. This is more predictable than memorizing many specialized number-format shortcuts. Bold, italic, and underline use the familiar B, I, and U combinations.

While editing a reference in a formula, F4 on Windows or Command+T on Mac cycles through $A$1, A$1, $A1, and A1. This is faster and less error-prone than typing dollar signs by hand. The shortcut acts on the reference at the insertion point, so select or place the cursor inside the intended reference first.

The grave-accent shortcut shows formulas instead of results, which is useful for spotting inconsistent rows. Press it again to return to results. AutoSum proposes a nearby range; always inspect the moving border and formula before accepting it, especially when blanks or text interrupt the column.

Data shortcuts and safe habits

Ctrl+T or Control+T converts a selected range into an Excel Table after you confirm the range and header setting. Tables add filter buttons and structured expansion, but the command does not repair mixed headers or blank rows. Check the dialog before accepting it.

Filter shortcuts toggle filters for the current range or table. A filter hides rows; it does not delete them. Before copying, filling, or pasting into filtered data, confirm whether the operation affects only visible cells or the underlying range. Use the ribbon when a multi-step command is clearer than a shortcut.

Date and time shortcuts insert fixed values, unlike TODAY or NOW, which recalculate. On Mac, the time shortcut is Command+;; on Windows it is Ctrl+Shift+;. This difference is easy to mix up, so test it in an empty cell before using it in a live register.

Your turn

In D2, total the amounts in B2:B5 with SUM.

Example spreadsheet for expense list
ABCD
1ItemAmountTotal
2Travel20
3Meals12
4Supplies8
5Other10
Not yet solved.

Worked example

A small sales block for checking formula-entry and reference shortcuts. The formulas demonstrate values that remain correct after keyboard-driven selection.

ABC
1ItemQtyPrice
2Pens32
3Paper54
4Folders26
FormulaResult
=SUM(B2:B4)10
=SUM(C2:C4)12
=B2*C26
=SUM(B2:B4)*C220

Quick mistake checklist

  • Selecting a full column without checking what will be changed.
  • Assuming a browser, laptop, or operating-system shortcut reaches Excel.
  • Accepting an AutoSum range without inspecting it.
  • Trying to memorize dozens of keys before using a small set repeatedly.

Frequently asked questions

Why does an F-key shortcut change brightness or volume?

Your keyboard is sending a system command. Hold Fn, or change the function-key setting so the application receives F2, F4, or F9.

Are Windows and Mac shortcuts identical?

Many editing shortcuts are similar, but navigation, formulas, dates, times, and ribbon access differ. Use the platform-specific column.

What shortcut should I learn first?

Start with movement to a data edge, extending a selection, Format Cells, and editing the active cell; they apply to many tasks.

Do these shortcuts work in Excel for the web?

Some do, but browsers and operating systems can intercept keys. This sheet is for the Windows and Mac desktop applications.

Practice the skill

Continue with a checked FormulaCamp lesson: Keyboard Shortcuts and Common Beginner Mistakes Free

Open the free lesson