- Messages
- 373
- Reaction score
- 125
- Points
- 53
I wrote it almost like what you did:in the $ the one for F4 i forgot the phrase relative referencing it didnt pop up in my mind instead i said that the $ sign appear when we use F4 which keep the column or data chosen fixed & not moving downward when the formula is pasted onto following cells ?? so is this right ... is it reasonable as an answer?
The functions will always refer to the absolute ranged cells. So when we drag the formula downwards, the cells refered will still be the same.
I wrote it much more detailed but forgot lol.