logo ASAP Utilities
HomeExtra features for ExcelNumbers & DatesAuto Numbering and Labeling of Selected Cells...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Auto Numbering and Labeling of Selected Cells...

ASAP Utilities  › Numbers & Dates  ›  13. 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
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Numbers & Dates  ›  13 Auto Numbering and Labeling of Selected Cells...
    Additional keywords for this tool:
    Auto number cells, Sequential numbering, Auto fill numbers, Create numbered list, Auto label rows or columns, Restart numbering per group, Custom sequence generator, Fill series with letters, Generate IDs in Excel, Number with prefix, Alphabetic series, Numbering with text, Row numbering by category, Auto increment cells, Fill down numbers with text, Generate product codes, Create custom labels
    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.