TheExcelAddict .com
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.)

Why not print (CTRL+P) this tip and
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 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