How to Increment a Value by Row or Column in Excel Office 365?
Tags: incrementvaluebyrowo, excelpreface
Published: 2021-03-15 11:48:21

---
title: How to Increment a Value by Row or Column in Excel Office 365?
published: true
date: 2021-03-15 09:50:43 UTC
tags: Incrementvaluebyrowo,ExcelPreface
canonical_url: https://geekexcel.com/how-to-increment-a-value-by-row-or-column-in-excel-office-365/
---

If you want to increment a value based on a row or column in your Excel worksheet, what will you do? So we will help you to complete the task with clear-cut steps. Let’s see how to **increment a value by row or column in Excel Office 365**. 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)
## Formula Syntax & Its Explanation:

**Increment a Value by Row:**

**=Expression + (([ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)()-number of rows above first formula )\*[steps])**

**Increment a Value by Column:**

**=Expression + (([COLUMN](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)()-number of columns on left of first formula )\*[steps])**

**Arguments Explanation:**

**Expression –** This is the absolute value with which you want to increment the following values.

**number of rows above first formula –** For instance, if you are entering this formula in **cell C3** hen the number of rows above this formula will be **2**.

**number of columns on left of first formula**  **– ** If you are entering this first formula in **cell B4** then the number of columns on the left of this formula will be **1**.

**[steps] – **It is an **optional** one. This is the number of steps that you want to **jump in the next increment**.

## Increment Values by Row:

Let’s see some examples below to understand how it works.

**Increment the data every one step:**

- To do this, you need to **enter the expression value** in any cell. In the below image, you can see the expression in **Cell C1**.

![Enter the expression](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_ZHL5dxtnYW.png)<figcaption id="caption-attachment-22453">Enter the expression</figcaption>

- Now, you need to **enter the below-given formula** in **cell B4** and hit the **Enter** key.

**=$C$1&(ROW()-3)**

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_2XuLoIJu1o.png)<figcaption id="caption-attachment-22454">Enter the formula</figcaption>

- Then, just **drag the cell down** to fill the remaining cells.
- Finally, you will get the result as shown in the below image.

![Output](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_igZW9bX51l.png)<figcaption id="caption-attachment-22455">Output</figcaption>

**Increment the data every two steps:**

- If you want to increment the data by every two steps, then do as follows.
- Firstly, you have to **enter the expression value** in any cell ( **here we enter in cell C1** ) in the spreadsheet.

![Enter the expression](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_ZHL5dxtnYW.png)<figcaption id="caption-attachment-22453">Enter the expression</figcaption>

- Now, you need to **enter** the following **formula** in **cell B4**.

**=$C$1&((ROW()-3)\*2)**

- After entering the formula, **press** the **Enter** key.

![Hit the Enter key](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_UyUcHqj0xT.png)<figcaption id="caption-attachment-22457">Hit the Enter key</figcaption>

- Now, **drag that cell down** to fill the remaining cells to get the result as shown in the below screenshot.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_NKPggo6kGq.png)<figcaption id="caption-attachment-22460">Result</figcaption>

## Steps to Increment Values by Column:

You have to follow the instructions carefully to achieve this task quickly.

**Increment the data every one step:**

- To do this, you need to **enter the expression value** in any cell.

![Enter the Expression value](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_49SwrIiSJM.png)<figcaption id="caption-attachment-22463">Enter the Expression value</figcaption>

- Now, you need to enter the below-given formula in **cell B4** and hit the **Enter** key.

**=$C$1&(Column()-1)**

- After entering the formula, hit the **Enter** button.
- At last, you will get the result as shown in the below image.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_gt6kpMLUOl.png)<figcaption id="caption-attachment-22464">Enter the formula</figcaption>

**Alternative with SEQUENCE Function:**

**Note:** The **SEQUENCE function** is only available in **Excel 365** and **2019**.

- First, you need to **enter the expression** in **cell C1** as shown in the below image.

![Enter the expression](https://geekexcel.com/wp-content/uploads/2021/03/chrome_9Lz2DzI9Pj.png)<figcaption id="caption-attachment-22465">Enter the expression</figcaption>

- Then you have to enter the formula in **cell B4** and press the **Enter** key.

**=$C$1\*SEQUENCE(100)**

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/chrome_FX5SGKjXcy.png)<figcaption id="caption-attachment-22467">Enter the formula</figcaption>

- Using this function, you will not need to copy down the formula, it will automatically create 100 increment values.
- Now, you will get the result as shown in the below figure.

![Output](https://geekexcel.com/wp-content/uploads/2021/03/chrome_UPhGUDZJBH.png)<figcaption id="caption-attachment-22468">Output</figcaption>

## Wind-Up:

In this article, we have illustrated the steps to **increment a value by row or column in Excel Office 365**. If you like this article, then don’t forget to share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**

#### Read Next:

- [Excel Formulas to Apply Conditional Formatting For If Column is Blank!!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-for-if-column-is-blank/)
- [Split Data into Multiple Worksheets with Set of Rows using Macros (VBA) in Excel!!](https://geekexcel.com/split-data-into-multiple-worksheets-with-set-of-rows-using-macros-vba-in-excel/)