Google Spreadsheet Keyboard Shortcuts Flashcards

Learn the most useful Google spreadsheet keyboard shortcuts and increase your productivity.

1
Q

What are the Google spreadsheet keystrokes to:

Cancel the cell entry

A

Esc (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the Google spreadsheet keystrokes to:

Place the cursor inside a highlighted cell’s contents

A

Enter (Mac)

F2 (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the Google spreadsheet keystrokes to:

Select an entire row

A

Shift + Space (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the Google spreadsheet keystrokes to:

Select an entire column

A

Cmd + Spacebar (Mac)

Ctrl + Spacebar (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the Google spreadsheet keystrokes to:

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

A

Command + D (Mac)

Control + D (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the Google spreadsheet keystrokes to:

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

A

Cmd + arrow keys (Mac)

Ctrl + arrow keys (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the Google spreadsheet keystrokes to:

Start a new line in the same cell

A

Alt + Enter (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the Google spreadsheet keystrokes to:

Select multiple cells

A

Shift + arrow keys (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the Google spreadsheet keystrokes to:

Move to the end of a row

A

Fn + right arrow (Mac)

End (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the Google spreadsheet keystrokes to:

Move to the beginning of a row

A

Fn + left arrow (Mac)

Home (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the Google spreadsheet keystrokes to:

Complete a cell entry and select the cell below

A

Enter (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the Google spreadsheet keystrokes to:

Complete a cell entry and select the previous cell above

A

Shift + Enter (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are the Google spreadsheet keystrokes to:

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

A

Tab (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are the Google spreadsheet keystrokes to:

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

A

Shift + Tab (Mac and PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the Google spreadsheet keystrokes to:

Insert a line break in a cell

A

Command + Enter (Mac)

Control + Enter (PC)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are the Google spreadsheet keystrokes to:

Open keyboard shortcuts help

A

Command + / (Mac)

Control + / (PC)

17
Q

What are the Google spreadsheet keystrokes to:

View all formulas

A

Command + ‘ (Mac)

Control + ‘ (PC)

18
Q

What do these Google spreadsheet keystrokes do?

Esc (Mac and PC)

A

Cancel the cell entry

19
Q

What do these Google spreadsheet keystrokes do?

Enter (Mac)

F2 (PC)

A

Place the cursor inside a highlighted cell’s contents

20
Q

What do these Google spreadsheet keystrokes do?

Shift + Space (Mac and PC)

A

Select an entire row

21
Q

What do these Google spreadsheet keystrokes do?

Cmd + Spacebar (Mac)

Ctrl + Spacebar (PC)

A

Select an entire column

22
Q

What do these Google spreadsheet keystrokes do?

Command + D (Mac)

Control + D (PC)

A

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

23
Q

What do these Google spreadsheet keystrokes do?

Cmd + arrow keys (Mac)

Ctrl + arrow keys (PC)

A

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

24
Q

What do these Google spreadsheet keystrokes do?

Alt + Enter (Mac and PC)

A

Start a new line in the same cell

25
Q

What do these Google spreadsheet keystrokes do?

Shift + arrow keys (Mac and PC)

A

Select multiple cells

26
Q

What do these Google spreadsheet keystrokes do?

Fn + right arrow (Mac)

End (PC)

A

Move to the end of a row

27
Q

What do these Google spreadsheet keystrokes do?

Fn + left arrow (Mac)

Home (PC)

A

Move to the beginning of a row

28
Q

What do these Google spreadsheet keystrokes do?

Enter (Mac and PC)

A

Complete a cell entry and select the cell below

29
Q

What do these Google spreadsheet keystrokes do?

Shift + Enter (Mac and PC)

A

Complete a cell entry and select the previous cell above

30
Q

What do these Google spreadsheet keystrokes do?

Tab (Mac and PC)

A

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

31
Q

What do these Google spreadsheet keystrokes do?

Shift + Tab (Mac and PC)

A

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

32
Q

What do these Google spreadsheet keystrokes do?

Command + Enter (Mac)

Control + Enter (PC)

A

Insert a line break in a cell

33
Q

What do these Google spreadsheet keystrokes do?

Command + / (Mac)

Control + / (PC)

A

Open keyboard shortcuts help

34
Q

What do these Google spreadsheet keystrokes do?

Command + ‘ (Mac)

Control + ‘ (PC)

A

View all formulas