Questions and answers
259How do I increment the data values in a column of data in Excel?
In Excel 2013 and Excel 2016 this is achieved by creating a formula:
- If required, insert a new column to the right of your original data.
- If your original data is in column C and starts in cell C3. In cell D3, enter a formula to calculate the new value:
Example: =C3+20
If increasing by a percentage, say 5%, the formula would be entered like this:
Example: =C3*1.05 - Press [ENTER].
- Use the Fill-Handle to copy this formula down the new column.
If you wish to change the results in a single cell to static data click into the formula bar, press F9 and Enter.
To change the whole column to static data copy the data to another column using 'Paste - values only'.
You can also increment values using the fill drop down - once you have selected the starting cell you can fill in any direction by selecting the cells you want to be filled or by using the series options you can specify step values and different types of growth.
Help us to improve this answer
Please suggest an improvement
(login needed, link opens in new window)
Your views are welcome and will help other readers of this page.