Map Styles and Names
![](images/image(186).png)
This command allows you to choose which of the three available where-used maps you want to create.
![](images/image(187).png)
Map Styles
![](images/image(188).png)
The Map Styles option produces a report sheet showing the count of each style used by each worksheet. You can use this map to identify where and how often the styles are being used.
Map Number Formats
![](images/image(189).png)
The Map Formats option produces a report sheet showing the count of each number format used by each worksheet. You can use this map to identify where and how often the number formats are being used. Selecting one of the count cells in the Map Formats sheet and clicking the FastExcel GoTo button will show you the sheet with all the cells on the sheet that use this Number Format selected.
This makes it easy to change or remove Number Formats.
Map Defined Names
Name Map analyzes all the formulas on the worksheets in the workbook and in other names to produce a Name Map worksheet showing counts of the usage of the Names by worksheet and by other Name.
Names created by INDIRECT formulas are also found.
![](images/image(190).png)
|