| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing a whole Spreadsheet by a percent
How do you increase every number in a spreadsheet by a certain percent with
out changing each one individually? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increasing a whole Spreadsheet by a percent
Nicole
Enter 1.1 in an empty cell. Copy that cell and select all the other cells. EditPaste SpecialMultiplyOKEsc All cells will be increased by 10% Clear the cell with the 1.1 Adjust the number to suit. Gord Dibben MS Excel MVP On Tue, 10 Oct 2006 12:41:02 -0700, Nicole wrote: How do you increase every number in a spreadsheet by a certain percent with out changing each one individually? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
| How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
| Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
| Increasing the Default size of a spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
Linear Mode
