Formatting
Calculations
Viewing
Navigation
Miscellaneous
100

We would like to display the cell value as a percentage

Alt + H + P

100

We would like to undo what we just did

Ctrl + Z

100

We would like to apply a filter to the highlighted cells

Ctrl + Shift + L


100

We would like to move to the next or previous tab

Ctrl + PgUp (or Ctrl + PgDn)


100

We would like to redo what we just did (typically used to "undo the undo")

Ctrl + Y

200

We would like to remove a decimal place

Alt + H + 9

200

We would like to refresh all calculations in the workbook

F9

200

We would like to freeze all panes

Alt + W + F + F

200

We would like to get to the bottom of a large column of data (without scrolling)

Ctrl + down key

200

We would like to ungroup a section of grouped rows

Alt + A + U + U

300

We would like to wrap text in a cell

Alt + H  +W

300

We would like to put the cell in "Edit" mode in order to change the formula

F2

300

We would like to open up another tab of the same file (typically used to show two different tabs within the same file on different screens)

Alt + W + N

300
We would like to see the cells dependent on the current cell for their calculations

Alt + M + D (trace dependents)

300

We would like to paste only the values from the copied cell

Alt + E + S + V

400

We would like to remove the cell highlight color and make the cell white

Alt + H + H +N


400

We would like to sum the cells directly above the current cell

Alt + =

400

We would like to remove the gridlines

Alt + W + VG

400

We would like to open the file explorer to open another Excel file

Windows button + E


400

We would like to assign a name to a cell

Alt + M + M + D

500

We would like to add a right border to a cell

Alt + H + B + R

500

We would like to make all calculations in the file "Automatic Except for Data Tables"

Alt + M + X + E *OR* Alt + F + T + F

500

We would like to see the sheet in "Page Break Preview" format

Alt + W + I

500

We would like to jump to a named cell/tab

Ctrl + G *OR* F5

500

We would like to remove duplicates from a highlighted set of data

Alt + A + M

M
e
n
u