How to Use Labels as References in MS Excel 2003

June 17, 2008 by
Filed under: Excel 

To Use Labels as References in MS Excel 2003:

Note: This option must be set first, otherwise formulas that use labels need to be re-entered.

  1. From the Tools menu, click Options.
  2. Select the Calculation tab.
  3. Under Workbook options, click Accept labels in formulas.
  4. use labels as references
  5. To re-enter a formula that used a label before this option was set, select the cell containing the formula, press F2, and then press ENTER on the keyboard.


Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.