app · Mac, Windows, Web

Excel Keyboard Shortcuts

ExcelMac, Windows, Webapp reference39 shortcuts
Quick answer

Excel shortcuts are easiest to learn by task: navigation, editing, formatting, and view controls. Start with the table below, then use the menu path fallback when a key combination is blocked.

Reference table

Shortcut Library

39 practical entries

Use this as the main reference: shortcut first, menu fallback second, and the note column for version or platform differences.

ActionMacWindows / WebNote
Move one cell Arrow keys Arrow keys Basic navigation.
Move to edge of data region Command + Arrow Ctrl + Arrow Jump across contiguous data.
Select to edge of data region Shift + Command + Arrow Ctrl + Shift + Arrow Selects range to edge.
Go to beginning of row Home or Fn + Left Home Keyboard-dependent on Mac.
Go to cell A1 Control + Home or Fn + Control + Left Ctrl + Home Workbook navigation.
Go to last used cell Control + End or Fn + Control + Right Ctrl + End Depends on used range.
Open Go To Control + G Ctrl + G Jump to cell or named range.
Open Find Command + F Ctrl + F Search the worksheet.
Replace Control + H Ctrl + H Find and replace.
Edit active cell Control + U F2 Mac shortcuts can vary by keyboard.
Enter same data in selected cells Control + Return Ctrl + Enter Fills selected range.
Fill down Command + D Ctrl + D Copies the cell above into the selection.
Fill right Command + R Ctrl + R Copies from left into selection.
AutoSum Command + Shift + T Alt + = Mac behavior can vary by version.
Insert table Command + T Ctrl + T Creates a structured table.
Insert current date Control + ; Ctrl + ; Static date.
Insert current time Command + ; Ctrl + Shift + ; Static time.
Paste Command + V Ctrl + V Normal paste.
Paste Special Control + Command + V Ctrl + Alt + V Some Mac versions use Command + Control + V.
Bold Command + B Ctrl + B Text formatting.
Italic Command + I Ctrl + I Text formatting.
Underline Command + U Ctrl + U Text formatting.
Format Cells Command + 1 Ctrl + 1 Opens formatting dialog.
Apply currency format Control + Shift + $ Ctrl + Shift + $ Currency number format.
Apply percent format Control + Shift + % Ctrl + Shift + % Percent number format.
Select entire row Shift + Space Shift + Space Select row.
Select entire column Control + Space Ctrl + Space Mac behavior can depend on system shortcuts.
Insert cells Control + Shift + = Ctrl + Shift + = Insert dialog.
Delete cells Command + - Ctrl + - Delete dialog.
Hide row Command + 9 Ctrl + 9 Hide selected rows.
Unhide row Shift + Command + 9 Ctrl + Shift + 9 Unhide selected rows.
Hide column Control + 0 Ctrl + 0 Mac conflict possible.
Unhide column Shift + Control + 0 Ctrl + Shift + 0 Often disabled by Windows language settings.
New worksheet Shift + F11 Shift + F11 Some keyboards require Fn.
Next worksheet Option + Right Arrow Ctrl + Page Down Move across sheet tabs.
Previous worksheet Option + Left Arrow Ctrl + Page Up Move across sheet tabs.
Open filter dropdown Option + Down Arrow Alt + Down Arrow Works in filtered tables.
Create chart F11 or Fn + F11 Alt + F1 or F11 Chart behavior varies by platform.
Recalculate workbook Command + = F9 Depends on calculation settings.

Menu Path Fallback

Open the app menu bar or command palette, then search for the action name shown in the table.

Compatibility

Excel shortcuts can vary by operating system, app version, browser mode, and keyboard layout. Confirm platform-specific details before training a team or publishing an internal SOP.

If It Does Not Work

FAQ

Why do shortcuts differ between Mac and Windows?

Modifier keys, app versions, browser focus, and keyboard layouts can change the exact shortcut.

What should I do if a shortcut does not work?

Check whether the app window is focused, confirm the platform, try the menu path, and look for system-level shortcut conflicts.

Are these pages a replacement for official docs?

No. They are practical reference pages with links to official sources where version-specific details should be checked.

Source checkpoint: Microsoft Support · Official reference. Shortcut behavior can change by app version and platform.

Related References