Adding the same number to each cell in a column

[BrendaC]

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

 

[JE McGimpsey]

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.

 

[Ron Coderre]

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

 

[Mike Rogers]

BrendaC

In an empty cell some where place 1.5. Copy that cell .... select the
column you want to add to and right click, select paste special>add and ok
out.

Mike Rogers

 

[BrendaC]

Thanks so much for the great help - it worked!

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

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

 

[BrendaC]

Thank you very much - it was easy to do and worked!

 

[BrendaC]

Thanks for taking the time to help - it worked!

BrendaC

In an empty cell some where place 1.5. Copy that cell .... select the
column you want to add to and right click, select paste special>add and ok
out.

Mike Rogers

 

[Mike Rogers]

BrendaC

I am glad it worked for you. Thanks for posting back.

Mike Rogers