Excel Formula to find Sequential row numbers in excel office 365?
Tags: excelformula, excelformulas
Published: 2021-10-26 07:54:14

---
title: Excel Formula to find Sequential row numbers in excel office 365?
published: true
date: 2021-10-25 12:40:28 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-to-find-sequential-row-numbers-in-excel-office-365/
---

In this article, we will discuss how to  **find sequential row numbers** in Excel Office 365. You can also learn basic syntax with a suitable example. Are there any effective ways for solving this problem? Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- Use this formula to find sequential row numbers in Excel 365.

```
=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)()-[offset](https://geekexcel.com/use-offset-function-in-microsoft-excel-365/)

```

## Syntax Explanation

- **[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/) **– It helps to return the row number for reference.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Offset ** – In Excel, the [**OFFSET function**](https://geekexcel.com/use-offset-function-in-microsoft-excel-365/) will return the smallest numeric value from the range of input values.

## Practical Example

Refer to the below example.

- For instances, you need to **create a sample data** in Excel 365.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-46.png)<figcaption>Sample data</figcaption>

- Then, you have to use the below given **formula** in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)()-4

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-formula-5.png)<figcaption>Use the formula</figcaption>

- Now, you will get the result in the **row column** in the **cell B5**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-43.png)<figcaption>Result for the cell B5</figcaption>

- Finally, as like that, you have to **press Ctrl + D key** to get the **sequential row numbers** for **all the cells**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Final-Output-1.png)<figcaption>Output</figcaption>

## Conclusion

In the above article, we have discussed the simple formulas to **find sequential row numbers** in Excel Office 365. If you have any  **issues**  regarding this article or any unresolved  **queries** , please  **comment**  in the comment box below. We will assist you.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

**Continue Reading:**

- **[How to Create & Insert Unique Sequential Numbers in Excel Office 365?](https://geekexcel.com/how-to-create-insert-unique-sequential-numbers-in-excel-office-365/)**
- **[Formulas to Add Row Numbers and Skip Blanks ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-add-row-numbers-and-skip-blanks-simple-guide/)**
- [**Excel ROW Function in Office 365 – How to use it?**](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)
- **[Formulas to Find Last Row Number in a Range in Excel 365!!](https://geekexcel.com/excel-formulas-to-find-last-row-number-in-a-range-in-excel-365/)**
- **[Excel Formulas to Convert Numbers into Text ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-covert-numbers-into-text-a-complete-guide/)**