Excel has named cell ranges. So instead of =A5*A6 you could have =interest*principal You can create them easily too -- can name the individually, can as

Excel has named cell ranges. So instead of =A5*A6 you could have =interest*principal You can create them easily too -- can name the individually, can assign names from existing tables and so on. You can have constants too, that is, they don't have to point to any cell [1]. It is a godsend when working with bigger tables having lots of formulas. [1] https://www.ablebits.com/office-addins-blog/2017/07/11/excel-name-named-range-define-use/#named-constant https://www.ablebits.com/office-addins-blog/2017/07/11/excel... [2]https://www.contextures.com/xlNames01.html https://www.contextures.com/xlNames01.html