Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Show Formulas, Why? (2K/03)

    Happy November 2006 Y'all,

    Here's a challenge.

    I know you can toggle showing/hiding formulas in cells by pressing CTRL+` (grave accent).

    Give me three good reasons to show formulas in cells.

    This is not a "pop quiz" and I am really eager to see what you think.

    Thanks and G'Day,
    Rich

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show Formulas, Why? (2K/03)

    I can give you one. It comes in handy when you are auditing a worksheet.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show Formulas, Why? (2K/03)

    Thanks Legare,

    In what way do you use the feature as you are auditing your worksheet?

    G'Day,
    Rich

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Show Formulas, Why? (2K/03)

    You can quickly tell if someone has 'overtyped' a formula in a cell i.e. replaced the formula by entering a number.
    Hard to spot unless you are using ExcelXP

    zeddy

  5. #5
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show Formulas, Why? (2K/03)

    Hi Zeddy,

    Thanks so much. Yes, that is very helpful.

    G'Day,
    Rich

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show Formulas, Why? (2K/03)

    You can print the sheet with formulas displayed, and then work through the formula with pencil and paper to make sure it is calculating what it is supposed to be calculating. It is also a quick way to check that a formula has not been overlayed with constant data, particularly if the sheet does not use protection to protect formulas from being overwritten.
    Legare Coleman

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show Formulas, Why? (2K/03)

    And it is a way to document the way your spreadsheet works.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Show Formulas, Why? (2K/03)

    ....and it is a great teaching aid when trying to explain how different functions tie in together

    ....and it impresses the boss when you do it and vaguely point at a cell and state "Hmmmn , problems seems to be there" and then nod <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Show Formulas, Why? (2K/03)

    that makes it 5 reasons so far

  10. #10
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Show Formulas, Why? (2K/03)

    And of course, its a way to fool a novice Excelite into thinking there is a virus in the program <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    Six reasons....thats doubled what you asked for!! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •