How To Use Labels As References In MS Excel XP

Filed under: Excel, How To 
  1. Select Tools menu and then click Options.
  2. Click the Calculation tab.
  3. Look for Workbook options and check Accept labels in formulas option.
  4. To re-enter a formula that used a label before this option was set, click 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.