make my spreadsheet at 10% to all cells
 

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!!

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

-----Original Message-----
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!!
.