Auditing Excel Formulas Quick Tips

For the past couple of weeks I’ve had lots of trouble with this blog. It’s been up and down, and I’m sorry if you’ve come to visit, and found the doors closed! The sturdy-looking door shown below is at Brock’s Monument, in Niagara-on-the-Lake, which I visited earlier this month.

So, I’ve turned off a few things on the blog, like subscribing to comments, to see if that helps. Maybe Dick Kusleika, at Daily Dose of Excel, has some tips for me, if he’s sorted out his blog problems.

doorclosedbrock

Auditing Formulas on a Worksheet

This week, I’ve added a new page to my Contextures site, with a few quick tricks for auditing worksheet formulas. I’m giving an Excel tips presentation on Friday, and this is one of the topics that I’ll include.

You’ll see how to

  • use keyboard shortcuts or Ribbon commands to show worksheet formulas
  • show formulas in an adjacent column, using the new FORMULATEXT function
  • use keyboard shortcuts to go to dependent or precedent cells
  • trace precendent and dependent cells with arrows, then remove the arrows

Here is the link to the new page:  http://www.contextures.com/excelformulasaudit.html

Video: Auditing Formulas on a Worksheet

There’s a video too, so if you’d like to see a few commands and shortcuts for auditing and troubleshooting formulas, please watch this short video tutorial.

Or watch on YouTube: Auditing Excel Formulas – Quick Tips

_______________

You may also like...

9 Responses

  1. Nope, I’ve got nothing. I’ve had to reboot my server twice in the last two weeks. When I disabled Subscribe to Comments, I went a good month with no problems, but they’re back. Now I’m down to plugins that I won’t disable because I’d rather not have a blog than to have one with out them.

    • Thanks, and sorry to hear that your blog is still having problems. I kept Akismet, and W3 Total Cache, and adjusted some of the cache settings on that plugin. It’s strange, and annoying, that things go along smoothly for a while, then it falls over.

  2. My next step is to turn it over to Digital Ocean and see if they can determine the cause. If they get stumped, I’ll be moving away from WordPress to something lighter. I’ll keep you posted and would love to hear from you if you find anything.

  3. MF says:

    Hi Debra,
    FYI. I have been following your blog via WordPress. Recently I receive notices not only from your blog post, but also from the comments left by readers. I am not complaining anything. I just wanna let you know.
    Cheers,
    MF

  4. MF says:

    Hi Debra,
    I learn a trick (can’t remember where I learned it) in checking formula consistence in a column, and would like to share.
    1) Select the range
    2) Go To Special –> Column differences
    Then formula that is different from the 1st one in the range will be selected. I find it quite useful.
    Same trick applies to row by using Row differences
    Cheers,
    MF

  5. Doug Glancy says:

    Debra, I’m sorry to hear that your having so much trouble with your blog (and that all Dick’s efforts on his haven’t yielded a solution). It’s such a great resource – thanks for keeping it going!

Leave a Reply to MF Cancel reply

Your email address will not be published. Required fields are marked *