When you're making a formula in Excel how do you refer to the row that the formula is in?
2006-11-02 15:04:28 · 7 answers · asked by notsohated 1 in Computers & Internet ➔ Software
=ROW() will do the trick
2006-11-03 00:22:50 · answer #1 · answered by O Caçador 6 · 0⤊ 0⤋
Place the cursor in the cell that you want the data to appear. You must know the acronym for the formula for example =average(highlight the cells you want to average) and hit enter. Make sure you enter the right and left brackets.
2006-11-02 23:14:20 · answer #2 · answered by EM-water2 6 · 0⤊ 0⤋
just click the cell you want to use or the row or the column, then insert the formula. for all kinds of tips and tricks for excel goto
http://techrepublic.com.com/1200-10877-5735748.html
2006-11-02 23:12:15 · answer #3 · answered by mystykal s 2 · 0⤊ 0⤋
It depends if you know then use the (:) semicolons to seperate or just hit the (=) edit formula and highlight what you want in the formula. Any which one works just the same.
2006-11-02 23:32:46 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Function Cell. If you drag it horizontally or vertically it will automatically adopt the formula in those cells.
2006-11-02 23:13:36 · answer #5 · answered by ngina 5 · 0⤊ 0⤋
if it is in C then =C1:C99999 ---if you copy that to another row that will change automaticly
2006-11-02 23:11:24 · answer #6 · answered by no one 3 · 0⤊ 0⤋
Can you rephrase the question? I can't tell what you're asking....
2006-11-02 23:11:51 · answer #7 · answered by OK yeah well whatever 4 · 0⤊ 0⤋