[tichiian]

That A1 mode is Excel "Baby-Mode", you can switch to R1C1 mode in settings. Things are far easier then, and more sane.

His Excel-lence also recommends this: https://www.youtube.com/watch?v=JxBg4sMusIg

[falcor84]

Baby mode?! As a full grown adult, I find the cognitive load of the base 26 arithmetic of "what column is an offset of 8 to the right of AW" to be exactly what I needed to fully forget about what I came there to do in the first place

[epcoa]

Baby’s lack object persistence and a formed theory of mind, seems to check out.

[mhh__]

Never seen anyone actually use this.

The "real" answer is to use names and tables. That and generally not having data flying up down left and right.

[steine65]

Agreed! Hard cell references should rarely be used. Names for metadata variables (eg. Current_Month) and tables for datasets.

[tichiian]

Yes. But many parts of excel don't support those. E.g. conditional formatting just doesn't deal with names.

Also, when you need names, it is a sign to reach for a proper programming enviroment like Delphi or Lazarus.