MICROSOFT EXCEL™ TIPS

“ΠΑ ΒΩ ΚΑΙ ΧΑΡΙΣΤΙΩΝΙ ΤΑΝ ΓΑΝ ΚΙΝΗΣΩ ΠΑΣΑΝ.” “Give me a place to stand and with a lever I will move the whole world,” to which I say, "Give me a spreadsheet large enough, I will solve the economic woes of this country." - Fred Kagel

Tip #1 - How to display functions and formulas in a worksheet:

Press Ctrl+~ (all versions)

Spreadsheets by their very nature are poorly documented. Go back to your spreadsheet a week or a month from now and try to figure out what you did and why you did it. The tip above will display all of the functions and formulas in the worksheet. Print them out with column and row headings and you will be able to make a lot more sense out of =$B$1*C1. Also learn to use range names.

Tip #2 - How to quickly hide cells:

Choose Font Color White

Assuming that you have a white background, white on white is invisible.

Tip #3 - Enter today's date into a cell:

Press Ctrl+;

Who said the keyboard short-cuts are dead?

Last updated Sunday, July 17, 2011 -- Check back monthly for more tips ...