Hotkeys Flashcards

1
Q

New worksheet

A

Shift+F11

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

New workbook

A

Ctrl+N

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

Close program

A

Alt+F4

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

Copies the top cell down the range (after you highlight the range)

A

Ctrl+D

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

Copies the far left cell across the range (after you highlight the range)

A

Ctrl+R

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

Redo

A

Ctrl+Y

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

Switch workbooks

A

Ctrl+Tab

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

Highlight row

A

Shift+Spacebar

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

Delete selected cells

A

Ctrl+minus sign

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

Switch worksheets

A

Ctrl+PgUp/Pg Down

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

Go to end of continuous range and select a cell

A

Ctrl+Arrow

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

Select continuous range

A

Shift+Ctrl+Arrow

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

Move to beginning of line

A

Home

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

Move to cell A1

A

Ctrl+Home

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

Highlight within cells

A

Shift+Arrow

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

Change absolute referencing($)

A

F4

17
Q

Sum selected cells

A

Alt+=

18
Q

Recalculate all workwooks

A

F9

19
Q

Highlight precedent cells

A

Ctrl+[

20
Q

Highlight dependent cells

A

Ctrl+]

21
Q

F5

A

至已命名的range

22
Q

Insert Formula

A

Shift+F3