Formatting

Question 1

Converts to Excel DEFAULT

Cell Format

Answer 1

Ctrl + Shift + `/ ~

Question 2

Converts to COMMA & TWO DECIMAL Format

Answer 2

Ctrl + Shift + 1 / !

Question 3

Converts to Date (DD-MMM-YY) Format

Answer 3

Ctrl + Shift + 3 / #

Question 4

Converts to CURRENCY Format

Answer 4

Ctrl + Shift + 4 / $

Question 5

Converts to PERCENTAGE Format

Answer 5

Ctrl + Shift + 5 / %

Question 6

Adds borders around selected range

Answer 6

Ctrl + Shift + 7 / &

Question 7

Removes borders, outlines from selected range

Answer 7

Ctrl + Shift + - / _

Question 8

Hide selected Rows

Answer 8

Ctrl + 9

Question 9

Unhide rows (Select rows around hidden rows first)

Answer 9

Ctrl + Shift + 9

Question 10

Hide Columns, Add Shift for un-hiding columns

Answer 10

Ctrl + 0

Question 11

Unhide columns (Select columns around hidden columns first)

Answer 11

Ctrl + Shift + 0

Question 12

Paste Special, after copying

Answer 12

Ctrl + Alt + V

Question 13

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

Answer 13

Ctrl + 1

Question 14

Increase Decimal Points

Answer 14

Alt&raquo_space; H&raquo_space; 0

Question 15

Decrease Decimal Points

Answer 15

Alt&raquo_space; H&raquo_space; 9

Question 16

Removes Gridlines

Answer 16

Alt&raquo_space; W&raquo_space; VG

Question 17

Border Options

Answer 17

Alt&raquo_space; H&raquo_space; B

Question 18

Fill Cell with Colour

Answer 18

Alt&raquo_space; H&raquo_space; H

Question 19

Same Cell Line Break

Answer 19

Alt + Enter

Question 20

Add Comment

Answer 20

Shift + F2 (Add comment, then escape)

Question 21

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

Answer 21

Alt + Down Arrow

Question 22

Auto-fit column width for selected cell or column

Answer 22

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

Question 23

Change Row Height

Answer 23

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

Question 24

Groups selected Rows or Columns

Answer 24

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

Question 25

Ungroups the grouped Rows or Columns

Answer 25

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

Question 26

Freeze Panes

Answer 26

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

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

Question 27

Convert to Table

Answer 27

Ctrl + T

Question 28

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

Answer 28

F4