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.


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


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.





Report an Issue

screenshot of the current page

Screenshot loading...