Saturday, October 27, 2012

How to Use Variables in Excel


1. Select the cell with the result that you want to declare as a variable.
2. Click on the Formulas menu item, and choose Names (Excel 2003 and earlier) or Name Manager (Excel 2007 and Excel 2010).
3. Enter the name of the variable in the dialog that comes up. From this point on, in this workbook, you'll be able to refer to the contents of this cell by entering its name.

Blogger news