Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to increase cell value by 1 in Google Sheets

## How To Increase Cell Value By 1 in Google Sheets

Incrementing a cell value by 1 is a common task when working with data in Google Sheets. For example, an incrementing range of numbers can be used to keep track of the number of items in a list. While it is certainly possible to set an incrementing value manually, it can be tedious if you have a large dataset

Fortunately, Google Sheets makes it fairly easy to increase cell values by 1. This can be done using a simple formula, or by using the AutoFill tool.

In this guide, we will show you how to increase cell values by 1 in Google Sheets.

## How To Increment by 1 Automatically in Google Sheets

Here’s how to automatically increment by 1 in Google Sheets.

### Step 1

First, enter a numerical value as the starting cell of the incrementing range.

In this example, we’ll start the range with a value of 1.

### Step 2

In the cell right below it, add the next integer that follows the chosen starting cell.

In this case, we’ll input a value of 2.

### Step 3

Select both numbers using your cursor.

### Step 4

Use your cursor to drag the blue square down until you reach a desired number of cells.

### Step 5

Alternatively, we can use a Google Sheets formula to increment a value by 1.

We’ll first start with an initial value of 100000001.

### Step 6

In the cell below the initial value, add a formula that add 1 to the value of the cell above it.

### Step 7

Hit the **Enter** key to evaluate the formula.

### Step 8

Use the Fill Handle tool to copy the formula down the column.

Since the formula keeps adding 1 to the cell above it, each cell should increment by 1 for each succeeding copy of the formula.

## Summary

This guide should be everything you need to increment cell values by 1 in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.

#### More ways to use calculations in Google Sheets:

- Standard Deviation
- Average
- Time
- Variance
- Age
- Percentage
- Standard Error
- Sum
- Difference
- P Value
- Z Score
- Dates
- Days Between Dates
- How To Find Slope
- Correlation
- Correlation Coefficient
- Find Difference Between Two Columns
- Find Highest Value
- Trendline Equation
- Find Slope
- Find Y Intercept
- Keep A Running Total
- Regression
- How To Tally