How To Add or Subtract A Set Amount To All Cells In A Column Using Google Sheets

This is commonly searched for online only to find a solution using Excel by Microsoft. You’ve also probably seen where people are trying to show you how to get the SUM of cells etc…

This is NOT that method. This method is used for adding one specific number amount to all the cells or just certain ones.

Example: You’ve got a chart that looks like this:

And you’re wanting to add 10 to each cell block for example. You can always do this manually but if you’ve got over 10 cell blocks, that’s just ridiculous.

So, what you’ll need to do is use this formula: =ArrayFormula(A1:A10+10)

You simply copy and paste the code into the first cell of any column besides the one you’re wanting to use. I’m using B1 in the screenshot above. You can use whatever cell you’d like.

Here is what it will look when implementing the code (remember, I’m pasting this code into…