Tip 213 – Quickly Format Excel Cells Using Keyboard Shortcuts

Speed up cell formatting with these easy to remember Excel formatting shortcuts:
Control + Shift + $ Currency, two decimal places
Control + Shift + % Percentage format, no decimal places
Control + Shift + ! Comma, two decimal places
Control + Shift + # Date format (d-mmm-yy)
Control + Shift + & Outline the selection
Control + Shift + _ Remove Cell Borders