Essential Excel Keyboard Shortcuts

Tap a shortcut to see what it does.

Alt + =

Runs AutoSum, automatically calculating the total of the selected range.

Ctrl + D

Copies the content of the cell directly above into all the selected cells below it.

Ctrl + A

Selects the entire range of data, or the whole worksheet, depending on where your cursor is.

Ctrl + +

Inserts a new row or column at the selected location.

Ctrl + -

Deletes the selected row or column.

Ctrl + 1

Opens the Format Cells dialog, where you can adjust font, number formatting, borders, and more.

Alt + W, F

Runs Freeze Panes (View tab β†’ Freeze Panes) so a specific row or column stays visible while you scroll through the rest of the sheet.

Ctrl + Arrow Keys

Jumps straight to the last cell that contains data in the direction of the arrow key you press.

Shift + F11

Adds a new worksheet to the current workbook.

Letting go of the mouse changes how fast you work

If you do a lot of repetitive work in Excel, learning even a handful of shortcuts can cut your working time noticeably. AutoSum and Freeze Panes especially come up constantly in everyday spreadsheet work, so they're worth memorizing first.

Curious about Excel functions too?

If you also want to get comfortable with functions like VLOOKUP, the full guide to Excel formulas is worth checking out next.

Frequently Asked Questions

Do these same shortcuts work in Google Sheets?

Most of them work the same way, but a few are mapped differently, so it's worth double-checking the shortcuts you use most often in Google Sheets specifically.

Are the shortcuts different on Mac?

The main difference is that Cmd is used in place of Ctrl for most of these β€” the rest of the key combinations work almost identically to Windows.