Create a list of all type of cell values

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:

Blue: Formula

Yellow: Number

Green: Text

Red: External link

This can for example be useful to quickly see the structure of your worksheet and see where formulas are used.

Starting this tool

Click ASAP Utilities › Information › Create a list of all type of cell values
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

Additional keywords for this tool:
heat map

Report the formulas used in the worksheets in your workbook

Create a list of filenames and properties in a folder...

Download