Save 5 minutes a day by using ASAP Utilities to quickly insert a series of values into your cells.

"Easily insert a series of values"

Sometimes you need a bit more flexibility than Excel offers with its built-in Fill tool.
For example to restart the count when a certain value is reached, add a pre-fix or suffix, auto number in a filtered list, filling merged cells too, etc.

In such a case, just select the cells and use:
ASAP Utilities » Fill » Quick numbering of selected cells... (Control+Alt+Q)

Please have look at below examples to see the various possibilities:

Example 1

1. Start with number 1
2. Add 1 every time
3. Restart counting after number 5

Example 2

The most basic scenario, start with number 1 and add 1 for every cell:

Example 3

1. Start with 10
2. Add 10
3. Restart counting after number 50
4. Fill up with leading zeros to a total of 3 digits:

Example 4

1. Start with 1
2. Add 1
3. Restart counting if the value in column [C] changes

Example 5

1. Start with 1
2. Add 1
3. Restart counting if the value in column [D] changes
4. Add the value for column [D] in front of the number

Example 6

1. Use the letters A-Z to number the cells
2. Add the value "comp [" in front
3. Add the value "]" at the end

Example 7

1. Start with 1
2. Add 1
3. Restart counting after number 4
4. Add the value "Field_" in front

Example 8, works on Merged Cells too

1. Merged cells are not a problem with our numbering tool
   (Excel's (auto) fill tool can't be used when your selection contains merged cells, "all the merged cells need to be the same size")
2. Start with 1
3. Add 1

Example 9, Auto numbering data in a filtered list too

1. Quick numbering also works on the filtered data. Only the visible cells are numbered, the hidden rows are skipped.
2. Start with 1
3. Add 1
4. Fill up with leading zeros to 2 digits
5. Add the value "ES_" at the front

Do you recognize any of these situations?

• Please help me how to fill series with only visible rows after auto filtered applied.
• How do I fill an excel column with consecutive numbers without typing each one separately?
• Many times I need to create excel sheets that have a unique ID (typically sequential). I think that a feature that allows the user to define the columns and format of the unique ID (Numeric starting 'X", alphanumeric with fix string (AAxxxx), etc.), would be a great improvement.
• I'm trying to get Excel to count to a defined end number, then restart at 1. How can this be done?
• Help, I'm trying to do an auto fill and a part of the range for the auto fill has some merged cells. I keep getting the error: "This operation requires the merged cells to be identically sized."

Just select the cells and use the following tool:
ASAP Utilities » Fill » Quick numbering of selected cells...

This tool can help you in addition to Excel's built-in methods to auto fill cells.

Bonus tips, also interesting

• ASAP Utilities Tip: Quickly extend your selection down to the end without scrolling
• ASAP Utilities » Fill » Random numbering of cells (without duplicates)
• ASAP Utilities » Fill » Copy values to empty cells below filled cells in selection / Tip: Quickly fill blank cells with value above in Excel
• ASAP Utilities » Fill » Insert before and/or after each cell in your selection...
• To quickly create many worksheets, you can use the quick numbering tool in combination with:
  ASAP Utilities » Sheets » Insert multiple sheets (uses the cell values as sheet names)...

How much time will it save?

It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on how much you use Excel, the amount of data you are working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.

Download

In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for home projects, schoolwork and use by charitable organizations) or the fully functional 90-day Business trial.
Download page