logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Wednesday August 6th, 2025

Tip of the Day | Wednesday August 6th, 2025

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