Operator function across a range of cells

  • Thread starter Thread starter Dublevay
  • Start date Start date
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
 
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.
 
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...
 
Back
Top