8 ms·
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: ht
by tichiian 2y ago
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 https://www.youtube.com/watch?v=JxBg4sMusIg
- falcor84 2y agoBaby 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 2y agoBaby’s lack object persistence and a formed theory of mind, seems to check out.
- mhh__ 2y agoNever 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 2y agoAgreed! Hard cell references should rarely be used. Names for metadata variables (eg. Current_Month) and tables for datasets.
- tichiian 2y agoYes. 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.