Excel Frequently Used Shortcuts Flashcards
(36 cards)
1
Q
Close A Spreadsheet
A
CTRL+W
2
Q
Open A Spreadsheet
A
CTRL+O
3
Q
Go To The Home Tab
A
ALT+H
4
Q
Save A Spreadsheet
A
CTRL+S
5
Q
Copy
A
CTRL+C
6
Q
Paste
A
CTRL+V
7
Q
Undo
A
CNTRL+Z
8
Q
Remove Cell Contents
A
Delete Key
9
Q
Choose A Fill Color
A
ALT+H,H
10
Q
Cut
A
CTRL+X
11
Q
Go To Insert Tab
A
ALT+N
12
Q
Bold
A
CTRL+B
13
Q
Center Align Cells Contents
A
ALT+H,A, then C
14
Q
Go To Page Layout Tab
A
ALT+P
15
Q
Go To Data Tab
A
ALT+A
16
Q
Go To View Tab
A
ALT+W
17
Q
Open Context Menu
A
Shift+F10 or Context Key
18
Q
Add Borders
A
ALT+H,B
19
Q
Move to the previous cell in a worksheet or the previous option in a dialog box.
A
Shift+Tab
20
Q
Move one cell up in a worksheet.
A
Up Arrow Key
21
Q
Move one cell down in a worksheet
A
Down Arrow Key
22
Q
Move one cell left in a worksheet.
A
Left Arrow Key
23
Q
Move one cell right in a worksheet.
A
Right Arrow Key
24
Q
Move to the edge of the current data region in a worksheet.
A
CTRL+Arrow Key
25
Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the Cell is blank, move to the last cell in the row or column.
End, arrow key
26
Move to last cell on a worksheet, to the lowest used row of the rightmost used column.
CNTRL+End
27
Extend the selection of cells to the last used cell on the worksheet (lower-right corner).
CTRL+Shift+End
28
Move to cell in upper left corner of the window when Scroll Lock is on.
Home+Scroll Lock
29
Move to the beginning of a worksheet.
CTRL+Home
30
Move one screen down in a worksheet.
Page Down
31
Move to the next sheet in a workbook.
CNTRL+Page Down
32
Move one screen to the right in a worksheet.
ALT+Page Down
33
Move one screen up in a worksheet.
Page Up
34
Move one sheet to the left in a worksheet.
ALT+Page Up
35
Move to the previous sheet in a workbook.
CNTRL+Page Up
36
Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells.
Tab
