Hotkeys Flashcards
1
Q
New worksheet
A
Shift+F11
2
Q
New workbook
A
Ctrl+N
3
Q
Close program
A
Alt+F4
4
Q
Copies the top cell down the range (after you highlight the range)
A
Ctrl+D
5
Q
Copies the far left cell across the range (after you highlight the range)
A
Ctrl+R
6
Q
Redo
A
Ctrl+Y
7
Q
Switch workbooks
A
Ctrl+Tab
8
Q
Highlight row
A
Shift+Spacebar
9
Q
Delete selected cells
A
Ctrl+minus sign
10
Q
Switch worksheets
A
Ctrl+PgUp/Pg Down
11
Q
Go to end of continuous range and select a cell
A
Ctrl+Arrow
12
Q
Select continuous range
A
Shift+Ctrl+Arrow
13
Q
Move to beginning of line
A
Home
14
Q
Move to cell A1
A
Ctrl+Home
15
Q
Highlight within cells
A
Shift+Arrow
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
