The fastest way to number rows in Google Sheets

To number rows in Google Sheets, click the first cell where you want the number to appear, type 1, press Enter, then type 2 in the next cell. Select both cells, then drag the small square at the bottom right corner of the selection down as far as you need. Google Sheets will recognize the pattern and fill in the rest automatically.

This method works because Google Sheets detects the sequence you started. If you need to number 500 rows, you only type two numbers yourself — the rest fills in seconds. The dragging handle (the small blue square) appears whenever you select cells, and dragging it down extends whatever pattern exists in your selection.

If you have gaps in your data or want numbering that skips certain rows, you can adjust this approach. The core principle stays the same: show Google Sheets the pattern you want, then let it repeat it for you.

Key Takeaways

  • Type 1 in the first cell, 2 in the second, select both, then drag the fill handle down to auto-number as many rows as you need.
  • The fill handle is the small blue square at the bottom right corner of your selection — dragging it down extends the pattern.
  • You can number specific columns, skip rows, or restart numbering in different sections by creating separate number sequences.
  • Using a formula like =ROW() automatically numbers rows based on their position, and updates if you insert or delete rows later.

Using formulas to number rows automatically

Instead of dragging, you can use a formula that numbers rows for you. Click the cell where you want numbering to start and type =ROW()-1 (if you want numbering to start at 1 in row 2) or =ROW() (if you want the row number itself). Press Enter, then copy that cell down to all the rows you need to number.

The advantage of a formula is that it adjusts automatically. If you insert a new row in the middle of your data, the numbering below it shifts down and renumbers itself. If you delete a row, the numbers adjust. With manual dragging, you would have to redo the numbering.

The formula =SEQUENCE(n) is another option if you want to number a large block at once. Type =SEQUENCE(100) in a single cell and it creates a column of numbers from 1 to 100 when ready. This is fastest for numbering hundreds of rows at once, but it only works in one direction (downward).

Numbering specific columns or sections

You can number different columns independently. Click the first cell in the column you want to number, type 1, move to the next cell down, type 2, select both, and drag down. Each column gets its own numbering sequence.

If you want to restart numbering in a new section — for example, numbering a list of items, then starting over with a new list below it — create a gap between the sections. Number the first list, skip a row or two, then start a new sequence of 1, 2, 3 in the next section. Google Sheets treats each sequence separately.

You can also number columns horizontally (left to right) instead of vertically. Type 1 in the first cell, 2 in the cell to its right, select both, then drag the fill handle to the right. The same pattern-recognition works in any direction.

Removing or changing numbering

To remove numbering, select the cells containing the numbers, right-click, and choose Delete values. This clears only the numbers, not the rest of your data in that row.

To change numbering that you already created, select the numbered cells and delete them, then start over with your new numbering system. If you used a formula, you can edit the formula in the formula bar at the top and press Enter — the change applies to that cell, and you can copy it down again if needed.

If you want to convert a formula-based numbering system to plain numbers (so the numbers stay the same even if rows are added or deleted), select the numbered cells, copy them, right-click, choose Paste special, then select Values only. This replaces the formulas with the actual numbers.

Numbering when your data has blank rows

If your spreadsheet has blank rows mixed in with data, dragging the fill handle will skip over them automatically — it continues the pattern regardless of what is in the adjacent cells. This means you can number a list that has gaps without the numbering breaking.

If you want to number only the rows that contain data (skipping the blank ones), you need a more complex formula. Use =COUNTIF($A$1:A1,"<>") in the first data row (assuming your data is in column A), then copy it down. This counts how many non-empty cells exist above the current row and gives you a true count of data rows only.

Numbering with letters or custom formats

Google Sheets numbering works with numbers by default, but you can add letters or text before or after the numbers. In a cell, type Item 1, then in the next cell type Item 2. Select both and drag down — Google Sheets recognizes the pattern and continues it as Item 3, Item 4, and so on.

You can also use formulas to create custom numbering. Type =CONCATENATE("Row ",ROW()) to create labels like "Row 2", "Row 3", and so on. Or use =CONCATENATE("ID-",TEXT(ROW(),"000")) to create numbered IDs like ID-002, ID-003 with leading zeros.

Frequently Asked Questions

What if I drag the fill handle and it doesn't recognize my pattern?

Google Sheets needs at least two cells to recognize a pattern. Make sure you have typed two numbers (or two items with numbers) and selected both before dragging. If it still does not work, try using a formula instead — formulas are more reliable for complex patterns.

Can I number rows without manually selecting and dragging?

Yes. Use the formula =ROW()-1 in the first row where you want numbering, press Enter, then select that cell and double-click the fill handle (the small blue square). Google Sheets will automatically fill down to the last row that has data in your sheet.

If I insert a new row, will the numbering update automatically?

Only if you used a formula like =ROW(). Manual numbering (numbers you typed or dragged) stays the same — you would have to renumber manually. Formulas adjust automatically when rows are added or deleted.

How do I number only certain rows, not all of them?

Select only the cells you want to number, not the entire column. Type 1 in the first selected cell, 2 in the second, select both, then drag down within your selection. The numbering stops where your selection ends.

Can I start numbering from a number other than 1?

Yes. Type the starting number (for example, 101) in the first cell, then 102 in the second cell. Select both and drag down. Google Sheets continues the sequence from there. With a formula, use =ROW()+100 to start numbering at 101 in row 1.