How to Use Labels as References in MS Excel 2003

by Jules
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
  4. 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.

Comments



Leave a Reply