Calculating over Multiple Columns

  • Thread starter Thread starter Ken
  • Start date Start date
K

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?
 
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
---
 
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.
 
Back
Top