How to reduce all numbers in spreadsheet by a percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top