Multiply entire column...

[ajx22]

I haven't worked with Excel for a number of years...

I have an Excel price list...all prices are reflecting my COST...

If there not a way to tell the entire column to display as "content o
cell x 2.5"?

I know that I can manually enter it into each cell ( A1*2.5 ) ( A2*2.
) etc...but is there not a way to get it to do the entire column??

Thanks in advance

 

[DDM]

Ajx22, enter 2.5 in a cell somewhere and copy it. Then select all the cells
in Column A (you can click the column heading) and Edit > Paste Special >
Multiply > OK.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Don Guillett]

A macro method

Sub multiplycolumn()
For Each c In Range("G2:g12")
c.Value = c.Value * 2
Next
End Sub

 

[ajx22]

Thank you GREATLY!!!

You have just saved me HOURS of work!!



Thanks again!

 

[Don Guillett]

glad to help