We're nominated again this year for Best Microsoft Excel Add-in at the Global Excel Awards! ❤️🌟
If ASAP Utilities has helped you in Excel, you can support it with a quick vote→. It only takes about 30 seconds.
Find us in the second category: Best Microsoft Excel Add-in. You can skip other categories if you're unsure about them.
logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Tuesday March 31st, 2026

Tip of the Day | Tuesday March 31st, 2026

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

Auto Numbering and Labeling of Selected Cells...

This tool helps you automatically number or label the selected cells, with several flexible options.
You can use it to quickly create series such as:
  • 1, 2, 3...
  • 00001, 00002, 00003...
  • A, B, C...
  • Week 1, Week 2, Week 3...
  • Product-001, Product-002...

    Series Options:

  • Create a numeric series:
          ·  Define the starting number (e.g., 1)
          ·  Define the increment (e.g., +1)
          ·  Optional: restart after a certain number
          ·  Optional: pad numbers with leading zeros to a fixed length (e.g., 00001)
  • Create an alphabetic series:
          ·  Lowercase letters (a, b, c, ...)
          ·  Uppercase letters (A, B, C, ...)

    Additional Options:

  • Add a prefix and/or suffix to each value (e.g., "Week " + number = Week 1)
  • Restart numbering when the value in a specific column changes (e.g., restart count per city or category)
  • Optional: include the value from that column as part of the label (e.g., "New York-001", "Chicago-001", etc.)
  • Set cell alignment (general, left, center, right)
    This tool is useful for preparing structured lists, labeling grouped data, generating IDs, or creating sequences for reporting.
    By default, you can launch this tool using the Control+Alt+Q shortcut.

    Screenshots

    Example screenshot: 1 Example 1
    1 Example 1
    Example screenshot: 2 Example 2
    2 Example 2
    Example screenshot: 3 Example 3
    3 Example 3
    Example screenshot: 4 Example 4
    4 Example 4
    Example screenshot: 5 Example 5
    5 Example 5
    Example screenshot: 6 Example 6
    6 Example 6
    Example screenshot: 7 Example 7
    7 Example 7
    Example screenshot: 8 Example 8
    8 Example 8
    Example screenshot: 9 Example 9
    9 Example 9

    Starting this tool


    Numbers & Dates  ›  Auto Numbering and Labeling of Selected Cells...

    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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.