Thread: Add $1 to a long row of #'s
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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?


Reply With QuoteReply With Quote