Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating over Multiple Columns
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating over Multiple Columns
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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating over Multiple Columns
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating over Multiple Columns
Obvious thanks
"Ken" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating averages in sorted columns | Excel Discussion (Misc queries) | |||
Calculating Differences between columns in a Pivot Table | Excel Discussion (Misc queries) | |||
Calculating values in two columns based on a variable | Excel Discussion (Misc queries) | |||
calculating adjacent columns in a work schedule | Excel Worksheet Functions | |||
calculating adjacent columns in a work schedule | Excel Worksheet Functions |