How to reveal the formulas in all cells

Here are the steps to follow for this lesson:

  1. To reveal the formula in a single cell, double-click the cell or press the F2 key.
  2. To reveal all of the formulas in the worksheet use Ctrl + Tilde (Ctrl+˜) – This is a “toggle.”
  3. There are 4 ways to write a formula to show the discounted price:
    1. If the cell containing the discount % is a negative (-20%) number =B5+(B5*$D$2)
    2. If the cell containing the discount % is a positive (20%) number =B5-(B5*$G$2)
    3. If the cell containing the discount % is a negative (-20%) number =B5*(1+$D$2)
    4. If the cell containing the discount % is a positive (20%) number =B5*(1-$G$2)

Find the video lesson that you want - Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007″ is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

rss Subscribe to our RSS Feed

This entry was posted on Thursday, July 31st, 2008 at 7:58 AM and is filed under Everyday Calculations in Excel, Excel Training, Tips and Time Savers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«
»

One Response to “How to reveal the formulas in all cells”

  1. The Company Rocks Excels » Blog Archive » Trust Your Sources but Verify Your Data’s Accuracy Says:
    March 23rd, 2009 at 8:53 AM

    [...] How to reveal the formulas in all cells Share and Enjoy: [...]

Leave a Reply

Powered by WishList Member - Membership Site Software