logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Sunday November 9th, 2025

Tip of the Day | Sunday November 9th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Create a Visual Map of Cell Types in a New Workbook

This tool creates a new workbook with a color-coded map that shows the content type of each cell in your current worksheet.
The new workbook preserves your data layout and visually indicates each cell's content type without showing the original content. Each cell shows:
  • A background color to represent the type of content
  • A label (e.g., "Text", "Formula") for added clarity
    The following color codes are used:
  • Blue: Formula
  • Yellow: Number
  • Green: Text
  • Red: External Link
    This is useful when you want to:
  • Get a clear overview of your worksheet structure
  • Audit where formulas or external links are used
  • Spot inconsistencies in data types
  • Prepare for cleanup, documentation, or debugging
    Your original data is not changed. The tool creates a separate color-coded map in a new workbook to help you safely review and understand your worksheet's structure.

    Starting this tool


    Info & List  ›  Create a Visual Map of Cell Types in a New Workbook

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


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


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.