Forum Discussion
Is now the time to abandon the concept of relative referencing?
The default action when one clicks a cell whilst inputting a formula is for Excel to return a relative reference. That allows a user of legacy Excel to address the members of a list or array by drag...
I fully agree with Patrick2788 , any change in default behaviour which was for ages shall be done by option only. By option in user interface available for average user.
At the same time I won't be surprised if such option exists in registry.