Names and Tables

It is often desirable to define a group of data as a unified collection. One way to do this is to assign a name to a cell range. As mentioned in Excel Spreadsheets, this may be done by highlighting the range, right clicking and choosing Name a Range … from the list of options displayed.

An alternative approach is to highlight the range and simply enter the name in the Name Box. You can also list and edit range names via Formulas > Defined Names|Name Manager.

Care should be taken not to assign a name which could be confused with a column label. E.g., for a range of data about the state of Arizona it might be tempting to use the name AZ. The danger here is that AZ can be confused with the column label AZ.

A range can also be defined as a table. You create a table via Insert > Tables|Table. A particular type of table called a pivot table is created and managed via Insert > Tables|PivotTable. Although these tables can be quite useful, we won’t  employ them further in this website.

Leave a Reply

Your email address will not be published. Required fields are marked *