How To Increase Cell Value By 1 in Google Sheets

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.


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.