MICROSOFT EXCEL TIPS
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.
Choose Font Color White
Assuming that you have a
white background, white on white is invisible.
Who said the keyboard
short-cuts are dead?
Last updated Sunday, July 17, 2011 -- Check back monthly for more tips ...
For More Information Contact:
Fred Kagel, Director
Freehold Computer Training Ctr.
Tel: (732) 577-0606