Adding the same number to each cell in a column
 

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

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?

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?

Adding the same number to each cell in a column
 

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 specialadd and ok
out.

Mike Rogers

"BrendaC" wrote:

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

Adding the same number to each cell in a column
 

Thanks so much for the great help - it worked!

"Ron Coderre" wrote:

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?

Adding the same number to each cell in a column
 

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

"JE McGimpsey" wrote:

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?

Adding the same number to each cell in a column
 

Thanks for taking the time to help - it worked!

"Mike Rogers" wrote:

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 specialadd and ok
out.

Mike Rogers

"BrendaC" wrote:

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

Adding the same number to each cell in a column
 

BrendaC

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

Mike Rogers



"BrendaC" wrote:

Thanks for taking the time to help - it worked!

"Mike Rogers" wrote:

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 specialadd and ok
out.

Mike Rogers

"BrendaC" wrote:

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