How to Use Labels as References in MS Excel 2003

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.


Leave a Reply

You must be logged in to post a comment.