Calculating over Multiple Columns

[Ken]

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?

 

[Max]

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

Paste special > Divide

Enter in any empty cell: 3.3
Copy that cell
Select the range, right-click > paste special > check "Divide" > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,500 Files:361 Subscribers:58
xdemechanik
---

 

[David Biddulph]

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.

 

[Ken]

Obvious thanks