2006-10-30 22:50:07 · 3 answers · asked by Fuzail Shams 1 in Computers & Internet ➔ Software
There are 2 addressing techniques in Excel.
Absolute addressing: For example $A$5. When you COPY or when you EDIT | FILL DOWN (FILL RIGHT) such an address, it never changes.
Relative addressing: For example A5. When you EDIT | FILL DOWN such an address then you get the refernces A6, A7, A8, ... in subsequent cells. If you EDIT | FILL RIGHT you get B5, C5, D5, ... etc in adjacent cells.
You can mix the two ways as for example in A$5. This means that you lock the row reference but you leave the column reference free (i.e. relative), or vice versa.
2006-10-30 23:05:17 · answer #1 · answered by fanis t 2 · 0⤊ 0⤋
there are 3 addressing techniques:
1. relative addressing syetm: the cell address changes when the destination cell is changes. e.g SUM(b3:c4)
2. absoulte: the cell address never changes. e.g. $a$2+$g$3
3. mixed referncing: a combination of both. e.g. (g4*g5)+$d$1
2006-10-30 23:47:18 · answer #2 · answered by sushobhan 6 · 0⤊ 0⤋
i think there are three
absolute
refernced
mixed
2006-10-30 22:55:05 · answer #3 · answered by sweetboy 3 · 2⤊ 0⤋