1. Computing & Technology

Discuss in my forum

Using Labels in Excel Formulas and Functions

By , About.com Guide

5 of 5

Summary of Steps for Using Labels in Excel Formulas and Functions
Formula using a label in an Excel spreadsheet

Formula using a label in an Excel spreadsheet

© Ted French

Summary of the Steps

  1. Make sure the Accept labels in formulas option is turned on.

  2. Enter the label headings.

  3. Enter the data under or to the right of the labels.

  4. Enter the formulas or functions using labels, to indicate the data to include in the function or formula.

©2012 About.com. All rights reserved.

A part of The New York Times Company.