View Single Post
  #1   Report Post  
Chip Pearson
 
Posts: n/a
Default

Enter 1.04 in to some empty cell and copy that cell. Then select
your prices, go to the Edit menu, and choose Paste Special. In
that dialog, choose the Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Linda" wrote in message
...
I have a worksheet which contains columns of part numbers and
prices. Is
there a way to increase the prices in a column by 4 percent or
do I have to
go line by line?

Thank You in advance.