logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Create a list of all type of cell values

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

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

  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us