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
Q

Bold

CRTL Shortucts

A

CTRL + B

26
Q

Copy

CRTL Shortucts

A

CTRL + C

27
Q

Fill Down

CRTL Shortucts

A

CTRL + D

28
Q

Find

CRTL Shortucts

A

CTRL + F

29
Q

Italic

CRTL Shortucts

A

CTRL + I

30
Q

New Workbook

CRTL Shortucts

A

CTRL + N

31
Q

Open

CRTL Shortucts

A

CTRL + O

32
Q

Print

CRTL Shortucts

A

CTRL + P

33
Q

Fill Right

CRTL Shortucts

A

CTRL + R

34
Q

Save Work Book

CRTL Shortucts

A

CTRL + S

35
Q

Underline

CRTL Shortucts

A

CTRL + U

36
Q

Paste

CRTL Shortucts

A

CTRL + V

37
Q

Close Window

CRTL Shortucts

A

CTRL + W

38
Q

Cut

CRTL Shortucts

A

CTRL + X

39
Q

Undo

CRTL Shortucts

A

CTRL + Z

40
Q

Move

Navigation Shortcuts

A

Arrows

41
Q

Go to End of Continuous Range

Navigation Shortcuts

A

CTRL + Arrows

42
Q

Select A Cell Range

Navigation Shortcuts

A

SHIFT + Arrows

43
Q

Highlight A Continuous Range

Navigation Shortcuts

A

CTRL + SHIFT + Arrows

44
Q

Switch Programs

Navigation Shortcuts

A

ALT + Tab

45
Q

Switch Worksheets

Navigation Shortcuts

A

CTRL + Pg Up/Down

46
Q

Enter Move below

Navigation Shortcuts

A

Enter

47
Q

Move Up

Navigation Shortcuts

A

Shift + Enter

48
Q

Move to Beginning of Line

Navigation Shortcuts

A

Home

49
Q

CTRL + Home Go to Cell A1

Navigation Shortcuts

A

CTRL + Home

50
Q

Cancel

Navigation Shortcuts

A

ESC

51
Q

Add a Line

Navigation Shortcuts

A

Alt + Enter (when in a cell)

52
Q

Hide Row

Columns and Rows Shortcuts

A

CTRL + 9

53
Q

Unhide Row

Columns and Rows Shortcuts

A

SHIFT + CTRL + 9

54
Q

Hide Column

Columns and Rows Shortcuts

A

CTRL + 0

55
Q

Unhide Column

Columns and Rows Shortcuts

A

SHIFT + CTRL + 0

56
Q

Highlight Row

Columns and Rows Shortcuts

A

SHIFT + Spacebar

57
Q

Highlight Column

Columns and Rows Shortcuts

A

CTRL + Spacebar

58
Q

Insert Blank Cells

Columns and Rows Shortcuts

A

SHIFT + CTRL + Plus sign

59
Q

Delete Selected Cells

Columns and Rows Shortcuts

A

CTRL + Minus Sign

60
Q

Group Rows/Columns

Columns and Rows Shortcuts

A

SHIFT + ALT + Left Arrow

61
Q

Ungroup Rows/Columns

Columns and Rows Shortcuts

A

CTRL + Spacebar