Increase prices accross the board

[Linda]

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.

[Bob Phillips]

Linda

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


--

HTH

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


"Linda" <Linda@discussions.microsoft.com> wrote in message
news:50AD542C-6AED-4550-A871-AE2F9C558BCA@microsoft.com...
> 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.
>

[Chip Pearson]

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" <Linda@discussions.microsoft.com> wrote in message
news:50AD542C-6AED-4550-A871-AE2F9C558BCA@microsoft.com...
>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.
>