Formatting Flashcards

1
Q

Converts to Excel DEFAULT

Cell Format

A

Ctrl + Shift + `/ ~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Converts to COMMA & TWO DECIMAL Format

A

Ctrl + Shift + 1 / !

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Converts to Date (DD-MMM-YY) Format

A

Ctrl + Shift + 3 / #

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Converts to CURRENCY Format

A

Ctrl + Shift + 4 / $

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Converts to PERCENTAGE Format

A

Ctrl + Shift + 5 / %

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Adds borders around selected range

A

Ctrl + Shift + 7 / &

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Removes borders, outlines from selected range

A

Ctrl + Shift + - / _

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Hide selected Rows

A

Ctrl + 9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Unhide rows (Select rows around hidden rows first)

A

Ctrl + Shift + 9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Hide Columns, Add Shift for un-hiding columns

A

Ctrl + 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Unhide columns (Select columns around hidden columns first)

A

Ctrl + Shift + 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Paste Special, after copying

A

Ctrl + Alt + V

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

‘Format Cell’ dialogue box (Use Tab, Space to navigate inside the box)

A

Ctrl + 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Increase Decimal Points

A

Alt&raquo_space; H&raquo_space; 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Decrease Decimal Points

A

Alt&raquo_space; H&raquo_space; 9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Removes Gridlines

A

Alt&raquo_space; W&raquo_space; VG

17
Q

Border Options

A

Alt&raquo_space; H&raquo_space; B

18
Q

Fill Cell with Colour

A

Alt&raquo_space; H&raquo_space; H

19
Q

Same Cell Line Break

A

Alt + Enter

20
Q

Add Comment

A

Shift + F2 (Add comment, then escape)

21
Q

Pick up from Above Cell Options (to avoid re-typing)

A

Alt + Down Arrow

22
Q

Auto-fit column width for selected cell or column

A

Alt&raquo_space; H&raquo_space; O&raquo_space; I

23
Q

Change Row Height

A

Alt&raquo_space; H&raquo_space; O&raquo_space; H

24
Q

Groups selected Rows or Columns

A

Alt&raquo_space; A&raquo_space; G&raquo_space; G

25
Q

Ungroups the grouped Rows or Columns

A

Alt&raquo_space; A&raquo_space; U&raquo_space; U

26
Q

Freeze Panes

A

Alt&raquo_space; W&raquo_space; F&raquo_space; R

Alt&raquo_space; W&raquo_space; F&raquo_space; C

27
Q

Convert to Table

A

Ctrl + T

28
Q

Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell

A

F4