Put 3.3 in a spare cell.
Copy it
Select your range A1:C3
Edit/ Paste Special/ Divide

Now you can delete the 3.3 from the spare cell.
--
David Biddulph

"Ken" wrote in message
...
I have a spreadsheet as follows

A B C
1 10 78 46
2 27 46 32
3 45 99 86

Is it possible to highlight all the cells and then divide by 3.3.

Currently I put a formula in D,E,F and then drag down. Can I avoid this
last
step and just highlight A,B.C and do some magic?