Excel Shortcuts

Question 1

Add or edit a cell comment

Answer 1

Shift + F2

Question 2

Alignment

Answer 2

Alt + H, A, (L, C, R)

Question 3

Apply currency format with two decimal places

Answer 3

Ctrl + Shift + S

Question 4

Apply general number format

Answer 4

Ctrl + Shift + ~

Question 5

Apply percent format without decimal places

Answer 5

Ctrl + Shift + %

Question 6

Beginning of a worksheet

Answer 6

Ctrl + Home

Question 7

Esc

Answer 7

Cancel current cell entry

Question 8

Choose a fill color

Answer 8

ALT + H, H

Question 9

Redo the last command

Answer 9

Ctrl + Y

Question 10

Context menu

Answer 10

Shift + F10

Question 11

Copy value from above

Answer 11

Ctrl + Shift + “

Question 12

Create a chart of the data

Answer 12

F11

Question 13

Copy formula from above

Answer 13

Ctrl + ‘

Question 14

Data tab

Answer 14

Alt + A

Question 15

Date format

Answer 15

Ctrl + Shift + #

Question 16

Define a name

Answer 16

Alt + M, M, D

Question 17

Delete border

Answer 17

Ctrl + Shift + _

Question 18

Delete cells, row, column, sheet

Answer 18

Alt + H, D, (D, R, C, S)

Question 19

Delete selected cells

Answer 19

Ctrl + Minus

Question 20

Edit active cell at the end of the formula bar

Answer 20

F2

Question 21

Extend or collapse the formula bar

Answer 21

Ctrl + Shift + U

Question 22

Extend Selection

Answer 22

Shift + Arrow Key