Add $1 to a long row of #'s

P

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?
 
G

Gary''s Student

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

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
 
D

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
 
Top