Find range names in Excel

Find range names in Excel

Range names are a controversial subject in the Excel world. Some love them and some hate them. Either way, if you use them you should run checks to see if some of the ranges are overlapping.

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