Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make an entire column do the same calculation across a r.
Sort of going through all 140 rows and typing the formula individually, how
do I get data from two columns to average, or find diferences. I know how to do it manually but surely there is an easier way. The books all show how to work with columns but how do you work with multiple columns? |
#2
|
|||
|
|||
1) Type formula into one cell
2) Hit Enter (to make sure it works properly) 3) Go back and click on the cell you just entered the formula in. Now that cell is selected. 4) Place mouse over bottom right corner of cell (little black square) 4) Click and drag as far down as you want to copy the formula, and it will automatically paste the formula. Let me know if these direction were clear enough. "nitenurse" wrote: Sort of going through all 140 rows and typing the formula individually, how do I get data from two columns to average, or find diferences. I know how to do it manually but surely there is an easier way. The books all show how to work with columns but how do you work with multiple columns? |
#3
|
|||
|
|||
Hi
not sure exactly what you mean, but formulas can be copied & pasted or filled (move cursor over bottom right corner of the cell and you'll see a little +, hold down left mouse and drag down the column to "fill the formula down" - let mouse go)... alternatively, if you mean you are typing in C1 = A1-B1 and then in F1 = D1-E1 etc another alternative is to select all the cells you want to type in, using the CONTROL key and then (without clicking anywhere) type your first formula and then use CONTROL & ENTER to fill the formula into all selected cells. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "nitenurse" wrote in message ... Sort of going through all 140 rows and typing the formula individually, how do I get data from two columns to average, or find diferences. I know how to do it manually but surely there is an easier way. The books all show how to work with columns but how do you work with multiple columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change case in an entire column of text in Excel | Excel Worksheet Functions | |||
Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
My entire Excel SS is locked-up. I cannot make any changes in any | Excel Worksheet Functions | |||
How to add the same value to an entire column? | Excel Discussion (Misc queries) | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |