Increasing a cell value by a certain number

[anestojaga]

Hello! It's my first time posting here and I don't know if this question has already been asked. If that is the case, I apologize for cramping up the threads and I would be grateful if you'd provide a link to the answer to my question.

My situation is this: I have a spreadsheet that consist of 30-something rows and about a dozen columns. All but one of those columns contain certain numerical values - an integer, to be precise. Now, my problem is that these (real life) values change from time to time and I need to update my spreadsheet accordingly. This wasn't a tall task at first, but now the numbers have reached four digits and it's becoming increasingly time-consuming to add them all up. For example, a cell value is 3568 and I have to add 74 to it. Now, of course I can do the math in my head and then just type in the result... but I don't want the hassle. I wan't to save time and do my work as quickly as possible.

So, I would like to know if there was a way to do this more quickly - a built-in function, a macro I need to create, or something? I would be very grateful if someone offered a working solution. Thanks!

 

[mumps]

Which column does not contain numbers? I assume that you want to add a certain number to all the cells except those in that one column. Is that correct?

 

[jeffreybrown]

Hello & Welcome to the forum,

I suppose what's easy is relative. You're given one example with is pretty easily solved.

Increase Number

• Enter 74 in some cell >> Highlight cell >> Right click >> Copy
• Highlight the 3568 >> Right click >> Paste Special >> Paste: Values >> Operation: Add >> OK

 

[anestojaga]

The first column contains text, not numbers. Yes, I want to add a number to all the other cells, but it's not the same number being added to all of them.

 

[anestojaga]

Thank you! Well, yes, I suppose it turned out very easy, which is even better! This is all I needed, thank you for your help.

 

[jeffreybrown]

Thank you! Well, yes, I suppose it turned out very easy, which is even better! This is all I needed, thank you for your help.

I suppose you possibly mean what is in post #3. Glad it works for you and you're welcome.

 

[mumps]

Just to expand on Jeff's solution, his method will work on multiple cells in case you have to add the same number to more than one cell. As he suggested, put the number you want to add in any cell, right click to copy it, while holding down the CRTL key, click all the cells to which you want to add the number, right click on any of the selected cells and click Paste Special >> Paste: Values >> Operation: Add >> OK.