Excel Shortcuts Flashcards Preview

PRA HS > Excel Shortcuts > Flashcards

Flashcards in Excel Shortcuts Deck (22):
1

Add or edit a cell comment

Shift + F2

2

Alignment

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

3

Apply currency format with two decimal places

Ctrl + Shift + S

4

Apply general number format

Ctrl + Shift + ~

5

Apply percent format without decimal places

Ctrl + Shift + %

6

Beginning of a worksheet

Ctrl + Home

7

Esc

Cancel current cell entry

8

Choose a fill color

ALT + H, H

9

Redo the last command

Ctrl + Y

10

Context menu

Shift + F10

11

Copy value from above

Ctrl + Shift + "

12

Create a chart of the data

F11

13

Copy formula from above

Ctrl + '

14

Data tab

Alt + A

15

Date format

Ctrl + Shift + #

16

Define a name

Alt + M, M, D

17

Delete border

Ctrl + Shift + _

18

Delete cells, row, column, sheet

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

19

Delete selected cells

Ctrl + Minus

20

Edit active cell at the end of the formula bar

F2

21

Extend or collapse the formula bar

Ctrl + Shift + U

22

Extend Selection

Shift + Arrow Key