Thread: Adding the same number to each cell in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Adding the same number to each cell in a column
One way:

Enter 1.5 in a blank cell. Copy the cell. Select the cells to be added
to. Choose Edit/Paste Special, selecting the Add and Values radio
buttons.


In article ,
BrendaC wrote:

I'm a new Excel user. How do I add the value 1.5 to each cell in a column?
Reply With QuoteReply With Quote