EXCEL Keyboard Shortcuts

Question 1

F2

Answer 1

Click this when you have a cell selected. It will go directly into the Formula tab at the top.

Question 2

F4

Answer 2

When in the Formula Tab if a Cell, it will toggle a particular cell reference between absolute and relative referencing (the ‘$’ which fixes the position of a row, column or both.

Question 3

F9

Answer 3

If your worksheet is set on Manual Calculations (mine usually are) then F9 will refresh your Formulas.

Question 4

CTRL Page Down OR Page Up

Answer 4

This will toggle between your different Sheets in a Workbook. So say for example you have 12 worksheets (Jan to Dec), this will help you effortlessly navigate through them.

Question 5

CTRL Arrows

Answer 5

This will select the last cell with values in a range. Say you have a table that has every row filled in (300 rows), then if you start from the first row and hit CTRL Down Arrow, it will jump to the bottom row of the table and select that cell

Question 6

CTRL SHIFT Arrows

Answer 6

Similar to the above, only by adding SHIFT it will select the entire range(so in our previous example, it would select all 300 rows.

Question 7

SHIFT F10

Answer 7

This opens up the right click menu on the particular cell you’re on.

Question 8

CTRL F1

Answer 8

Collapse / bring back the EXCEL ribbon from the top. Sometimes you just need more space to visualize your data.

Question 9

CTRL ‘F’

Answer 9

Brings up the the ‘Find’ Box to look for relevant keywords, Formulas.

Question 10

CTRL ‘H’

Answer 10

Even more important (I use this a lot), it brings up the ‘Find and Replace’ box, which you can use to replace a large number of values or formula variables very quickly.

Question 11

CTRL+W

Answer 11

Close a workbook

Question 12

CTRL+O

Answer 12

Open a workbook

Question 13

ALT+H

Answer 13

Go to the HOME tab and format text and numbers and use the Find tool

Question 14

CTRL+S

Answer 14

Save a workbook

Question 15

CTRL+C

Answer 15

Copy

Question 16

CTRL+V

Answer 16

Paste

Question 17

CTRL+Z

Answer 17

Undo

Question 18

Delete

Answer 18

Remove cell contents

Question 19

ALT+H,H

Answer 19

Choose a fill color

Question 20

CTRL+X

Answer 20

Cut

Question 21

ALT+N

Answer 21

Go to Insert tab and insert Pivot Tables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes

Question 22

CTRL+B

Answer 22

Bold

Question 23

ALT+H,A,C

Answer 23

Center align cell contents

Question 24

ALT+P

Answer 24

Go to Page Layout tab and work with themes, page setup, scale, and alignment

Question 25

ALT+A

Answer 25

Go to Data tab and connect to sort filter, analyze and work with data

Question 26

ALT+W

Answer 26

Go to View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros

Question 27

Shift+F10, or Context key

Answer 27

Open context menu

Question 28

ALT+ H,B

Answer 28

Add borders

Question 29

ALT+H,D,C

Answer 29

Delete column

Question 30

ALT+M

Answer 30

Go to FORMULA tab and insert, trace, and customize functions and calculations.

Question 31

CTRL+9

Answer 31

Hide the selected rows

Question 32

CTRL+0

Answer 32

Hide the selected columns

Question 33

ALT+R

Answer 33

Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbook

Question 34

ALT or F10. To move to a different tab, use access keys or the arrow keys

Answer 34

Select the active tab on the ribbon, and activate the access keys.

Question 35

Tab key or Sift+Tab

Answer 35

Move the focus to commands on the ribbon

Question 36

Arrow keys

Answer 36

Move down, up, left, or right respectively, among the items on the Ribbon

Question 37

Space bar or Enter

Answer 37

Activate a selected button

Question 38

Down arrow key

Answer 38

Open the list for a selected command