Operator function across a range of cells

D

Dublevay

Is there any way that I can simply select a range of cells, and then divide
the value of them all by two? I'm ideally after a way to do this without
using VBA.

Thanks

JW
 
J

J.E. McGimpsey

Put 2 in an empty cell. Copy the cell.

Select your range. Choose Edit/Paste Special, selecting the Values
and Divide radio buttons. Click OK.

Clear the cell in step 1.
 
D

Dublevay

Wow! As simple as that. Many thanks!

JW


J.E. McGimpsey said:
Put 2 in an empty cell. Copy the cell.

Select your range. Choose Edit/Paste Special, selecting the Values
and Divide radio buttons. Click OK.

Clear the cell in step 1.
Click to expand...
 
Top