PC_Excel_Shortcut_Flashcards

Question 1

Question (Action)

Answer 1

Answer (PC Shortcut)

Question 2

Open File

Answer 2

Ctrl + O

Question 3

New File

Answer 3

Ctrl + N

Question 4

Print

Answer 4

Ctrl + P

Question 5

Save File

Answer 5

Ctrl + S

Question 6

Save File As

Answer 6

F12

Question 7

Close File

Answer 7

Ctrl + F4

Question 8

Close Excel

Answer 8

Alt + F4

Question 9

Exit Dialog

Answer 9

Esc

Question 10

Copy

Answer 10

Ctrl + C

Question 11

Cut

Answer 11

Ctrl + X

Question 12

Paste

Answer 12

Ctrl + V

Question 13

Undo

Answer 13

Ctrl + Z

Question 14

Redo

Answer 14

Ctrl + Y

Question 15

Select All

Answer 15

Ctrl + A

Question 16

Find

Answer 16

Ctrl + F

Question 17

Replace

Answer 17

Ctrl + H

Question 18

Switch Windows

Answer 18

Alt + Tab

Question 19

Switch Workbooks

Answer 19

Ctrl + Tab

Question 20

Options Menu

Answer 20

Alt, T, O

Question 21

Repeat Last Action

Answer 21

F4

Question 22

Toggle Ribbon Menu

Answer 22

Ctrl + F1

Question 23

Show Ribbon Shortcuts

Answer 23

Alt

Question 24

Excel Menu Bar

Answer 24

Ctrl + F2

Question 25

Select Column

Answer 25

Ctrl + Spacebar

Question 26

Select Row

Answer 26

Shift + Spacebar

Question 27

Insert Row

Answer 27

Alt, I, R or Ctrl + Shift + +

Question 28

Insert Column

Answer 28

Alt, I, C or Ctrl + Shift + +

Question 29

Delete Cells/Rows/Columns

Answer 29

Alt, E, D or Ctrl + –

Question 30

Auto-Fit Column Width

Answer 30

Alt, O, C, A

Question 31

Change Column Width

Answer 31

Alt, O, C, W

Question 32

Auto-Fit Row Height

Answer 32

Alt, O, R, A

Question 33

Change Row Height

Answer 33

Alt, O, R, E

Question 34

Group Rows/Columns

Answer 34

Shift + Alt + →

Question 35

Ungroup Groupings

Answer 35

Shift + Alt + ←

Question 36

Hide Column(s)

Answer 36

Alt, A, H

Question 37

Show Column(s)

Answer 37

Alt, A, J

Question 38

Hide Row(s)

Answer 38

Alt, A, H

Question 39

Show Row(s)

Answer 39

Alt, A, J

Question 40

New Worksheet

Answer 40

Shift + F11

Question 41

Delete Worksheet

Answer 41

Alt, E, L

Question 42

Move / Copy Sheet

Answer 42

Alt, E, M

Question 43

Select Multiple Sheets

Answer 43

Shift + Mouse Click

Question 44

All Sheet Functions

Answer 44

Alt, H, O

Question 45

Move Between Cells

Answer 45

Arrow Keys

Question 46

Jump to Boundary

Answer 46

Ctrl + Arrow Keys

Question 47

Select Multiple Cells

Answer 47

Shift + Arrow Keys

Question 48

Select to Boundary

Answer 48

Shift + Ctrl + Arrow Keys

Question 49

Jump to Row Beginning

Answer 49

Home

Question 50

Jump to Cell A1

Answer 50

Ctrl + Home

Question 51

Jump to Last Cell

Answer 51

Ctrl + End

Question 52

Move to Right Sheet

Answer 52

Ctrl + PgDn

Question 53

Move to Left Sheet

Answer 53

Ctrl + PgUp

Question 54

Scroll Up and Down

Answer 54

Mouse Scroll Wheel

Question 55

Zoom In / Out

Answer 55

Ctrl + Mouse Scroll Wheel

Question 56

Set Manual Zoom

Answer 56

Alt, V, Z

Question 57

Format Dialog Box

Answer 57

Ctrl + 1

Question 58

Paste Special

Answer 58

Alt, E, S

Question 59

Paste Formats

Answer 59

Alt, E, S, T

Question 60

Paste Values

Answer 60

Alt, E, S, V

Question 61

Paste Formulas

Answer 61

Alt, E, S, F

Question 62

Paste Links

Answer 62

Alt, E, S, L

Question 63

Fill Down from Cell

Answer 63

Ctrl + D

Question 64

Fill Right from Cell

Answer 64

Ctrl + R

Question 65

Clear Data & Formulas

Answer 65

Del

Question 66

Clear Data, Formulas, and Formatting

Answer 66

Alt, H, E, A

Question 67

Format Painter

Answer 67

Alt, H, FP

Question 68

Font Color

Answer 68

Alt, 1

Question 69

Accounting Format

Answer 69

Alt, 2

Question 70

Increase Decimals

Answer 70

Alt, 3

Question 71

Decrease Decimals

Answer 71

Alt, 4

Question 72

Center / Uncenter

Answer 72

Alt, 5

Question 73

Fill Color

Answer 73

Alt, 6

Question 74

Borders Menu

Answer 74

Alt, 7

Question 75

Font Size

Answer 75

Alt, 8

Question 76

Increase Indent

Answer 76

Alt, H, 6

Question 77

Decrease Indent

Answer 77

Alt, H, 5

Question 78

Bold

Answer 78

Ctrl + B

Question 79

Italics

Answer 79

Ctrl + I

Question 80

Underline

Answer 80

Ctrl + U

Question 81

Strikethrough

Answer 81

Ctrl + 5

Question 82

Add Borders

Answer 82

Ctrl + Shift + &

Question 83

Remove Borders

Answer 83

Ctrl + Shift + –

Question 84

General Format

Answer 84

Shift + Ctrl + ~

Question 85

Number Format

Answer 85

Shift + Ctrl + !

Question 86

Time Format

Answer 86

Shift + Ctrl + @

Question 87

Date Format

Answer 87

Shift + Ctrl + #

Question 88

Currency Format

Answer 88

Shift + Ctrl + $

Question 89

Percentage Format

Answer 89

Shift + Ctrl + %

Question 90

Scientific Format

Answer 90

Shift + Ctrl + ^