Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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



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


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


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.


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


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: