Skip to main content
MindTouch Success Center

Label lists and tables in Excel

This article is an Excel resource that explains how to label your Excel lists (arrays) and data tables.

Why is labeling important in Excel


While this isn't a necessary task for many Excel applications, proper labeling adds ease, efficiency, and clarity to your Excel functions.  This becomes increasingly pertinent when referencing multiple data sheets and building complex functions.

Prerequisites


This article assumes the following:

  • You are using Microsoft Excel.

Add labels to a list (array)


In this demonstration, I will be adding the label, SITEHISTORY_TYPE, to the Type column of the MindTouch Site History report.

  1. Highlight an entire list. In this example, we highlight the TYPE list in the sitehistory.csv sheet.

  1. Click into the text box on the top left-hand side of the screen, currently referencing the first highlighted cell D2.

  1. Type SITEHISTORY_TYPE into the textbox. The label references both the sheet name and the field.
  2. Press ENTER to save.

Add labels to a data table


The process of adding a label to a data table is virtually identical to adding a label to a list.

In this demonstration, I will be adding the label, SITEHISTORY, to the entire data table of the MindTouch Site History report.

  1. Highlight the entire data table in the sitehistory.csv sheet.

  1. Click into the text box on the top left-hand side of the screen, currently referencing the first highlighted cell A2.

  1. Type SITEHISTORY into the textbox. The label references the sheet name. If this were a subsection of the data table you might want to add an additional header, much like we did for the list label.
  2. Press ENTER to save.

  • Was this article helpful?