Add $1 to a long row of #'s
 

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

Add $1 to a long row of #'s
 

In an un-used cell enter 1
Select C2 thru C172 and
Paste/Special and check Add.
--
Gary''s Student - gsnu200844


"Par" wrote:

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

Add $1 to a long row of #'s
 

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

"Par" wrote:

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

Add $1 to a long row of #'s
 

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
--
David Biddulph

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