Find formula that refer to hidden cells

Find formula that refer to hidden cells

It is so easy to hide rows and columns in Excel, we often forget that formula may still be referring to these hidden cells. If these cells are important, why are they hidden?

A common mistake is that instead of deleting some rows because the spreadsheet gives REF errors on deletion, they are hidden. But the fact that it gives REF errors on delete means that those cells are important to something!

Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors