| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!! |
|
#2
|
|||
|
|||
|
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!! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
| How do I set up some cells in a spreadsheet to be a required fiel. | Excel Worksheet Functions | |||
| Make an Access Database out of Excel spreadsheet | New Users to Excel | |||
| I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
| how do i make a row flash in excel spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
