Allow aliases to be assigned to specific cells, then display those aliases in formulas that refer to them
I'd like to be able to assign aliases to specific cells, then (optionally) display those aliases in formulas that refer to them. This would be akin to assigning variable names to those contents, so that it's easier to track what is being referred to in formulas which aren't anywhere near them in the spreadsheet (and make it easier to understand the spreadsheet when I'm first being exposed to it).
Kyle Hamilton commented
@skylos D4-D20 have their own semantics. The formula in E5 would have its own semantic. They should be labeled separately.
This is akin to having different variables in a program block, that you calculate from others. You don't name the one you calculated from others as what you calculated it from, you name it as what it semantically is.
This is like assigning semantic meaning to particular blocks of a spreadsheet. But the model of a spreadsheet is 2d grid, assigning semantic meanings to particular cells and ranges of cells is an adaptation for human organization and comprehension.
The particular thought is if you had a cell E5 as part of a block of cells doing a VLOOKUP from D 4-D20, are you labeling the velookup block with its semantic meaning, or are you annotating E5 - or both - This is the balance-to-rate vlookup in the column for rates? how does that look in the tagging for semantic view?