1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.




The term label has a number of meanings in spreadsheet programs.

  1. A label most often refers to a text entry such as a heading used to identify a column of data.

  2. The term is also used to refer to the headings and titles in charts - such as the horizontal and vertical axes titles.

  3. In versions of Excel up to Excel 2003, labels could also be used in formulas to identify a range of data.

    These labels were the column or row headings in the cell immediately above or to the right of the data they identified.

    Using labels in formulas was very similar to using named ranges.

    Named ranges, which can still be used in the newer versions of Excel, have the advantage of allowing you to define a name for any cell or group of cells in a worksheet regardless of location.

  4. In the past, the term label was used to define a type of data used in spreadsheet programs.

    This use has been largely replaced by the term text data although certain functions in Excel, such as the CELL function still make reference to label as a type of data.

©2014 About.com. All rights reserved.