Navigation
Jump to the last used cell in a worksheet
What is
Ctrl + End
Edit the active cell without using the mouse
What is
F2
Open the Format Cells dialog box.
What is
Ctrl + 1
Automatically sum a column or row of numbers.
What is
Alt + =
Convert a data range into an Excel Table.
What is
Ctrl + T
Select all data from the active cell to the last nonnblank row.
What is
Ctrl + Shift + (arrow down)
Fill a formula down quickly from the cell above.
What is
Ctrl + D
Apply Accounting/Currency format quickly
What is
Ctrl + Shift + $
Toggle absolute and relative references in a formula
What is
F4
Open the filter dropdown menu for a column.
What is
Alt+Down Arrow
Move instantly to cell A1.
What is
Ctrl + Home
Enter the same value into multiple selected cells at once.
Ctrl + Enter
Autofit the width of selected columns.
What is
Alt + H, O, I
Display all formulas in the worksheet.
What is
Ctrl + `
Sort a column from smallest to largest using the keyboard.
What is
Alt + A, S, A
Switch to the next worksheet tab using the keyboard
What is
Ctrl + Page Down
Insert today’s date into a cell using a shortcut.
What is
Ctrl + ;
Apply an outside border to selected cells
What is
Ctrl + Shift &
Copy the formula from the cell above without retyping it.
What is
Ctrl + ' (apostrophe)
Select the entire table including headers using a shortcut
What is
Ctrl+A twice