Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reduce all numbers in spreadsheet by a percentage
I have a spreadsheet and without having to type every thing out again I would
like to reduce all the numbers by 50% I am using office 2007 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reduce all numbers in spreadsheet by a percentage
One way:
Enter 2 in an empty cell. Copy the cell. Select the numbers to reduce. Choose Edit/Paste Special, selecting the Values and Divide radio buttons. Click OK. In article , stubarlow wrote: I have a spreadsheet and without having to type every thing out again I would like to reduce all the numbers by 50% I am using office 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage formula in Excel spreadsheet | New Users to Excel | |||
How do I reduce the number of lines in a spreadsheet? | New Users to Excel | |||
excel function reduce and increase numbers | Excel Worksheet Functions | |||
How to Reduce Spreadsheet Size and Speed | Excel Worksheet Functions | |||
How do I add a percentage to a row of numbers | Excel Discussion (Misc queries) |