What is this shortcut page for?

It covers 466 keyboard shortcuts for Excel across 23 categories. The range goes from basic cell navigation and data entry to more specialized areas like Power Pivot, chart editing, and the ribbon Access Keys system.

With 23 categories and nearly 500 shortcuts, where do I even start?

Open Frequently used shortcuts first. From there, Work in cells or the Formula bar and navigating in cells cover the everyday actions that make the biggest difference in speed.

Are there significant differences between Mac and Windows shortcuts in Excel?

More than in most apps, yes. Windows Excel relies heavily on function keys and the Access Keys system for ribbon navigation, which works quite differently on Mac. It is worth filtering to your OS before you start learning.

Should I try to work through all 466 shortcuts?

That is not realistic or necessary. Focus on the categories that match what you actually do in Excel, whether that is formatting, formulas, or selecting data, and use the full list as a reference when you encounter something unfamiliar.

Are the most practical shortcuts grouped in a few sections, or scattered across the whole page?

They are spread across multiple sections, but not evenly. Frequently used shortcuts, Select cells columns or rows, and Format and edit data have the highest density of everyday-useful shortcuts. Sections like Power Pivot or Outline data are only relevant for specific workflows.

App Cheat Sheet

Excel Hotkeys

Turn data into insights with free and premium spreadsheets.

Excel keyboard shortcuts are organized by category and available for Windows, macOS, and Linux. Search by keyword or browse by section.

data, functions, and the formula bar46

Action	Hotkey
Expand or collapse the formula bar.	`Ctrl`+`Shift`+`U`
Insert argument names and parentheses when the insertion point is to the right of a function name in a formula.	`Ctrl`+`Shift`+`A`
Select the current and next sheet in a workbook.	`Ctrl`+`Shift`+`Page down`
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.	`Ctrl`+`Alt`+`F9`
Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference.	`F2`
Add a non-adjacent cell or range to a selection of cells by using the arrow keys.	`Shift`+`F8`
Fill the selected cell range with the current entry.	`Ctrl`+`Enter`
Insert a function.	`Shift`+`F3`
Select the first command on the menu when a menu or submenu is visible.	`Home`
Cancel an entry in the cell or formula bar.	`Esc`
Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected.	`F4`
Insert theAutoSumformula	`Alt`+`Equal sign ( = )`
Move the cursor to the end of the text when in the formula bar.	`Ctrl`+`End`
Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheet.	`Ctrl`+`A` `Ctrl`+`Shift`+`Spacebar`
Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.	`Ctrl`+`Alt`+`Shift`+`F9`
Extend the selection of cells by one cell.	`Shift`+`Arrow key`
Create, run, edit, or delete a macro.	`Alt`+`F8`
Calculate all worksheets in all open workbooks.	`F9`
Calculate the active worksheet.	`Shift`+`F9`
Display theFunction Argumentsdialog box when the insertion point is to the right of a function name in a formula.	`Ctrl`+`A`
Display the menu or message for anError Checkingbutton.	`Alt`+`Shift`+`F10`
Create an embedded chart of the data in the current range.	`Alt`+`F1`
Select all objects on a worksheet when an object is selected.	`Ctrl`+`Shift`+`Spacebar`
Complete an entry in the formula bar and select the cell below.	`Enter`
Complete a cell entry and select the cell above.	`Shift`+`Enter`
Select the current and previous sheet in a workbook.	`Ctrl`+`Shift`+`Page up`
InvokeFlash Fillto automatically recognize patterns in adjacent columns and fill the current column	`Ctrl`+`E`
Extend the selection of cells to the beginning of the worksheet.	`Ctrl`+`Shift`+`Home`
Select an entire column in a worksheet.	`Ctrl`+`Spacebar`
Open theMicrosoft Visual Basic For Applications Editor.	`Alt`+`F11`
Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.	`Ctrl`+`Shift`+`Arrow key`
Open thePower Query Editor	`Alt`+`F12`
Select the current region around the active cell.	`Ctrl`+`ShiftAsterisk sign (*)`
Define a name to use in references.	`Alt`+`M`+`M`+`D`
Select the entire worksheet.	`Ctrl`+`A` `Ctrl`+`Shift`+`Spacebar`
Undo the last action.	`Ctrl`+`Z`
Turn extend mode on and use the arrow keys to extend a selection. Press again to turn off.	`F8`
Paste a name from thePaste Namedialog box (if names have been defined in the workbook).	`F3`
Create a chart of the data in the current range in a separateChartsheet.	`F11`
Start a new line in the same cell.	`Alt`+`Enter`
Turn on or off tooltips for checking formulas directly in the formula bar or in the cell you’re editing.	`Ctrl`+`Alt`+`P`
Copy the value from the cell above the active cell into the cell or the formula bar.	`Ctrl`+`ShiftStraight quotation mark (")`
Select an entire row in a worksheet.	`Shift`+`Spacebar`
Move to the first field in the next record of a data form.	`Enter`
Repeat the last command or action, if possible.	`Ctrl`+`Y`
Select all text in the formula bar from the cursor position to the end.	`Ctrl`+`Shift`+`End`

data, functions, and the formula bar46

Action	Hotkey
Expand or collapse the formula bar.	`Ctrl`+`Shift`+`U`
Insert argument names and parentheses when the insertion point is to the right of a function name in a formula.	`Ctrl`+`Shift`+`A`
Select the current and next sheet in a workbook.	`Ctrl`+`Shift`+`Page down`
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.	`Ctrl`+`Alt`+`F9`
Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference.	`F2`
Add a non-adjacent cell or range to a selection of cells by using the arrow keys.	`Shift`+`F8`
Fill the selected cell range with the current entry.	`Ctrl`+`Enter`
Insert a function.	`Shift`+`F3`
Select the first command on the menu when a menu or submenu is visible.	`Home`
Cancel an entry in the cell or formula bar.	`Esc`
Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected.	`F4`
Insert theAutoSumformula	`Alt`+`Equal sign ( = )`
Move the cursor to the end of the text when in the formula bar.	`Ctrl`+`End`
Select the current region if the worksheet contains data. Press a second time to select the current region and its summary rows. Press a third time to select the entire worksheet.	`Ctrl`+`A` `Ctrl`+`Shift`+`Spacebar`
Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.	`Ctrl`+`Alt`+`Shift`+`F9`
Extend the selection of cells by one cell.	`Shift`+`Arrow key`
Create, run, edit, or delete a macro.	`Alt`+`F8`
Calculate all worksheets in all open workbooks.	`F9`
Calculate the active worksheet.	`Shift`+`F9`
Display theFunction Argumentsdialog box when the insertion point is to the right of a function name in a formula.	`Ctrl`+`A`
Display the menu or message for anError Checkingbutton.	`Alt`+`Shift`+`F10`
Create an embedded chart of the data in the current range.	`Alt`+`F1`
Select all objects on a worksheet when an object is selected.	`Ctrl`+`Shift`+`Spacebar`
Complete an entry in the formula bar and select the cell below.	`Enter`
Complete a cell entry and select the cell above.	`Shift`+`Enter`
Select the current and previous sheet in a workbook.	`Ctrl`+`Shift`+`Page up`
InvokeFlash Fillto automatically recognize patterns in adjacent columns and fill the current column	`Ctrl`+`E`
Extend the selection of cells to the beginning of the worksheet.	`Ctrl`+`Shift`+`Home`
Select an entire column in a worksheet.	`Ctrl`+`Spacebar`
Open theMicrosoft Visual Basic For Applications Editor.	`Alt`+`F11`
Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.	`Ctrl`+`Shift`+`Arrow key`
Open thePower Query Editor	`Alt`+`F12`
Select the current region around the active cell.	`Ctrl`+`ShiftAsterisk sign (*)`
Define a name to use in references.	`Alt`+`M`+`M`+`D`
Select the entire worksheet.	`Ctrl`+`A` `Ctrl`+`Shift`+`Spacebar`
Undo the last action.	`Ctrl`+`Z`
Turn extend mode on and use the arrow keys to extend a selection. Press again to turn off.	`F8`
Paste a name from thePaste Namedialog box (if names have been defined in the workbook).	`F3`
Create a chart of the data in the current range in a separateChartsheet.	`F11`
Start a new line in the same cell.	`Alt`+`Enter`
Turn on or off tooltips for checking formulas directly in the formula bar or in the cell you’re editing.	`Ctrl`+`Alt`+`P`
Copy the value from the cell above the active cell into the cell or the formula bar.	`Ctrl`+`ShiftStraight quotation mark (")`
Select an entire row in a worksheet.	`Shift`+`Spacebar`
Move to the first field in the next record of a data form.	`Enter`
Repeat the last command or action, if possible.	`Ctrl`+`Y`
Select all text in the formula bar from the cursor position to the end.	`Ctrl`+`Shift`+`End`

Excel Hotkeys

data, functions, and the formula bar46

Excel Hotkeys

data, functions, and the formula bar46

Frequently Asked Questions

Word

PowerPoint

Pages

Google Docs

Numbers

Keynote

Excel Hotkeys

data, functions, and the formula bar46

Excel Hotkeys

data, functions, and the formula bar46

Frequently Asked Questions

What is this shortcut page for?

With 23 categories and nearly 500 shortcuts, where do I even start?

Are there significant differences between Mac and Windows shortcuts in Excel?

Should I try to work through all 466 shortcuts?

Are the most practical shortcuts grouped in a few sections, or scattered across the whole page?

Related Apps

Word

PowerPoint

Pages

Google Docs

Numbers

Keynote