when I expand the fomula, how could I use a certain cell (not relative position)
2006-12-29 02:13:37 · 5 answers · asked by saeed f 1 in Computers & Internet ➔ Software
Press F4 while typing the formula:
Press F4 once and your formula will be fixed at rows & columns. i.e. =+$A$1
Press F4 twice and your formula will be fixed on rows only, i.e =+A$1
Press F4 thrice and your formula will be fixed on columns only, i.e =+$A1
2006-12-29 02:21:53 · answer #1 · answered by robin 2 · 1⤊ 0⤋
When you are writing out your formula, click on that particular cell to include it in your operations.
For example, if you want all cells in Column D to be multipled by B3, you can do D1*B3 and then expand the formula down the rest of the column.
2006-12-29 10:16:30 · answer #2 · answered by penpallermel 6 · 1⤊ 0⤋
Put a dollar sign in front of your cell value, ie. =sum($A1+$A2)
2006-12-29 10:19:19 · answer #3 · answered by Kokopelli 6 · 0⤊ 0⤋
start typing in the formula bar with the = keyword
2006-12-29 10:15:49 · answer #4 · answered by karthik 2 · 0⤊ 1⤋
Use the $ to 'anchor' the cell reference:
I.e. use =$E$5
instead of =E5
2006-12-29 10:15:22 · answer #5 · answered by Robin the Electrocuted 5 · 1⤊ 1⤋