Spreadsheets
  1. Home
  2. Computing & Technology
  3. Spreadsheets

Using Labels in Excel Formulas and Functions

By , About.com Guide

See More About:

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.
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Spreadsheets
  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Excel 2003 Functions
  6. Using Labels in Excel Functions and Formulas - Summary of Steps for Using Labels in Excel Formulas and Functions

©2009 About.com, a part of The New York Times Company.

All rights reserved.