View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Adding the same number to each cell in a column

Try this:

Enter 1.5 in a blank cell and select that cell

From the Excel main menu:
<edit<copy

Next....select the cells you want to add the 1.5 to
Then...<edit<paste special....Check: Add
Click [OK]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BrendaC" wrote:

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