ExcelBanter - How to reduce all numbers in spreadsheet by a percentage

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to reduce all numbers in spreadsheet by a percentage (https://www.excelbanter.com/new-users-excel/149064-how-reduce-all-numbers-spreadsheet-percentage.html)

stubarlow

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

JE McGimpsey

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

All times are GMT +1. The time now is 12:48 PM.