Excel Shortcuts

Question 1

Copy

Answer 1

Ctrl+C

Question 2

Paste

Answer 2

Ctrl+V

Question 3

Undo

Answer 3

Ctrl+Z

Question 4

Redo

Answer 4

Ctrl+Y

Question 5

Open

Answer 5

Ctrl+O

Question 6

New

Answer 6

Ctrl+N

Question 7

Print

Answer 7

Ctrl+P

Question 8

Save

Answer 8

Ctrl+S

Question 9

Save As

Answer 9

F12

Question 10

Go to next workbook

Answer 10

Ctrl + Tab

Question 11

Close File

Answer 11

Ctrl+F4

Question 12

Show ribbon accelerator keys

Answer 12

Alt

Question 13

Show/hide ribbon

Answer 13

Ctrl+F1

Question 14

Move from cell to cell

Answer 14

Arrows

Question 15

Go to end of contiguous range

Answer 15

Ctrl+Arrows

Question 16

Move one screen up

Answer 16

PgUp

Question 17

Move one screen down

Answer 17

PgDn

Question 18

Move on screen left

Answer 18

Alt+PgUp

Question 19

Move one screen right

Answer 19

Alt+PgDn

Question 20

Go to cell A1

Answer 20

Ctrl+Home

Question 21

Go to beginning of row

Answer 21

Home

Question 22

Go to last cell in a worksheet

Answer 22

Ctrl+End

Question 23

Open the Go To dialog box

Answer 23

F5

Question 24

Open format cells dialog

Answer 24

Ctrl+1

Question 25

Bold

Answer 25

Ctrl+B

Question 26

Italic

Answer 26

Ctrl+I

Question 27

Underline

Answer 27

Ctrl+U

Question 28

Number Format

Answer 28

Ctrl+Up+!

Question 29

Percent Format

Answer 29

Ctrl+Up+%

Question 30

Date Format

Answer 30

Ctrl+Up+#

Question 31

Increase Font Size

Answer 31

Alt H FG

Question 32

Decrease Font Size

Answer 32

Alt H FK

Question 33

Insert/edit comment

Answer 33

up + F2

Question 34

Increase decimal

Answer 34

Alt H 0

Question 35

Decrease decimal

Answer 35

Alt H 9

Question 36

Increase indent

Answer 36

Alt H 6

Question 37

decrease indent

Answer 37

Alt H 5

Question 38

Clear cell data

Answer 38

delete

Question 39

Clear cell formats

Answer 39

Alt H E F

Question 40

Clear Cell comments

Answer 40

Alt H E M

Question 41

Clear All

Answer 41

Alt H E A

Question 42

Outline Border

Answer 42

Ctrl+Up+&

Question 43

Remove Border

Answer 43

Ctrl+Up+-

Question 44

Left Border

Answer 44

ALT H B L

Question 45

Right Border

Answer 45

Alt H B R

Question 46

Top Border

Answer 46

Alt H B T

Question 47

Bottom Border

Answer 47

Alt H B O

Question 48

Paste special formats

Answer 48

Ctrl+Alt+ V T

Question 49

Paste special values

Answer 49

Ctrl+Alt+ V V

Question 50

Paste special formulas

Answer 50

Ctrl+Alt+ V F

Question 51

Paste Special Comments

Answer 51

Ctrl+Alt+ V C

Question 52

Select a cell range

Answer 52

Up+ Arrows

Question 53

Highlight a contiguous range

Answer 53

Ctrl+Up+ Arrows

Question 54

Extend selection up a screen

Answer 54

PgUp

Question 55

Extend selection down a screen

Answer 55

PgDn

Question 56

Extend selection left a screen

Answer 56

Alt+Up+PgUp

Question 57

Extend a selection right a screen

Answer 57

Alt+Up+PgDn

Question 58

Select All

Answer 58

Ctrl+A

Question 59

Fill down from cell above

Answer 59

Ctrl+D

Question 60

Fill right from cell left

Answer 60

Ctrl+R

Question 61

Find and replace

Answer 61

Ctrl+F

Question 62

Show all constants

Answer 62

F5 Alt+S O

Question 63

Highlight cells with comments

Answer 63

F5 Alt S C

Question 64

Edit the active cell

Answer 64

F2

Question 65

While editing cell, allow use of arrow keys to create reference

Answer 65

F2

Question 66

Confirm change and leave cell

Answer 66

Enter

Question 67

Cancel cell entry and leave cell

Answer 67

Esc

Question 68

Insert line break within cell

Answer 68

Alt+Enter

Question 69

Highlight within a cell

Answer 69

Up+ arrow

Question 70

Highlight contiguous items

Answer 70

Ctr+Up+arrow

Question 71

Jump to beginning of cell

Answer 71

home

Question 72

jump to end of cell

Answer 72

end

Question 73

delete character to left

Answer 73

backspace

Question 74

delete character to right

Answer 74

delete

Question 75

accept AutoComplete suggestion

Answer 75

tab

Question 76

Reference a cell from another worksheet

Answer 76

ctrl+PgUpArrows

Question 77

Start a formula

Answer 77

=

Question 78

Insert autosum formula

Answer 78

Alt+=

Question 79

Recalculate all worksheets

Answer 79

F9

Question 80

Anchor cells

Answer 80

F4

Question 81

Open Insert Formula dialog

Answer 81

Up+F3

Question 82

Eneter array formula

Answer 82

Up+Ctrl+Enter

Question 83

Inspect cell values

Answer 83

F9

Question 84

Switch to formula view

Answer 84

Ctrl+~

Question 85

Select direct precedents

Answer 85

Ctrl+[

Question 86

select direct dependents

Answer 86

Ctrl+]

Question 87

Trace immediate precedents

Answer 87

Alt M P

Question 88

Trade immediate precedents

Answer 88

Alt M D

Question 89

Remove tracing arrows

Answer 89

Alt M A A

Question 90

Go to last cell

Answer 90

F5+Enter

Question 91

Calculate all open workbooks

Answer 91

F9

Question 92

Open Excel options dialog box

Answer 92

ALT F O

Question 93

Accessing data validation

Answer 93

Alt A V V

Question 94

Get inside a drop-down list

Answer 94

Alt Up or Down

Question 95

Insert data table

Answer 95

Alt A W T

Question 96

Open sort dialog

Answer 96

Alt A S S

Question 97

Autofilter selection

Answer 97

Alt A T

Question 98

Insert pivot table

Answer 98

Alt N V

Question 99

Insert a chart

Answer 99

Alt N R

Question 100

Zoom

Answer 100

Alt W Q

Question 101

Name a cell or cell range

Answer 101

Ctrl + F3

Question 102

Select a column

Answer 102

Ctrl+Space

Question 103

Select row

Answer 103

Up+Space

Question 104

Delete rows/columns

Answer 104

Ctrl+ -

Question 105

Add rows/columns

Answer 105

Ctrl+Up++

Question 106

Set column width

Answer 106

Alt H O W

Question 107

Autofit column width

Answer 107

Alt H O I

Question 108

Fit to specific row height

Answer 108

ALT H O H

Question 109

Group rows/columns

Answer 109

Alt + Up + right arrow

Question 110

Ungroup rows/columns

Answer 110

Alt + Up + left arrow

Question 111

Jump to next worksheet

Answer 111

Ctrl+PgDn

Question 112

Jump to previous worksheet

Answer 112

Ctrl+PgUp

Question 113

Change worksheet name

Answer 113

ALT H O R

Question 114

Rearrange tab order

Answer 114

Alt H O M

Question 115

Freeze pane

Answer 115

Alt W F F

Question 116

Split screen

Answer 116

Alt W S

Question 117

Toggle from tab, ribbon, task pane, status bar

Answer 117

F6

Question 118

Close help

Answer 118

Ctrl+Space+C

Question 119

Move to next control

Answer 119

Tab

Question 120

Move from tab to tab

Answer 120

Ctrl+Tab

Question 121

Move to previous contorl

Answer 121

Up+Tab

Question 122

Move within a list

Answer 122

Arrows

Question 123

Activate control

Answer 123

Alt+Underlined Ltr

Question 124

Toggle checkboxes

Answer 124

Spacebar

Question 125

Close a dialog

Answer 125

Esc

Question 126

Apply change

Answer 126

Enter