Changing multiple cells by the same percentage

[slindsay]

I have to make a price change, it involves approx. 50 different cells. They
will all increase by 9.25%. Is there a function or a formula that I can use
to change the cells all at once without having to go through and change each
individually?

 

[Per Jessen]

Hi

In an unused cell enter 1.0925 then copy the cell. Select the price cells,
then goto Edit > Paste Special > Select Multiply > OK

Regards,
Per

 

[T. Valko]

Here's a short video that demonstrates this:

http://www.contextures.com/xlVideos03.html#Paste2003