Multiply entire column...

  • Thread starter Thread starter ajx22
  • Start date Start date
A

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
 
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
 
A macro method

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