make my spreadsheet at 10% to all cells

[jenshakay1972]

I have made a price spreadsheet that we use in the office, now my boss wants
me change all the prices by adding 10% to all numbers. When I set up the
spreadsheet, I just typed in the numbers, I did not use any formulas. I
cannot figure out how to do this, and I really do not want to change each
cell one by one.
HELP!!

 

[Jason Morin]

You can do it all in one pass:

1. Type 1.1 into an open cell.
2. Copy that cell.
3. Select all the prices.
4. Go to Edit > Paste Special. Click Multiply. OK.

HTH
Jason
Atlanta, GA