Formatting Flashcards
Converts to Excel DEFAULT
Cell Format
Ctrl + Shift + `/ ~
Converts to COMMA & TWO DECIMAL Format
Ctrl + Shift + 1 / !
Converts to Date (DD-MMM-YY) Format
Ctrl + Shift + 3 / #
Converts to CURRENCY Format
Ctrl + Shift + 4 / $
Converts to PERCENTAGE Format
Ctrl + Shift + 5 / %
Adds borders around selected range
Ctrl + Shift + 7 / &
Removes borders, outlines from selected range
Ctrl + Shift + - / _
Hide selected Rows
Ctrl + 9
Unhide rows (Select rows around hidden rows first)
Ctrl + Shift + 9
Hide Columns, Add Shift for un-hiding columns
Ctrl + 0
Unhide columns (Select columns around hidden columns first)
Ctrl + Shift + 0
Paste Special, after copying
Ctrl + Alt + V
‘Format Cell’ dialogue box (Use Tab, Space to navigate inside the box)
Ctrl + 1
Increase Decimal Points
Alt»_space; H»_space; 0
Decrease Decimal Points
Alt»_space; H»_space; 9
Removes Gridlines
Alt»_space; W»_space; VG
Border Options
Alt»_space; H»_space; B
Fill Cell with Colour
Alt»_space; H»_space; H
Same Cell Line Break
Alt + Enter
Add Comment
Shift + F2 (Add comment, then escape)
Pick up from Above Cell Options (to avoid re-typing)
Alt + Down Arrow
Auto-fit column width for selected cell or column
Alt»_space; H»_space; O»_space; I
Change Row Height
Alt»_space; H»_space; O»_space; H
Groups selected Rows or Columns
Alt»_space; A»_space; G»_space; G
