Saturday, October 4, 2014

Spreadsheet named ranges

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:
http://en.wikipedia.org/wiki/Spreadsheet#Named_cells

Google Docs supports this feature:
https://support.google.com/docs/answer/63175?hl=en

Apache Open Office supports this feature:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Associating_a_range_to_a_name

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.