Shortcut Keys Part 2

Question 1

Insert Table

Answer 1

[Ctrl][T]

Question 2

Open the Quick Analysis Tool

Answer 2

[Ctrl][Q]

Question 3

Enter the current time

Answer 3

[Shift][Ctrl][;}

Question 4

Copy formula from cell above

Answer 4

[Ctrl][’]

Question 5

Fill Down

Answer 5

[Ctrl][D]

Question 6

Fill Right

Answer 6

[Ctrl][R]

Question 7

Flash Fill

Answer 7

[Ctrl][E]

Question 8

Find

Answer 8

[Ctrl][F]

Question 9

Replace

Answer 9

[Ctrl][H]

Question 10

Delete the selected Cells / Rows / Columns

Answer 10

[Ctrl][-]

Question 11

New workbook

Answer 11

[Ctrl][N]

Question 12

Hide columns

Answer 12

[Ctrl][0]

Question 13

Hide rows

Answer 13

[Ctrl][9]

Question 14

Show and Hide objects

Answer 14

[Ctrl][6]

Question 15

Apply comma format

Answer 15

Alt, H, K

Question 16

Select all

Answer 16

[Ctrl][A]

Question 17

Open Name Manager

Answer 17

[Ctrl][F3]

Question 18

Insert new worksheet

Answer 18

[Shift][F11]

Question 19

Switches between worksheet tabs, from left-to-right

Answer 19

[Ctrl][Page Down]

Question 20

Switches between worksheet tabs, from right-to-left

Answer 20

[Ctrl][Page Up]

Question 21

Moves between open windows

Answer 21

[Alt][Esc]

Question 22

Switch between application

Answer 22

[Alt][Tab]

Question 23

Switch between workbooks

Answer 23

[Ctrl][Tab]

Question 24

Tab to next Cell, tool, tab stop or object

Answer 24

[Tab]

Question 25

Tab to previous Cell, tool, tab stop or object

Answer 25

[Shift][Tab]

Question 26

Enter and move up

Answer 26

[Shift][Enter]

Question 27

Jumps one page down

Answer 27

[Pg Dn]

Question 28

Jumps one page up

Answer 28

[Pg Up]

Question 29

Move down one cell

Answer 29

[Down]

Question 30

move left one cell / Move one character to the left

Answer 30

[Left]

Question 31

move right one cell / moves one character to right

Answer 31

[Right]

Question 32

Move to the next worksheet in the workbook

Answer 32

[Ctrl][Pg Dn]

Question 33

Move to the previous worksheet in the workbook

Answer 33

[Ctrl][Pg Up]

Question 34

Moves left to the next blank cell

Answer 34

[Shift][Ctrl][F4]

Question 35

Moves one screen to the left in a worksheet

Answer 35

[Alt][Pg Up]

Question 36

Moves one screen to the right in a worksheet.

Answer 36

[Alt][Pg Dn]

Question 37

moves right to the next blank cell

Answer 37

[Shift][F4]

Question 38

Moves to the bottom of the active area

Answer 38

[Ctrl][End]

Question 39

Moves to the bottom of the region or next region

Answer 39

[Ctrl][Down]

Question 40

Moves to the front of the row

Answer 40

[Home]

Question 41

Moves to the left of the region or next region

Answer 41

[Ctrl][Left]

Question 42

Moves to the right of the region or next region

Answer 42

[Ctrl][Right]

Question 43

Moves to the top of the current region or next region

Answer 43

[Ctrl][Up]

Question 44

Moves to the top of the spreadsheet

Answer 44

[Ctrl][Home]

Question 45

Puts excel in end mode (same as ctr arrow)

Answer 45

[End]

Question 46

Hide ribbons

Answer 46

[Ctrl][F1]

Question 47

Open a Menu or list

Answer 47

[Alt][Down]

Question 48

Select the menu bar

Answer 48

[F10]

Question 49

Add to selection

Answer 49

[Shift][F8]

Question 50

Extended Selection Mode

Answer 50

[F8]

Question 51

Select cells to the next page

Answer 51

[Shift][Pg Dn]

Question 52

Select cells to the previous page

Answer 52

[Shift][Pg Up]

Question 53

Select cells while moving down

Answer 53

[Shift][Down]

Question 54

Select cells while moving left

Answer 54

[Shift][Left]

Question 55

Select cells while moving right

Answer 55

[Shift][Right]

Question 56

Select cells while moving up

Answer 56

[Shift][Up]

Question 57

Select in end mode

Answer 57

[Shift][End]

Question 58

Select the active column

Answer 58

[Shift][Space]

Question 59

Select the cells to the beginning of the row

Answer 59

[Shift][Home]

Question 60

Select the current and next sheet in a workbook.

Answer 60

[Shift][Ctrl][Pg Dn]

Question 61

Select the current and previous sheet in a workbook.

Answer 61

[Shift][Crtl][Pg Up]

Question 62

Select the current column

Answer 62

[Ctrl][Space]

Question 63

Select the current region

Answer 63

[Shift][Ctrl][8]

Question 64

Select to the bottom of the region or next region

Answer 64

[Shift][Ctrl][Down]

Question 65

Select to the left of the region or next region

Answer 65

[Shift][Ctrl][Left]

Question 66

Select to the right of the region or next region

Answer 66

[Shift][Ctrl][Right]

Question 67

Select to the top of the current region or next region

Answer 67

[Shift][Ctrl][Up]

Question 68

Expands and collapse the formula bar

Answer 68

[Shift][Ctrl][U]

Question 69

Hide ribbons, tabs and status bar

Answer 69

[Shift][Ctrl][F1]

Question 70

Opens the selection pane

Answer 70

[Alt][F10]

Question 71

Previous pane or Area

Answer 71

[Shift][F6]

Question 72

Open Thesaurus

Answer 72

[Shift][F7]

Question 73

Spell Check

Answer 73

[F7]

Question 74

Minimize / Maximize Window

Answer 74

[Ctrl][F10]

Question 75

Minimize workbook

Answer 75

[Ctrl][F9]

Question 76

Next Workbook Window

Answer 76

[Ctrl][F6]