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