1. Computing & Technology

Discuss in my forum

Ted French

Show Formulas in Excel

By , About.com GuideJuly 19, 2011

Follow me on:

In large worksheets, keeping track of your formulas and functions can be a real chore. Not only can it be hard to find them, but it also becomes difficult to keep track of the data that each formula references.

In Excel, it's easy to see all of your formulas and functions at once.

With a quick key combination from the keyboard, you can:

  • check to see which cells contain formulas
  • read through all formulas to check for errors
  • print the spreadsheet while showing all formulas

For all the details on this handy feature, read the short tutorial Show Formulas in Excel.

Related Tutorials

Comments
No comments yet.  Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2012 About.com. All rights reserved.

A part of The New York Times Company.