Why not print (CTRL+P) this tip and
Microsoft Excel 'Quick Tip'
Viewing Your Worksheet Formulas
There may be times when you may want to display the formulas in
your worksheets. For one thing, it's a great way to spot check
your worksheets for formula errors. When you have a complicated
worksheet that has gone through many revisions, it is likely
that some errors will creep in that may not be so obvious on the
surface. A good habit to get into is periodically viewing your
formulas to ensure they are correct.
To quickly display your formulas, press CTRL + .
The single quote is on the same key as the tilde (~). Don't use
the key that has the double quote. Press the same key sequence
return to normal view.
As you look down a column that is supposed to contain identical
formulas, incorrect formulas will stand out like a sore thumb.
(NOTE: This is one of those tips where you would be well advised
to save your work before experimenting with it.)
share it with your friends and associates?
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright © All Rights Reserved by
Close this window