Updating price sheets

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!

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thanks Niek, that worked perfectly.