Cellwise Start free

Excel shortcuts

Excel Ctrl shortcuts from A to Z

Every Ctrl+letter on Windows and Cmd+letter on a Mac that Microsoft lists for Excel, A to Z. Most match, a few do something different on each platform, and some letters have no Excel command at all. Ctrl with a digit and the Ctrl+Shift letters are listed below the alphabet.

Checked against Microsoft's official lists on . Where Microsoft lists a key for one platform only, the other column says so instead of guessing.

Ctrl+letter and Cmd+letter, A to Z

KeyWindowsMac: CmdMac: Control
ACtrlA Select the current region, then the whole sheetCtrlA After typing a function name, open its argumentsCommandA Select the current region, then the whole sheetControlA After typing a function name, open its arguments
BCtrlB BoldCommandB BoldControlB Bold
CCtrlC Copy the selectionCommandC Copy the selectionControlC Copy the selection
DCtrlD Fill down from the cell aboveCommandD Fill down from the cell aboveControlD Fill down from the cell above
ECtrlE Flash Fill the column from your examplesCommandE Center the cell contentsControlE Flash Fill the column from your examples
FCtrlF FindCommandF Search the sheet from the search boxControlF Find
GCtrlG Go to a cell or range (Go To)—No Mac shortcut in Microsoft's listControlG Go to a cell or range (Go To)
HCtrlH Find and replaceCommandH Hide ExcelControlH Find and replace
ICtrlI ItalicCommandI ItalicControlI Italic
JCtrlJ Copilot: confirm the selected filesCommandJ Copilot: confirm the selected files—No Mac shortcut in Microsoft's list
KCtrlK Insert a hyperlinkCommandK Insert a hyperlinkControlK Insert a hyperlink
LCtrlL Create a tableCommandL Align leftControlL Define a name
M—No Windows shortcut in Microsoft's list—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
NCtrlN Create a new blank workbookCommandN Create a new blank workbookControlN Create a new blank workbook
OCtrlO Open a workbookCommandO Open a workbookControlO Open a workbook
PCtrlP Print or preview the workbookCommandP Print or preview the workbookControlP Print or preview the workbook
QCtrlQ Open Quick Analysis for the selected dataCommandQ Quit Excel—No Mac shortcut in Microsoft's list
RCtrlR Fill right from the cell to the leftCommandR Fill right from the cell to the leftControlR Fill right from the cell to the left
SCtrlS Save the workbookCommandS Save the workbookControlS Save the workbook
TCtrlT Create a tableCommandT Switch a reference between A1, $A$1, A$1 and $A1CommandT Create a tableControlT Create a table
UCtrlU UnderlineCommandU UnderlineControlU Edit the active cell
VCtrlV PasteCommandV PasteControlV Paste
WCtrlW Close the workbook windowCommandW Close the workbook windowControlW Close the workbook window
XCtrlX Cut the selectionCommandX Cut the selectionControlX Cut the selection
YCtrlY RedoCtrlY Repeat the last action, such as inserting a row or applying a formatCommandY RedoControlY Redo
ZCtrlZ Undo the last actionCommandZ Undo the last actionControlZ Undo the last action

With Shift: Ctrl+Shift+letter and Cmd+Shift+letter

KeyWindowsMac: CmdMac: Control
ACtrlShiftA After typing a function name, insert its argument names—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
FCtrlShiftF Open Format Cells on the Font tabCommandShiftF Turn filters on or off—No Mac shortcut in Microsoft's list
GCtrlShiftG Open Workbook Statistics—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
H—No Windows shortcut in Microsoft's listCommandShiftH Find and replace—No Mac shortcut in Microsoft's list
J—No Windows shortcut in Microsoft's listCommandShiftJ Ungroup the selected rows or columns—No Mac shortcut in Microsoft's list
K—No Windows shortcut in Microsoft's listCommandShiftK Group the selected rows or columns—No Mac shortcut in Microsoft's list
LCtrlShiftL Turn filters on or offShiftCommandL Open Modify Cell StyleControlShiftL Turn filters on or off
MCtrlShiftM Copilot: switch between edit, chat and plan modeCommandShiftM Copilot: switch between edit, chat and plan mode—No Mac shortcut in Microsoft's list
P—No Windows shortcut in Microsoft's listCommandShiftP Create a new workbook from a template—No Mac shortcut in Microsoft's list
R—No Windows shortcut in Microsoft's listCommandShiftR Open the Sort dialog—No Mac shortcut in Microsoft's list
S—No Windows shortcut in Microsoft's listCommandShiftS Save As—No Mac shortcut in Microsoft's list
T—No Windows shortcut in Microsoft's listShiftCommandT AutoSum the cells above or to the left—No Mac shortcut in Microsoft's list
UCtrlShiftU Expand or collapse the formula bar—No Mac shortcut in Microsoft's listControlShiftU Expand or collapse the formula bar
X—No Windows shortcut in Microsoft's listShiftCommandX Strikethrough—No Mac shortcut in Microsoft's list
Z—No Windows shortcut in Microsoft's listCommandShiftZ Redo—No Mac shortcut in Microsoft's list

Ctrl with a digit, and the number-format symbols

KeyWindowsMac: CmdMac: Control
0Ctrl0 Hide the selected columns—No Mac shortcut in Microsoft's listControl0 Hide the selected columns
1Ctrl1 Open Format CellsCommand1 Open Format CellsControl1 Open Format Cells
2Ctrl2 Bold—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
3Ctrl3 Italic—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
4Ctrl4 Underline—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
5Ctrl5 Strikethrough—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
6Ctrl6 Hide objects, show them, or show placeholders—No Mac shortcut in Microsoft's listControl6 Hide objects, show them, or show placeholders
7—No Windows shortcut in Microsoft's list—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
8Ctrl8 Show or hide the outline symbols—No Mac shortcut in Microsoft's listControl8 Show or hide the outline symbols
9Ctrl9 Hide the selected rows—No Mac shortcut in Microsoft's listControl9 Hide the selected rows
!CtrlShift! Number format: 2 decimals, thousands separator, minus sign for negatives—No Mac shortcut in Microsoft's listControlShift! Number format: 2 decimals, thousands separator, minus sign for negatives
@CtrlShift@ Time format with hour, minute and AM/PM—No Mac shortcut in Microsoft's listControlShift@ Time format with hour, minute and AM/PM
#CtrlShift# Date format with day, month and year—No Mac shortcut in Microsoft's listControlShift# Date format with day, month and year
$CtrlShift$ Currency format with 2 decimals—No Mac shortcut in Microsoft's listControlShift$ Currency format with 2 decimals
%CtrlShift% Percentage format with no decimals—No Mac shortcut in Microsoft's listControlShift% Percentage format with no decimals
^CtrlShift^ Scientific format with 2 decimals—No Mac shortcut in Microsoft's listControlShift^ Scientific format with 2 decimals
~CtrlShift~ General number format—No Mac shortcut in Microsoft's listControlShift~ General number format
&CtrlShift& Add an outline border around the selection—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
_CtrlShift_ Remove the outline border—No Mac shortcut in Microsoft's list—No Mac shortcut in Microsoft's list
;Ctrl; Enter today's dateCtrlShift; Enter the current timeCommand; Enter the current timeControl; Enter today's date
`Ctrl` Show formulas instead of results, and back—No Mac shortcut in Microsoft's listControl` Show formulas instead of results, and back
'Ctrl' Copy the formula from the cell above, unchanged—No Mac shortcut in Microsoft's listControl' Copy the formula from the cell above, unchanged

Power Pivot window keys (Ctrl+D deletes a table there, Ctrl+M moves one) are on the data page.

Why a shortcut sometimes does nothing

F4 vs Cmd+T on a Mac

On Windows, F4 has two jobs: while you edit a formula it switches a reference between A1, $A$1, A$1 and $A1, and the rest of the time it repeats your last action. On a Mac, CommandT and F4 both switch the reference, but CommandT creates a table when you are not editing a formula. On a Mac laptop F4 may need Fn.

Excel for the web: the browser takes some keys

In a browser, a few keys belong to the browser first: F1 opens the browser's help, CtrlO opens a file, CtrlW closes the tab, and F6 moves around the browser. Excel for the web uses CtrlF6 instead of F6, CtrlAltPage Down for the next sheet in Chrome, and AltWindows key with a letter for ribbon tabs. To get desktop behavior back, go to Help > Keyboard Shortcuts and select Override browser shortcuts. If the file opened in Viewing mode, editing shortcuts do nothing until you switch to Editing.

Non-US keyboards

Microsoft's lists are written for the US keyboard layout and say that keys on other layouts might not correspond exactly. Shortcuts named after a symbol, such as Ctrl;, Ctrl` or CtrlShift$, are the ones most likely to sit somewhere else or not work. When one does nothing, use the ribbon route on its task page instead.

Related guides