Excel Shortcut Keys

Navigation

100

Jump to the last used cell in a worksheet

What is 

Ctrl + End

200

Select all data from the active cell to the last nonnblank row.

What is 

Ctrl + Shift + (arrow down)

300

Move instantly to cell A1.

What is

Ctrl + Home

400

Switch to the next worksheet tab using the keyboard

What is

Ctrl + Page Down

Editing & Fill

100

Edit the active cell without using the mouse

What is

F2

200

Fill a formula down quickly from the cell above.

What is

Ctrl + D

300

Enter the same value into multiple selected cells at once.

Ctrl + Enter

400

Insert today’s date into a cell using a shortcut.

What is

Ctrl + ;

Formatting

100

Open the Format Cells dialog box.

What is

Ctrl + 1

200

Apply Accounting/Currency format quickly

What is

Ctrl + Shift + $

300

Autofit the width of selected columns.

What is

Alt + H, O, I

400

Apply an outside border to selected cells

What is

Ctrl + Shift &

Formulas

100

Automatically sum a column or row of numbers.

What is

Alt + =

200

Toggle absolute and relative references in a formula

What is 

F4

300

Display all formulas in the worksheet.

What is

Ctrl + `

400

Copy the formula from the cell above without retyping it.

What is

Ctrl + ' (apostrophe)

Tables & Filters

100

Convert a data range into an Excel Table.

What is

Ctrl + T

200

Open the filter dropdown menu for a column.

What is

Alt+Down Arrow

300

Sort a column from smallest to largest using the keyboard.

What is

Alt + A, S, A

400

Select the entire table including headers using a shortcut

What is

Ctrl+A twice