Spreadsheet named ranges
2014-10-04 16:19:00 +0000 - Written by Carl Burks
A friend of mine had never seen a named range in a spreadsheet so I thought I would do a little public service announcement. Named ranges are a great feature I like to use in my spreadsheets to make reading and writing formulas easier. Instead of reference a cell by the column letter and the row number a named range lets you assign a name to the cell(s). You could just have looked them up on Google and found the Wikipedia article:
Google Docs supports this feature:
Apache Open Office supports this feature:
Lotus 1-2-3 which recently IBM ended support for the product, was first for named ranges.
A lesser known spreadsheet program called Excel also supports them.