Increase prices accross the board
 

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.

Linda

Select a separate cell and put 1.04 in that cell, and copy the cell
Select all of your target cells
Goto EditPasteSpecial
Click the Multiply buttom
OK


--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.

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.