app · Mac, Windows, Web
Excel Keyboard Shortcuts
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
Use this as the main reference: shortcut first, menu fallback second, and the note column for version or platform differences.
| Action | Mac | Windows / Web | Note |
|---|---|---|---|
| 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
- Make sure the app or browser tab is focused before pressing the shortcut.
- Check whether a system shortcut, browser extension, or custom keyboard setting is intercepting the keys.
- Use the menu path as a fallback when the shortcut is unavailable on your platform.
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.