Tip of the Day | Monday 23 November 2026

Discover new tools to get things done.

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.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: 1 Example 1 (Here's the English version.)
1 Example 1
Example screenshot: 2 Example 2 (Here's the English version.)
2 Example 2
Example screenshot: 3 Example 3 (Here's the English version.)
3 Example 3
Example screenshot: 4 Example 4 (Here's the English version.)
4 Example 4
Example screenshot: 5 Example 5 (Here's the English version.)
5 Example 5
Example screenshot: 6 Example 6 (Here's the English version.)
6 Example 6
Example screenshot: 7 Example 7 (Here's the English version.)
7 Example 7
Example screenshot: 8 Example 8 (Here's the English version.)
8 Example 8
Example screenshot: 9 Example 9 (Here's the English version.)
9 Example 9

Tip:Alt+P for the previous tool.