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
_______________