- Messages
- 373
- Reaction score
- 125
- Points
- 53
I wrote it almost like what you did:in the theoneforF4iforgotthephraserelativereferencingitdidntpopupinmymindinsteadisaidthatthe 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.