I have some cells that just have plain integer values and would like a way to add 1 to them all without having to manually do it in each cell. Sorry if this is really simple; I have little to no experience with spreadsheets.

1 Answer 1


Excel has a special paste option which lets you add a number, say 1, to all cells in the selected range. Sadly, Google Sheets doesn't have it: Where is Excel's Paste Special Operations in Google Sheets?

That means you'll have to perform multiple steps, with some temporary cells, to do this:

  1. Create a cell with a formula like this one: =A1+1

    enter image description here

  2. Use the autofill function, by double clicking the little square in the right corner or by dragging it down. Select all newly created cells:

    enter image description here

  3. Select the original cells, and choose 'Paste values only' from the Edit → Paste special menu:

    enter image description here

  4. That increases the values of the cells by one. You can now remove the temporary cells.

    enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.