Ever have one of those late nights finishing a marathon number crunching session? Just about the time you breathe that deep sigh of relief that everything is ticked and tied, you realize that your 9 am presentation tomorrow morning is only a few short hours away and your spreadsheet is nowhere near presentation ready.
Having a few essential formatting shortcuts under your belt will make quick work of polishing your spreadsheet for printing or projecting. This is the third in a series of keyboard shortcuts that reduce the time reaching for the mouse to find and click common actions. Keyboard shortcuts for navigation may be found here and shortcuts for data entry and editing may be found here.
Hey, here’s one more tip before you turn out the lights for the night: Center that spreadsheet before printing. Now…..good night, sleep tight.
|Bold||CTRL + B|
|Italics||CTRL + I|
|Underline||CTRL + U|
|Format Box||CTRL + 1|
|Outline border||SHIFT + CTRL + &|
|Remove border||SHIFT + CTRL + _|
|Add Comment||SHIFT + F2|
|General Number||CTRL + SHIFT + ~|
|Currency Format||CTRL + SHIFT + $|
|Percentage Format||CTRL + SHIFT + %|
|Exponential Number Format||CTRL + SHIFT + ^|
|Date format||CTRL + SHIFT + #|
|Time Format||CTRL + SHIFT + !|