PopTools logo

Make a map of current sheet

This tool will generate a map of the current sheet, showing cells that contain text, numeric values and formulas. It is is particularly useful to find cells that cause errors because Excel is seeing text rather than a number. A macro is inserted into the map sheet that makes every cell in the map a hyperlink to the original sheet.

If you don’t want the macro in your workbook, either go to the visual basic editor and delete the code, or delete the map sheet (the code is attached to the map sheet rather than the workbook). The routine relies partly on code from John Walkenbach’s site.

Footer image - matrix analysis