Add $1 to a long row of #'s

[Par]

I have 150 numbers in a row C22 to C172. How do I add $1 to all those numbers
without creating a new row?

 

[Gary''s Student]

In an un-used cell enter 1
Select C2 thru C172 and
Paste/Special and check Add.

 

[Mike H]

Hi,

Put a 1 in any cell and copy it
Select your range of numbers C22 - C172 then
Edit|Paste Special - select ADD - OK

Delete the 1 you put in the spare cell

Mike

 

[David Biddulph]

C22 to C172 is a column, not a row
That range has 151 cells, not 150
Put 1 in a spare cell, copy it, then select the range of cells, and Edit/
Paste Special/ Add