ASAP Utilities, description of our Excel toolsEnglish (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語
Information » Create a list of all type of cell valuesThis utility creates a new workbook that reports the data types of your current worksheet.
The new workbook is a copy of your worksheet without the actual data but where the cells with formulas, numbers, text and external links are marked with different colors.
The following colors are used to display which information is stored in a cell:
This can for example be useful to quickly see the structure of your worksheet and see where formulas are used.
Starting this utilityIn the Excel menu choose: ASAP Utilities » Information » Create a list of all type of cell values
« Return to the list of “Information” tools.
Download ASAP Utilities
Additional keywords for this tool:
Follow ASAP Utilities on Facebook
List of all utilities
Printer friendly page
^ Back to Top