Essential Excel Keyboard Shortcuts Every User Should Know

Reaching for your mouse every time you want to select a column, insert a row, or format a number adds up to hours of wasted time over the course of a month. Learning even a dozen core Excel shortcuts can drastically boost your speed and efficiency.

Here is a breakdown of the most useful Excel shortcuts, grouped into tables by how you'll use them in your daily workflow.

1. Fast Navigation and Selection

Moving around large spreadsheets cell-by-cell with the arrow keys is slow. Combine Ctrl or Cmd with Shift and the arrow keys to jump and select instantly.

Action	Windows Shortcut	Mac Shortcut
Jump to edge of data region	`Ctrl` + `Arrow Key`	`Cmd` + `Arrow Key`
Select to edge of data region	`Ctrl` + `Shift` + `Arrow Key`	`Cmd` + `Shift` + `Arrow Key`
Select entire table / worksheet	`Ctrl` + `A`	`Cmd` + `A`
Jump to cell A1	`Ctrl` + `Home`	`fn` + `Cmd` + `Left Arrow`
Jump to last used cell	`Ctrl` + `End`	`fn` + `Cmd` + `Right Arrow`

Tip: If your dataset has 10,000 rows, click the header cell, press Ctrl + Shift + Down Arrow (or Cmd + Shift + Down Arrow on Mac), and you'll highlight the entire column in milliseconds.

2. Row and Column Management

Inserting or deleting rows and columns is one of the most common tasks in spreadsheet design.

Action	Windows Shortcut	Mac Shortcut
Select entire row	`Shift` + `Space`	`Shift` + `Space`
Select entire column	`Ctrl` + `Space`	`Control` + `Space`
Insert row / column	`Ctrl` + `+`	`Cmd` + `+`
Delete row / column	`Ctrl` + `-`	`Cmd` + `-`
Hide selected row(s)	`Ctrl` + `9`	`Cmd` + `9`
Hide selected column(s)	`Ctrl` + `0`	`Cmd` + `0`

3. Data Entry and Editing

Speed up repetitive typing and editing with these cell actions:

Action	Windows Shortcut	Mac Shortcut
Edit active cell	`F2`	`Ctrl` + `U`
Fill down from cell above	`Ctrl` + `D`	`Cmd` + `D`
Fill right from cell to left	`Ctrl` + `R`	`Cmd` + `R`
Fill selected range with active cell entry	`Ctrl` + `Enter`	`Cmd` + `Return`
Insert current system date	`Ctrl` + `;`	`Cmd` + `;`
Insert current system time	`Ctrl` + `Shift` + `:`	`Cmd` + `Shift` + `:`

4. Formulas and Calculations

Formulas become much faster to construct when you don't have to manually type dollar signs $A$1 or click the AutoSum button on the ribbon.

Action	Windows Shortcut	Mac Shortcut
AutoSum adjacent cells	`Alt` + `=`	`Cmd` + `Shift` + `T`
Toggle relative / absolute reference (`A1` → `$A$1`)	`F4`	`Cmd` + `T`
Toggle show formulas vs values	`Ctrl` + `	`Ctrl` + `
Repeat last action / formatting	`F4` or `Ctrl` + `Y`	`Cmd` + `Y`

5. Instant Number Formatting

Instead of navigating the ribbon dropdown menus, apply common number formats instantly:

Format	Windows Shortcut	Mac Shortcut
Format Cells Dialog	`Ctrl` + `1`	`Cmd` + `1`
Currency Format (`$1,234.56`)	`Ctrl` + `Shift` + `$`	`Ctrl` + `Shift` + `$`
Percentage Format (`50%`)	`Ctrl` + `Shift` + `%`	`Ctrl` + `Shift` + `%`
General Number Format (`1,234.56`)	`Ctrl` + `Shift` + `!`	`Ctrl` + `Shift` + `!`
Date Format (`DD-MMM-YY`)	`Ctrl` + `Shift` + `#`	`Ctrl` + `Shift` + `#`

Quick Reference Master Table

Category	Action	Windows Shortcut	Mac Shortcut
Navigation	Jump to Edge	`Ctrl` + `Arrow`	`Cmd` + `Arrow`
Selection	Select Table	`Ctrl` + `A`	`Cmd` + `A`
Rows/Cols	Insert Row/Col	`Ctrl` + `+`	`Cmd` + `+`
Rows/Cols	Delete Row/Col	`Ctrl` + `-`	`Cmd` + `-`
Editing	Edit Active Cell	`F2`	`Ctrl` + `U`
Editing	Fill Down	`Ctrl` + `D`	`Cmd` + `D`
Formulas	AutoSum	`Alt` + `=`	`Cmd` + `Shift` + `T`
Formulas	Toggle `$A$1`	`F4`	`Cmd` + `T`
Formatting	Format Cells	`Ctrl` + `1`	`Cmd` + `1`
Formatting	Currency Format	`Ctrl` + `Shift` + `$`	`Ctrl` + `Shift` + `$`

Next Steps

Don't try to memorize all of these at once. Pick 2 or 3 shortcuts (like Ctrl + D and Alt + =), use them for a day until they become muscle memory, and then add a few more to your daily routine.