? -> Can I multiply a group of cells by a value so that each cell increases by that value?

[DH]

I have a price menu, with unique prices in each cell
from A1 to F20.

Is there a way to select all the cells and then multiply by 10%,
so that each price would show a 10% increase?

Thanks
DH

 

[Peo Sjoblom]

For auditing or safety purposes in case you/somebody apply it incorrectly
there might be a reason to keep the originals, then you could just do

=A1*1.1
and copy down and across in another area using the mouse, otherwise you
could put 1.1 in an empty cell, copy it, select the table and do edit>paste
special and select multiply

 

[DH]

Thanks for the replies...

I got exactly what I needed!

DH