How to Use Variables in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

The Windows spreadsheet program Excel can use functions that refer to specific cell references in the same way that a formal programming uses variables. An example of using a variable in Excel would be to take the region-by-region total sales figures, put them in specific cells, and refer to those cells for additional analysis. In all cases, when using variables in Excel, the cells should be set up so they have the results you want in them.

Advertisement

Step 1

Select the cell with the result that you want to declare as a variable.

Video of the Day

Step 2

Click on the Formulas menu item, and choose Names (Excel 2003 and earlier) or Name Manager (Excel 2007 and Excel 2010).

Advertisement

Step 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.

Advertisement

Video of the Day

Advertisement

Advertisement

references