To create a number sequence in an Excel worksheet, put =SEQUENCE(10) in a blank cell with room below it; in Microsoft 365, Excel fills the next ten cells with 1 through 10. For older Excel versions, type the first numbers, select them, then use the fill handle or Home > Fill > Series.
What an Excel number sequence means
Most people asking about an Excel sheet number sequence mean a series of numbers in worksheet cells: row labels such as 1, 2, 3, or identifiers such as 100, 105, 110. Excel can generate these as fixed values or with formulas that update as the sheet changes. The right approach depends on whether you need a quick one-time list, a sequence that expands automatically, or numbering tied to data rows.
A different interpretation is numbering worksheet tabs, such as renaming tabs Sheet1, Sheet2, and Sheet3. Cell formulas generate values inside a sheet; they do not rename worksheet tabs. That distinction matters because the two tasks use different Excel features.
Generate a sequence with SEQUENCE
SEQUENCE is the quickest option when you want a formula-generated list. With A1 blank and enough empty cells below it, enter =SEQUENCE(10) in A1. It returns the numbers 1 through 10 vertically. The function spills the results into neighboring cells, so you enter it once rather than copying a formula down ten rows.
SEQUENCE has four arguments: rows, columns, start, and step. Only the first argument is required. For example, with A1:A5 empty, enter =SEQUENCE(5,1,10,5) in A1. The result is 10, 15, 20, 25, and 30: five rows, one column, starting at 10 and increasing by 5 each time.
To make a horizontal list, with A1:F1 empty, enter =SEQUENCE(1,6,1,1) in A1. It returns 1 through 6 across the row. You can also create a rectangular sequence: the first argument sets the number of rows and the second sets the number of columns. SEQUENCE is available in Microsoft 365 and Excel 2021 or later. In older versions, use AutoFill or the Series command instead.
Use AutoFill for a quick fixed sequence
AutoFill is useful when you want ordinary values in cells, or when your Excel version does not support SEQUENCE. To create 1, 2, 3, and onward:
- Type 1 in A1 and 2 in A2.
- Select both cells so Excel can recognize the pattern.
- Drag the small square at the lower-right corner of the selection down as far as needed.
Selecting both starting values is important: dragging a single cell usually copies that value, while selecting 1 and 2 signals that you want an increasing series. For a sequence with another interval, enter two values that show the pattern, such as 10 and 15, and drag the handle to continue 20, 25, and so on. To fill a selected range downward from a formula or value in its top cell, Windows users can press Ctrl+D. In Excel for Mac, the corresponding shortcut is Command+D.
AutoFill creates cell contents rather than a single spill formula. That can be helpful when a workbook must work in older Excel, but the filled values will not automatically extend if you add rows later. You can drag the fill handle again or use a table and a suitable formula if the list needs to grow with your data.
Choose a starting number, interval, or direction
For a regular increasing or decreasing sequence, the starting value and step determine the pattern. A positive step increases the numbers; a negative step decreases them. With A1:A4 empty, enter =SEQUENCE(4,1,20,-2) in A1. The result is 20, 18, 16, and 14. For a simple 1-to-100 list, use 100 rows and a starting value of 1 with a step of 1.
If you are using AutoFill, provide two starting values to establish the interval. For example, type 50 and 60, select both, then drag to continue in tens. A common mistake is to select only 50 and drag, which may copy 50 repeatedly instead of inferring the intended step.
Think about whether the sequence should be fixed or recalculated. A SEQUENCE formula updates its spilled results when its arguments change. AutoFilled numbers are cell values and stay as entered unless you edit them. A formula based on row position can also recalculate if rows are inserted or deleted, which is useful for labels but may be undesirable for permanent identification numbers.
Number rows only when they contain data
A plain sequence numbers every row in its range, including blank rows. If column B contains names or records and column A should show a number only beside a populated entry, use a conditional formula. With a header in row 1, data in B2:B20, and the formula entered in A2 then copied down, use =IF(B2<>"",ROW()-1,""). If B2 contains a record, A2 displays 1; if B2 is blank, A2 displays a blank. In the next row, the row-based number is 2.
This approach reflects the worksheet row number. If you delete a record row, the remaining row labels can update, but the numbering may not represent an unchanging record ID. If instead you want a continuous count beside nonblank entries, with records in B2:B20 and the formula copied from A2 downward, use =IF(B2<>"",COUNTA($B$2:B2),""). For entries in B2, B3, and B5, the visible numbers are 1, 2, and 3; the blank B4 row stays unnumbered.
That counting option assumes column B contains actual values. If cells in the source column contain formulas that display an empty string, COUNTA can count those formulas as occupied. Check how your source data is built before relying on the result, especially in reports with formulas returning blank-looking cells.
Create a sequence of dates
Dates are stored as numbers in Excel, so a sequence can produce consecutive dates. With A1:A7 clear, enter =SEQUENCE(7,1,DATE(2026,1,1),1) in A1. It generates seven consecutive date values beginning January 1, 2026. If the cells display numbers instead of dates, select them and choose a date format from Home > Number Format. The underlying values are still dates; formatting changes how they appear.
This produces calendar days, including weekends. For a workday-only schedule, do not assume that adding 1 skips weekends; it does not. Use Excel’s workday functions or a prepared list of working dates when weekends or holidays must be excluded, and check that the holiday dates are represented correctly. For a simple list of every calendar day, SEQUENCE is sufficient.
Number worksheet tabs instead of cells
If you mean the sheet tabs at the bottom of the window, Excel does not provide a cell formula that automatically renames them in sequence. To rename a tab manually, double-click its tab, type the new name, and press Enter. You can also right-click the tab and choose Rename. Names must be unique within the workbook and are limited to 31 characters.
For a few worksheets, names such as January, February, and March are often more useful than Sheet1, Sheet2, and Sheet3 because they explain what each tab contains. A numbered naming scheme can help when order matters, such as 01 Overview, 02 Detail, and 03 Archive. If many tabs must be renamed automatically, that is a separate automation task, not a number sequence entered into worksheet cells; make a backup before using any macro that changes tab names.
Common problems and how to fix them
- The SEQUENCE formula returns an error or is not recognized: Your Excel version may not include the function. Use AutoFill or Home > Fill > Series, or open the workbook in Microsoft 365 or Excel 2021 or later.
- The formula shows a spill error: One or more cells where the results need to appear are occupied, merged, or otherwise unavailable. Clear the intended output range and try again. A dynamic array formula needs room to spill.
- The fill handle repeats the same number: Select two values that demonstrate the desired interval before dragging, rather than selecting only one value.
- Numbers skip or repeat after sorting: A row-based formula numbers current positions, not permanent records. Sort the complete data range together and decide whether you need row labels that recalculate or fixed IDs that remain attached to records.
- Dates appear as large numbers: Apply a date format to the result cells. Excel stores dates as serial values, and number formatting controls their display.
For a fixed printed list, AutoFill is straightforward. For a list that should recalculate or spill when its length changes, SEQUENCE is more convenient. For numbering records only when data exists, use a conditional formula and test it against blank rows, sorting, and any formulas in the source column.
Frequently Asked Questions
How do I automatically number rows in Excel?
With a header in row 1, enter =ROW()-1 in A2 and copy it down to number rows starting at 1. If numbering should appear only when a neighboring cell has data, use an IF formula that checks that cell.
How do I make numbers go from 1 to 100?
In Microsoft 365 or Excel 2021 and later, put =SEQUENCE(100) in an empty cell with room for the results. Alternatively, type 1 and 2 in consecutive cells, select both, and drag the fill handle until the list reaches 100.
Why does Excel repeat the same number when I drag?
Excel may be copying the single selected value instead of extending a pattern. Enter two values that establish the interval, select both cells, and drag the fill handle again. You can also use Home > Fill > Series to set the step explicitly.
Can Excel number rows only when another cell is filled?
Yes. If B2 holds the first record and A2 is the numbering cell, use =IF(B2<>"",ROW()-1,"") and copy it down. It leaves A blank when B is blank and shows a row-based number when B contains data.
Can a formula number worksheet tabs?
No. Worksheet formulas return values in cells and cannot rename sheet tabs. Rename a tab by double-clicking it or right-clicking and choosing Rename; automatic renaming requires a separate automation method.
Related
- Excel Power Query Takes Too Long to Refresh? Fixes
- Excel Power Query vs Access: Which Tool Fits Your Data?
- Excel Power Query: Split a List into Rows or Columns
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Data Table Tutorial: One- and Two-Variable What-IfsTo create an Excel Data Table, place a formula and test values in a small grid, select the…
- Concat Excel Columns: Formulas, Methods, and Fixes ExplainedTo concat Excel columns—that is, join values from separate cells into one—use the ampersand operator. With first names…
- Weighted Average in Excel: Formula and ExamplesExcel has no dedicated WEIGHTEDAVERAGE function; use SUMPRODUCT divided by SUM. With values in B2:B4 and their corresponding…
- Excel Power Query Filter Rows: Practical Steps and ExamplesTo filter rows in Excel Power Query, open a query in the Power Query Editor, select the filter…
- Excel Date Count Formula: Count Days and DatesIf your dates are real Excel date values in A2:A100, use =COUNT(A2:A100) to count the cells containing dates.…
- Excel Column Comparison: Formulas, Methods, and TipsTo compare two Excel columns, use a row-by-row equality test when corresponding cells should match, or check whether…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.