Sequence formula in excel 1 to 100

Sequential numbers are an ordered list of consecutive numbers.

How to add numbers in a column in excel

It can sometimes be needed to have your rows numbered with sequential numbers.

For example, if you have a dataset of different stores in a state, you may want to number the rows and so we have a unique number for each store.

Excel provides multiple ways to enter sequential numbers (also called serial numbers).

In this tutorial we will look at 4 such ways:

• Using the Fill handle feature
• Using the ROW function
• Using the SEQUENCE function
• Converting the dataset into a table

Let us take a look at each of these methods one by one to enter serial numbers in Excel.

Using the Fill Handle Feature to Enter Sequential Numbers in Excel

Excel’s Fill Handle feature is smart enough to identify patterns in your data and project the pattern to the rest of the cells in a column.

Say you have the following dataset and you want to enter a sequence of numbers starting from 1 (in the second row) all the way to the last row.

Here’s how you can quickly fill in Column A with a number sequence using the fill handle:

1. Enter t
   how to put page numbers in excel sheet
   how to put serial numbers in excel sheet