Format an empty cell as Number. Enter the number 1.05. Edit>Copy. Select
your prices. Edit>Paste special, check Multiply.

--
Kind regards,

Niek Otten

"-Lawless" <Lawless.22o35y_1138993200.6474@excelforum-nospam.com> wrote in
message news:Lawless.22o35y_1138993200.6474@excelforum-nospam.com...
>
> Well as the topic implies, I'm trying to update some price sheets
> created in Excel.
>
> I have several cells with prices in them and I'm trying to increase all
> of the cells by 5%.
>
> Can someone tell me the easiest way to do this?
>
> I'm sure I've done this before but I'm at a loss.
>
> Thanks!
>
>
> --
> -Lawless
> ------------------------------------------------------------------------
> -Lawless's Profile:
> http://www.excelforum.com/member.php...o&userid=31164
> View this thread: http://www.excelforum.com/showthread...hreadid=508263
>