The fastest way to number rows in Excel

The quickest method is to type the first two numbers yourself, then let Excel finish the pattern. Type 1 in the first cell, 2 in the cell below it, then select both cells. Grab the small square at the bottom right corner of your selection (called the fill handle) and drag it down as far as you need. Excel will continue the sequence automatically.

This works because Excel recognizes the pattern from those first two numbers. You do not have to tell it what you want — it figures it out from the example you gave it. If you only type one number and try to drag, Excel will just copy that same number down the column instead of counting up.

If you need to number hundreds of rows, dragging by hand gets tedious. Instead, type 1 and 2 in the first two cells, select both, then double-click the fill handle. Excel will automatically fill down to the last row that has data in any nearby column. This saves you from dragging all the way to row 500 or beyond.

Key Takeaways

  • Type 1 in the first cell and 2 in the second, select both cells, then drag the fill handle down to create a sequence.
  • Double-clicking the fill handle fills the sequence down to match the last row of data in adjacent columns, which is faster than dragging manually.
  • The Fill Series menu (under the Sheet menu on Mac, or the Edit menu on Windows) lets you number by 5s, 10s, or any increment you choose.
  • If you need to restart numbering in a new section, create a separate sequence in a new column rather than trying to break one sequence into pieces.

Using the Fill Series menu for custom increments

If you want to number by 5s, 10s, or any other interval, the drag method will not work — Excel only recognizes straightforward counting patterns. Instead, use the Fill Series menu. On a Mac, go to Sheet > Fill > Series. On Windows, go to Edit > Fill > Series.

First, select the range where you want the numbers to appear. If you want numbers from row 1 to row 50, click on the first cell, hold Shift, and click on the 50th cell. Then open the Fill Series menu. A box will appear asking for a start value, stop value, and step value. The step value is your increment — enter 5 if you want to count by 5s, 10 if you want to count by 10s, and so on.

This method is also useful when you want to number starting from a number other than 1. If your list should start at 100, enter 100 as the start value and set your step to 1. Excel will fill the selected range with 100, 101, 102, and so on.

Numbering rows when your data is not in order

If your spreadsheet has data scattered across rows — perhaps because you sorted it, deleted rows, or added new entries in the middle — you may need to renumber everything so the sequence stays clean. The safest approach is to create the sequence in a new column first, then copy it into the column where you actually want it.

Create your sequence in an empty column using either the drag method or the Fill Series menu. Once the numbers are correct, select the entire numbered column, copy it (Ctrl+C on Windows, Command+C on Mac), then click on the column where you want the numbers to go. Right-click and choose Paste Special, then select Values Only. This pastes just the numbers, not the formulas, so they will not change if you move rows around later.

Restarting a sequence in the middle of your spreadsheet

Sometimes you have multiple sections in one spreadsheet — perhaps different months, different departments, or different categories — and you want each section numbered separately starting from 1. The cleanest way is to create a separate numbering column for each section.

For example, if rows 1–20 are January data and rows 21–40 are February data, create one sequence (1 to 20) for January and a second sequence (1 to 20) for February in a different column. This keeps your data organized and makes it straightforward to see where each section begins and ends. If you try to force one sequence to restart in the middle, you will end up with formulas that are hard to edit later.

If you absolutely must have all numbers in a single column, you can use a formula instead of the fill method. In the first cell of your section, type =ROW()-ROW($A$1)+1 (adjust the cell reference to match your first row). Copy this formula down, and it will number starting from 1 at whatever row you begin. This is more complex than the drag method, but it updates automatically if you add or delete rows within that section.

Fixing numbering after you add or delete rows

If you numbered your rows using the drag method and then added or deleted rows in the middle, your numbers will be out of order. The simplest fix is to redo the numbering. Select your entire numbered column, delete the numbers, and create the sequence again from scratch using the drag or Fill Series method.

If you used a formula (like the ROW() formula mentioned above), the numbers will update automatically when you add or delete rows. This is one reason formulas are worth learning if you plan to edit your spreadsheet often. However, if you used the straightforward drag method, formulas are not involved — the cells just contain static numbers that do not change.

Numbering columns instead of rows

The same methods work for numbering columns as for numbering rows, just in the opposite direction. Type 1 and 2 in the first two cells of your row, select both, then drag the fill handle to the right instead of down. Excel will continue the sequence across columns.

You can also use Fill Series for columns. Select the range of cells across the row where you want numbers to appear, open the Fill Series menu, and enter your start value, stop value, and step. The result is the same — a sequence running left to right instead of top to bottom.

Frequently Asked Questions

What is the fill handle and where do I find it?

The fill handle is a small square at the bottom right corner of your selected cell or range. When you hover over it, your cursor changes to a crosshair. Click and drag it to extend your selection and fill the cells below (or to the right) with a pattern or value. On some older versions of Excel, you may need to enable it in preferences.

Can I number rows starting from zero instead of one?

Yes. Type 0 in the first cell and 1 in the second, then select both and drag. Excel will recognize the pattern and continue with 2, 3, 4, and so on. You can start from any number — negative numbers work too.

Why does dragging only copy the same number instead of counting up?

You selected only one cell before dragging. Excel needs at least two cells to recognize a pattern. Type your first number, type your second number in the cell below, select both cells, then drag. Excel will then understand you want to count.

How do I number rows without using the fill handle?

Use the Fill Series menu instead. Select the range where you want numbers, go to Sheet > Fill > Series (Mac) or Edit > Fill > Series (Windows), enter your start and stop values, and click OK. This works even if you prefer not to use the mouse to drag.

What happens if I copy a numbered column to a different spreadsheet?

If you used the drag method, the numbers copy as static values and stay the same. If you used a formula like ROW(), the formula copies too, but it will reference rows in the new spreadsheet, so the numbers may change. To avoid confusion, use Paste Special > Values Only when moving numbered columns between files.