How to Extend ID Numbers Down a Column in Google Sheets

What extending IDs means and why you'd do it

Extending IDs means copying a pattern of numbers or text down a column so each row gets its own unique identifier. In Google Sheets, you start with one or two cells that show the pattern — like ID-001, ID-002 — and then tell Sheets to continue that pattern for as many rows as you need. This saves you from typing each ID by hand and keeps the numbering consistent.

You might need this when you're building a customer list, tracking inventory items, or organizing any data where each row represents something separate that needs its own reference number. The pattern can be as straightforward as 1, 2, 3 or as specific as INV-2024-001, INV-2024-002.

Key Takeaways

Google Sheets can recognize a pattern from just two cells and continue it down as far as you need.
The fill-down method works best when your pattern is straightforward numbers or text with a number that increases by the same amount each time.
You can extend IDs by selecting the pattern cells, then dragging the small square at the bottom-right corner of your selection down the column.
If Sheets doesn't recognize your pattern, you can use a formula instead to generate IDs automatically based on the row number.
Always check the last few IDs after extending to make sure the pattern continued the way you intended.

The drag-down method for straightforward patterns

The fastest way to extend IDs is to show Sheets what pattern you want, then let it fill the rest. Start by typing your first ID in the top cell of your column — for example, type ID-001 in cell A1. Then move to the cell directly below it (A2) and type the second ID in your pattern: ID-002.

Now select both cells A1 and A2 by clicking on A1 and dragging down to A2. You'll see both cells highlighted in blue. At the bottom-right corner of your selection, you'll see a small blue square — this is the fill handle. Click and hold that square, then drag it down to the row where you want your IDs to stop. As you drag, Sheets shows you a preview of what the next ID will be. Release the mouse when you reach the last row you need.

Sheets recognizes that each ID increases by 1 and continues the pattern automatically. If your pattern is different — like ID-001, ID-003, ID-005 (increasing by 2 each time) — the same method works. Just type the first two IDs to show the pattern, then drag down.

Using the fill series option for more control

If dragging feels awkward or you want to extend IDs to a specific row number without counting, use the Fill Series menu instead. Start the same way: type your first ID in one cell and your second ID in the cell below it. Select both cells.

Then go to the Sheet menu at the top, click Fill, and choose Series. A dialog box opens. Leave the settings as they are — Sheets has already detected your pattern from the two cells you selected. At the bottom, you'll see a field that says "To value" or shows a number. Type the last ID you want to create, or type the row number you want to fill to, then click explore.

This method is useful when you know exactly how many IDs you need — for instance, if you're creating IDs for 500 customers, you can tell Sheets to stop at ID-500 without having to count rows yourself.

Creating IDs with a formula when patterns don't work

Some ID patterns are too complex for Sheets to recognize by dragging. For example, you might want IDs like INV-2024-001, INV-2024-002, where the year stays the same but the number at the end changes. In this case, a formula is faster and more reliable than trying to show Sheets the pattern.

Click on the first cell where you want an ID (usually A1). Type a formula that combines text with a row number. For example: =CONCATENATE("INV-2024-",ROW()) or the shorter version ="INV-2024-"&ROW(). The ROW() function automatically gives you the current row number, so row 1 becomes INV-2024-1, row 2 becomes INV-2024-2, and so on.

If you want the numbers to be padded with zeros — like INV-2024-001 instead of INV-2024-1 — use this formula instead: ="INV-2024-"&TEXT(ROW(),"000"). The TEXT function formats the row number with leading zeros. Press Enter, and the first ID appears. Now select that cell and drag the fill handle down to copy the formula to every row you need. Each row automatically adjusts the row number, so you get unique IDs all the way down.

Fixing IDs that didn't extend correctly

Sometimes Sheets doesn't recognize the pattern you intended. You might drag down and see the same ID repeated, or numbers that jump by the wrong amount. The quickest fix is to undo (press Ctrl+Z on Windows or Cmd+Z on Mac) and try again with the Fill Series menu, which gives you more control over what Sheets should do.

If the pattern is truly unusual — like a mix of letters and numbers that don't follow a straightforward rule — a formula is your only real option. Delete the incorrect IDs, then use the CONCATENATE or TEXT method described above. Formulas never guess; they do exactly what you tell them to do.

After extending IDs by any method, scroll down and spot-check the last few rows to make sure the numbering is correct. This takes 10 seconds and catches mistakes before you share the sheet or use those IDs in another system.

Extending IDs in a sheet you're still building

If you're creating a new sheet and know you'll need IDs for many rows, set up the IDs first before you add other data. This prevents you from having to adjust formulas or fill ranges later. Type your first ID, create the pattern with a second ID or a formula, then extend it down to cover all the rows you think you'll need — even if some are empty right now.

If you later add more rows than you planned for, extending IDs to the new rows takes just a few seconds. Select the last ID cell, drag the fill handle down to the new rows, and you're done. This is much faster than trying to insert IDs into the middle of a column after you've already filled it with other data.

Frequently Asked Questions

Can I extend IDs that have letters and numbers mixed together?

Yes, if the pattern is regular — like ABC-001, ABC-002, ABC-003. Use the drag method or Fill Series, and Sheets recognizes that only the number part changes. If the letters change too, or the pattern is irregular, use a formula instead so you control exactly what each ID should be.

What if I extend IDs too far by accident?

Press Ctrl+Z (or Cmd+Z on Mac) to undo when ready. If you've already done other work since then, select the extra IDs, right-click, and choose Delete values to clear just those cells without deleting the entire rows.

Can I extend IDs that start at a number other than 1?

Yes. Type your first ID (like ID-100) in the first cell and your second ID (like ID-101) in the cell below. Sheets sees the pattern and continues from there. If you use a formula, adjust the formula to add an offset — for example, ="ID-"&(ROW()+99) makes row 1 become ID-100.

Do I have to extend IDs all at once, or can I add more later?

You can add more later. If you used the drag or Fill Series method, select the last ID cell and drag down to the new rows. If you used a formula, the formula automatically adjusts for any new rows you add below it, so new IDs appear without you doing anything.

What's the difference between dragging and using Fill Series?

Dragging is faster for small lists, but Fill Series is better when you need to extend to a specific row number or when you want Sheets to show you exactly what it's doing before it fills. Both methods produce the same result.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.