How To Use Labels As References In MS Excel XP

August 18, 2007 by
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.

Comments

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.