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?
|