Excel Shortcuts

Question 1

Copy

Answer 1

Ctrl + C

Question 2

Paste

Answer 2

Ctrl + V

Question 3

Edit cell content

Answer 3

F2

Question 4

Add line break inside a cell (2 options)

Answer 4

Alt + Enter or Ctrl + J

Question 5

Undo

Answer 5

Ctrl + Z

Question 6

Redo

Answer 6

Ctrl + Y

Question 7

Autosum

Answer 7

Alt =

Question 8

Date stamp

Answer 8

Ctrl + ;

Question 9

Time stamp

Answer 9

Ctrl + shift + ;

Question 10

Open blank workbook

Answer 10

Ctrl + N

Question 11

Move to the next worksheet

Answer 11

Ctrl + page down

Question 12

Move to the previous worksheet

Answer 12

Ctrl + page up

Question 13

Switch between Excel workbooks

Answer 13

Ctrl + Tab

Question 14

Select data in the current region

Answer 14

Ctrl + A

Question 15

Move to first cell in the same row

Answer 15

Home

Question 16

Move to cell A1

Answer 16

Ctrl + Home

Question 17

Open a workbook

Answer 17

Ctrl + O

Question 18

Save a workbook

Answer 18

Ctrl + S

Question 19

Close a workbook

Answer 19

Ctrl + W

Question 20

Insert a new worksheet

Answer 20

Shift + F11

Question 21

Bold

Answer 21

Ctrl + B

Question 22

Bring up format dialog box

Answer 22

Ctrl + 1

Question 23

Repeat last edit

Answer 23

F4

Question 24

Enter data but stay on the same cell

Answer 24

Ctrl + Enter

Question 25

Move to the cell on the right

Answer 25

tab

Question 26

Flash Fill

Answer 26

Ctrl + E

Question 27

Go to special

Answer 27

Ctrl + G

Question 28

Insert a note

Answer 28

Shift + F2

Question 29

Move to the bottom of the data region

Answer 29

Ctrl + down arrow

Question 30

Move to the last used cell on the worksheet

Answer 30

Ctrl + End

Question 31

Insert a new cell/row/column

Answer 31

Ctrl +

Question 32

Delete a cell/row/column

Answer 32

Ctrl -

Question 33

Select the row

Answer 33

Shift + Space

Question 34

Select the column

Answer 34

Ctrl + Space

Question 35

Replace

Answer 35

Ctrl + H

Question 36

Create a link to somewhere

Answer 36

Ctrl + K

Question 37

Insert chart (same worksheet)

Answer 37

Alt + F1

Question 38

Insert chart (new worksheet)

Answer 38

F11

Question 39

Debug formula

Answer 39

F9

Question 40

Filter (toggle)

Answer 40

Ctrl + Shift + L

Question 41

Create a 2nd instance of Excel (from Power Query)

Answer 41

Windows Key, then hold down Alt, Click Excel and then Yes

Question 42

Highlight all columns in Power Query

Answer 42

Ctrl + A

Question 43

What is a quick way to set print titles?

Answer 43

Highlight the rows & columns you want to set as titles, then type “print_titles” in name box (top right)

Question 44

Quick way to move rows or columns

Answer 44

Shift + drag