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.
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.
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.
Select both numbers using your cursor.
Use your cursor to drag the blue square down until you reach a desired number of cells.
Alternatively, we can use a Google Sheets formula to increment a value by 1.
We’ll first start with an initial value of 100000001.
In the cell below the initial value, add a formula that add 1 to the value of the cell above it.
Hit the Enter key to evaluate the formula.
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.
More ways to use calculations in Google Sheets:
- Standard Deviation
- Standard Error
- P Value
- Z Score
- Days Between Dates
- How To Find Slope
- Correlation Coefficient
- Find Difference Between Two Columns
- Find Highest Value
- Trendline Equation
- Find Slope
- Find Y Intercept
- Keep A Running Total
- How To Tally