Auditing Excel Formulas Quick Tips

Auditing Excel Formulas - Quick Tips

This week, I’ve added a new page to my Contextures Excel site, with a few quick tricks for auditing worksheet formulas.

Auditing Formulas on a Worksheet

On Friday, I’m giving an Excel tips presentation, and one of the topics that I’ll include is Auditing Excel Formulas.

In the video in the section below, 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 precedent and dependent cells with arrows, then remove the arrows
show worksheet formulas instead of results
show worksheet formulas instead of results

More Tips for Auditing Formulas

For more tips on how to audit formulas in your Excel files, go to my Contextures website. There’s also an Excel file that you can download, to follow along with the video.

Video: Auditing Formulas on a Worksheet

To see a few commands and shortcuts for auditing and troubleshooting formulas, watch this short video.

Blog Problems

In other news, 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, like the door in the photo below!

That sturdy-looking door shown is at Brock’s Monument, in Niagara-on-the-Lake, which I visited earlier this month, on a mini vacation.

doorclosedbrock

I want to resolve the blog problems, 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 has managed to sort out his blog problems.

0 thoughts on “Auditing Excel Formulas Quick Tips”

  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.

    1. 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. 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. 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. 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 Anonymous Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.