Google Spreadsheet Keyboard Shortcuts

Question 1

What are the Google spreadsheet keystrokes to:

Cancel the cell entry

Answer 1

Esc (Mac and PC)

Question 2

What are the Google spreadsheet keystrokes to:

Place the cursor inside a highlighted cell’s contents

Answer 2

Enter (Mac)

F2 (PC)

Question 3

What are the Google spreadsheet keystrokes to:

Select an entire row

Answer 3

Shift + Space (Mac and PC)

Question 4

What are the Google spreadsheet keystrokes to:

Select an entire column

Answer 4

Cmd + Spacebar (Mac)

Ctrl + Spacebar (PC)

Question 5

What are the Google spreadsheet keystrokes to:

Replace an entire selected 1-column range with the value from the top entry

Answer 5

Command + D (Mac)

Control + D (PC)

Question 6

What are the Google spreadsheet keystrokes to:

Skip the cursor to the last contiguous entry in a row/column

Answer 6

Cmd + arrow keys (Mac)

Ctrl + arrow keys (PC)

Question 7

What are the Google spreadsheet keystrokes to:

Start a new line in the same cell

Answer 7

Alt + Enter (Mac and PC)

Question 8

What are the Google spreadsheet keystrokes to:

Select multiple cells

Answer 8

Shift + arrow keys (Mac and PC)

Question 9

What are the Google spreadsheet keystrokes to:

Move to the end of a row

Answer 9

Fn + right arrow (Mac)

End (PC)

Question 10

What are the Google spreadsheet keystrokes to:

Move to the beginning of a row

Answer 10

Fn + left arrow (Mac)

Home (PC)

Question 11

What are the Google spreadsheet keystrokes to:

Complete a cell entry and select the cell below

Answer 11

Enter (Mac and PC)

Question 12

What are the Google spreadsheet keystrokes to:

Complete a cell entry and select the previous cell above

Answer 12

Shift + Enter (Mac and PC)

Question 13

What are the Google spreadsheet keystrokes to:

Complete a cell entry and select the next cell to the right

Answer 13

Tab (Mac and PC)

Question 14

What are the Google spreadsheet keystrokes to:

Complete a cell entry and select the previous cell to the left

Answer 14

Shift + Tab (Mac and PC)

Question 15

What are the Google spreadsheet keystrokes to:

Insert a line break in a cell

Answer 15

Command + Enter (Mac)

Control + Enter (PC)

Question 16

What are the Google spreadsheet keystrokes to:

Open keyboard shortcuts help

Answer 16

Command + / (Mac)

Control + / (PC)

Question 17

What are the Google spreadsheet keystrokes to:

View all formulas

Answer 17

Command + ‘ (Mac)

Control + ‘ (PC)

Question 18

What do these Google spreadsheet keystrokes do?

Esc (Mac and PC)

Answer 18

Cancel the cell entry

Question 19

What do these Google spreadsheet keystrokes do?

Enter (Mac)

F2 (PC)

Answer 19

Place the cursor inside a highlighted cell’s contents

Question 20

What do these Google spreadsheet keystrokes do?

Shift + Space (Mac and PC)

Answer 20

Select an entire row

Question 21

What do these Google spreadsheet keystrokes do?

Cmd + Spacebar (Mac)

Ctrl + Spacebar (PC)

Answer 21

Select an entire column

Question 22

What do these Google spreadsheet keystrokes do?

Command + D (Mac)

Control + D (PC)

Answer 22

Replace an entire selected 1-column range with the value from the top entry

Question 23

What do these Google spreadsheet keystrokes do?

Cmd + arrow keys (Mac)

Ctrl + arrow keys (PC)

Answer 23

Skip the cursor to the last contiguous entry in a row/column

Question 24

What do these Google spreadsheet keystrokes do?

Alt + Enter (Mac and PC)

Answer 24

Start a new line in the same cell

Question 25

# What do these Google spreadsheet keystrokes do? Shift + arrow keys (Mac and PC)

Answer 25

Select multiple cells

Question 26

# What do these Google spreadsheet keystrokes do? Fn + right arrow (Mac) End (PC)

Answer 26

Move to the end of a row

Question 27

# What do these Google spreadsheet keystrokes do? Fn + left arrow (Mac) Home (PC)

Answer 27

Move to the beginning of a row

Question 28

# What do these Google spreadsheet keystrokes do? Enter (Mac and PC)

Answer 28

Complete a cell entry and select the cell below

Question 29

# What do these Google spreadsheet keystrokes do? Shift + Enter (Mac and PC)

Answer 29

Complete a cell entry and select the previous cell above

Question 30

# What do these Google spreadsheet keystrokes do? Tab (Mac and PC)

Answer 30

Complete a cell entry and select the next cell to the right

Question 31

# What do these Google spreadsheet keystrokes do? Shift + Tab (Mac and PC)

Answer 31

Complete a cell entry and select the previous cell to the left

Question 32

# What do these Google spreadsheet keystrokes do? Command + Enter (Mac) Control + Enter (PC)

Answer 32

Insert a line break in a cell

Question 33

# What do these Google spreadsheet keystrokes do? Command + / (Mac) Control + / (PC)

Answer 33

Open keyboard shortcuts help

Question 34

# What do these Google spreadsheet keystrokes do? Command + ' (Mac) Control + ' (PC)

Answer 34

View all formulas