MS Excel Keyboard Flashcards

1
Q

Format Box

Formatting Shortcuts

A

CTRL + 1

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

Copy Format

Formatting Shortcuts

A

ALT + E + S + T

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

Increase Decimal

Formatting Shortcuts

A

ALT + H + 0

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

Copy Format

Formatting Shortcuts

A

ALT + E + S + T

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

Decrease Decimal

Formatting Shortcuts

A

ALT + H + 9

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

Boxing

Formatting Shortcuts

A

CTRL + SHIFT + 7

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

Fit Column Width

Formatting Shortcuts

A

ALT + O + C + A

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

Change Tab Name

Formatting Shortcuts

A

ALT + H + O + R

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

(Un)Split Panes

Formatting Shortcuts

A

ALT + W + F

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

(Un)freeze windows

Formatting Shortcuts

A

ALT + W + S

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

Date Format

Formatting Shortcuts

A

SHIFT + CTRL + #

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

Dollar Format

Formatting Shortcuts

A

SHIFT + CTRL + $

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

Percentage Format

Formatting Shortcuts

A

SHIFT + CTRL + %

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

Sum Function

Formatting Shortcuts

A

ALT + “=”

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

Edit Cells

Function Key Shortcuts

A

F2

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

Anchor Cells

Function Key Shortcuts

A

F4

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

Spell Check

Function Key Shortcuts

A

F7

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

Save As

Function Key Shortcuts

A

F12

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

Insert a Comment

Function Key Shortcuts

A

SHIFT + F2

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

Add to Selection

Function Key Shortcuts

A

SHIFT + F8

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

Right Click

Function Key Shortcuts

A

SHIFT + F10

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

Name a Cell

Function Key Shortcuts

A

CTRL + F3

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

Minimize Programs

Function Key Shortcuts

A

Windows Flag + D

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

Select All

CRTL Shortucts

A

CTRL + A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Bold ## Footnote CRTL Shortucts
CTRL + B
26
Copy ## Footnote CRTL Shortucts
CTRL + C
27
Fill Down ## Footnote CRTL Shortucts
CTRL + D
28
Find ## Footnote CRTL Shortucts
CTRL + F
29
Italic ## Footnote CRTL Shortucts
CTRL + I
30
New Workbook ## Footnote CRTL Shortucts
CTRL + N
31
Open ## Footnote CRTL Shortucts
CTRL + O
32
Print ## Footnote CRTL Shortucts
CTRL + P
33
Fill Right ## Footnote CRTL Shortucts
CTRL + R
34
Save Work Book ## Footnote CRTL Shortucts
CTRL + S
35
Underline ## Footnote CRTL Shortucts
CTRL + U
36
Paste ## Footnote CRTL Shortucts
CTRL + V
37
Close Window ## Footnote CRTL Shortucts
CTRL + W
38
Cut ## Footnote CRTL Shortucts
CTRL + X
39
Undo ## Footnote CRTL Shortucts
CTRL + Z
40
Move ## Footnote Navigation Shortcuts
Arrows
41
Go to End of Continuous Range ## Footnote Navigation Shortcuts
CTRL + Arrows
42
Select A Cell Range ## Footnote Navigation Shortcuts
SHIFT + Arrows
43
Highlight A Continuous Range ## Footnote Navigation Shortcuts
CTRL + SHIFT + Arrows
44
Switch Programs ## Footnote Navigation Shortcuts
ALT + Tab
45
Switch Worksheets ## Footnote Navigation Shortcuts
CTRL + Pg Up/Down
46
Enter Move below ## Footnote Navigation Shortcuts
Enter
47
Move Up ## Footnote Navigation Shortcuts
Shift + Enter
48
Move to Beginning of Line ## Footnote Navigation Shortcuts
Home
49
CTRL + Home Go to Cell A1 ## Footnote Navigation Shortcuts
CTRL + Home
50
Cancel ## Footnote Navigation Shortcuts
ESC
51
Add a Line ## Footnote Navigation Shortcuts
Alt + Enter (when in a cell)
52
Hide Row ## Footnote Columns and Rows Shortcuts
CTRL + 9
53
Unhide Row ## Footnote Columns and Rows Shortcuts
SHIFT + CTRL + 9
54
Hide Column ## Footnote Columns and Rows Shortcuts
CTRL + 0
55
Unhide Column ## Footnote Columns and Rows Shortcuts
SHIFT + CTRL + 0
56
Highlight Row ## Footnote Columns and Rows Shortcuts
SHIFT + Spacebar
57
Highlight Column ## Footnote Columns and Rows Shortcuts
CTRL + Spacebar
58
Insert Blank Cells ## Footnote Columns and Rows Shortcuts
SHIFT + CTRL + Plus sign
59
Delete Selected Cells ## Footnote Columns and Rows Shortcuts
CTRL + Minus Sign
60
Group Rows/Columns ## Footnote Columns and Rows Shortcuts
SHIFT + ALT + Left Arrow
61
Ungroup Rows/Columns ## Footnote Columns and Rows Shortcuts
CTRL + Spacebar