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.