What are the most useful Excel keyboard shortcuts?

The most essential Excel shortcuts are: F2 (Edit Cell), Enter (Confirm & Move Down), Shift + Enter (Confirm & Move Up). These cover the most frequent actions and can significantly speed up your workflow.

What is the Excel shortcut for edit cell?

The Excel shortcut for edit cell is F2 on Windows or F2 on Mac. Enter edit mode for selected cell.

What is the Excel shortcut for format cells?

The Excel shortcut for format cells is Ctrl + 1 on Windows or Cmd + 1 on Mac. Open Format Cells dialog for all formatting options.

What is the Excel shortcut for thousand separator?

The Excel shortcut for thousand separator is Ctrl + Shift + ! on Windows or Cmd + Shift + ! on Mac. Add thousand separator to numbers.

How do I use keyboard shortcuts in Excel?

To use keyboard shortcuts in Excel, simply press the key combination while the application is focused. Most shortcuts work immediately without any additional setup. On Mac, replace Ctrl with Cmd and Alt with Option for most shortcuts.

How many keyboard shortcuts does Excel have?

Excel has 90 keyboard shortcuts across 10 categories on shortcut-tools.com. These cover all major features and workflows.

All Shortcuts

Excel Shortcuts & Commands — Complete Cheat Sheet (89)

Complete Microsoft Excel keyboard shortcuts for navigation, editing, formatting, and formula operations. Essential reference for spreadsheet power users.

Search all Excel shortcuts interactively

Interactive Shortcut Finder

All Excel Shortcuts

Cell Editing & Input

Shortcut	Action	Description
`F2`	Edit Cell	Enter edit mode for selected cell.
`Enter`	Confirm & Move Down	Confirm input and move down.
`Shift` + `Enter`	Confirm & Move Up	Confirm input and move up.
`Tab`	Confirm & Move Right	Confirm input and move right.
`Shift` + `Tab`	Confirm & Move Left	Confirm input and move left.
`Ctrl` + `D`	Fill Down	Copy top cell content down to selected range.
`Ctrl` + `R`	Fill Right	Copy left cell content right to selected range.
`Ctrl` + `Shift` + `:`	Current Time	Insert current time as fixed value.
`Alt` + `Enter`	New Line in Cell	Insert line break within same cell.
`Ctrl` + `Enter`	Fill Selection	Fill all selected cells with same value.
`Ctrl` + `Delete`	Delete to End	Delete from cursor to end of cell.
`Delete`	Delete Content	Delete content of selected cells.
`Ctrl` + `-`	Delete Cells/Rows/Columns	Delete selected cells, rows, or columns.
`Ctrl` + `Shift` + +	Insert Cells/Rows/Columns	Insert new cells, rows, or columns.

Cell Formatting

Shortcut	Action	Description
`Ctrl` + `1`	Format Cells	Open Format Cells dialog for all formatting options.
`Ctrl` + `B`	Bold	Make selected text bold or unbold.
`Ctrl` + `I`	Italic	Make selected text italic or remove italic.
`Ctrl` + `U`	Underline	Add or remove underline from text.
`Ctrl` + `5`	Strikethrough	Add or remove strikethrough from text.
`Ctrl` + `Shift` + `&`	Apply Border	Apply border to selected cells.
`Ctrl` + `Shift` + `_`	Remove Border	Remove borders from selected cells.
`Alt` + `H` + `H`	Fill Color	Change cell background color.
`Alt` + `H` + `F` + `C`	Font Color	Change font color.

Number Formatting

Shortcut	Action	Description
`Ctrl` + `Shift` + `!`	Thousand Separator	Add thousand separator to numbers.
`Ctrl` + `Shift` + `$`	Currency Format	Apply currency format.
`Ctrl` + `Shift` + `%`	Percentage Format	Apply percentage format.
`Ctrl` + `Shift` + `^`	Scientific Format	Apply scientific notation format.
`Ctrl` + `Shift` + `#`	Date Format	Apply date format (day-month-year).
`Ctrl` + `Shift` + `@`	Time Format	Apply time format.
`Ctrl` + `Shift` + `~`	General Format	Apply general number format.

Navigation & Movement

Shortcut	Action	Description
`Ctrl` + `Home`	Go to A1	Jump to cell A1 (start of worksheet).
`Ctrl` + `End`	Last Cell	Jump to last used cell.
`Ctrl` + `Arrow`	Jump to Edge	Jump to edge of data region in arrow direction.
`Home`	Start of Row	Go to first column of current row.
`Ctrl` + `Page Up`	Previous Sheet	Move to previous worksheet.
`Ctrl` + `Page Down`	Next Sheet	Move to next worksheet.
`Ctrl` + `G`	Go To	Open Go To dialog to jump to specific cell.
`F5`	Go To	Same as Ctrl+G - opens Go To dialog.
`Ctrl` + `Backspace`	Show Active Cell	Scroll to make active cell visible.
`Page Up/Down`	Screen Navigation	Move one screen up or down.

Selection

Shortcut	Action	Description
`Ctrl` + `A`	Select All	Select entire worksheet.
`Ctrl` + `Space`	Select Column	Select entire current column.
`Shift` + `Space`	Select Row	Select entire current row.
`Ctrl` + `Shift` + `Space`	Select Data Region	Select entire current data region.
`Shift` + `Arrow`	Extend Selection	Extend selection in arrow direction.
`Ctrl` + `Shift` + `Arrow`	Extend to Edge	Extend selection to edge of data.
`Shift` + `Home`	Select to Row Start	Extend selection to start of row.
`Ctrl` + `Shift` + `Home`	Select to A1	Select from current cell to A1.
`Ctrl` + `Shift` + `End`	Select to Last	Select from current cell to last used cell.

Formulas & Functions

Shortcut	Action	Description
`=`	Start Formula	Begin entering a formula.
`Alt` + `=`	AutoSum	Automatically insert SUM function.
`F4`	Toggle Reference	Toggle between absolute/relative reference types ($A$1, A$1, $A1, A1).
`Ctrl` + `	Show Formulas	Toggle between showing values and formulas.
`F9`	Calculate All	Calculate all worksheets in all open workbooks.
`Shift` + `F9`	Calculate Sheet	Calculate only active worksheet.
`Ctrl` + `Alt` + `F9`	Force Calculate	Force recalculation of all formulas.

Data Management

Shortcut	Action	Description
`Ctrl` + `T`	Create Table	Convert selected range to Excel table.
`Ctrl` + `Shift` + `L`	Toggle Filter	Add or remove AutoFilter.
`Alt` + `Down`	Open Filter	Open filter dropdown for selected column.
`Ctrl` + `Shift` + `O`	Select Comments	Select all cells with comments.
`F3`	Paste Name	Paste defined name into formula.
`Ctrl` + `F3`	Name Manager	Open Name Manager to define/edit names.

Find & Replace

Shortcut	Action	Description
`Ctrl` + `F`	Find	Open Find dialog to search for data.
`Ctrl` + `H`	Replace	Open Find and Replace dialog.
`Shift` + `F4`	Find Next	Find next occurrence of search term.
`Ctrl` + `Shift` + `F4`	Find Previous	Find previous occurrence of search term.

Row/Column Management

Shortcut	Action	Description
`Ctrl` + `9`	Hide Rows	Hide selected rows.
`Ctrl` + `Shift` + `9`	Unhide Rows	Unhide rows in selection.
`Ctrl` + `0`	Hide Columns	Hide selected columns.
`Ctrl` + `Shift` + `0`	Unhide Columns	Unhide columns in selection.
`Alt` + `H` + `O` + `I`	AutoFit Column	Auto-fit column width to content.
`Alt` + `H` + `O` + `A`	AutoFit Row	Auto-fit row height to content.

Workbook Management

Shortcut	Action	Description
`Ctrl` + `N`	New Workbook	Create new workbook.
`Ctrl` + `O`	Open	Open existing file.
`Ctrl` + `S`	Save	Save current workbook.
`F12`	Save As	Open Save As dialog.
`Ctrl` + `P`	Print	Open Print dialog.
`Ctrl` + `W`	Close	Close current workbook or document.
`Ctrl` + `F4`	Close Window	Close current window.
`Alt` + `F4`	Exit Excel	Quit Excel application.
`Ctrl` + `F6`	Next Window	Switch to next window.
`Ctrl` + `Tab`	Switch Workbooks	Switch between open workbooks.
`Alt` + `F11`	VBA Editor	Open Visual Basic Editor.
`Ctrl` + `F1`	Toggle Ribbon	Show or hide the ribbon.
`Alt` + `F1`	Chart	Create chart from selected data.
`F2`	Edit Cell	Edit active cell.
`Ctrl` + `F9`	Minimize	Minimize workbook window.
`Ctrl` + `F10`	Maximize	Maximize/restore workbook window.
`Shift` + `F11`	New Sheet	Insert new worksheet.

Pro Tips

Ctrl+Arrow keys jump to the edge of data regions instantly
F2 enters edit mode in the selected cell
Ctrl+; inserts the current date, Ctrl+Shift+; inserts the current time
Alt+= auto-sums the column above the selected cell

Frequently Asked Questions

How do I quickly sum a column in Excel?

Select a cell below the column and press Alt+= to auto-sum. Or use Ctrl+Shift+Enter for array formulas.

What is the shortcut to insert a new row in Excel?

Select a row, then press Ctrl+Shift++ (plus) to insert a new row above.

How do I navigate to the last cell with data?

Press Ctrl+End to go to the last used cell, or Ctrl+Arrow to jump to the edge of data.

How do I fill down in Excel?

Select cells and press Ctrl+D to fill down from the top cell.

Browse shortcuts for 230 platforms

Explore All