You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Information » Create a list of all type of cell values
This 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.
Screenshots
Example screenshot: List data types
Starting this utility
In the Excel menu choose: ASAP Utilities » Information » Create a list of all type of cell values« Return to the list of “Information” tools.
| « Previous Report the formulas used in the worksheets in your workbook | Next » Create a list of filenames and properties in a folder... |
You can do this too
Download "The one essential add-in for all Excel users."
Additional keywords for this tool:
heat map
heat map
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
