How to Use Tab Names as Variables in Excel. When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window.

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

2. From the Formulas tab, click Define Name. 3. Notice that Excel has already entered the column/field name of the range you highlighted (even though that cell was not included in your range).

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Want to name a range in Microsoft Excel? This post shows how to edit or create Named Ranges in Excel using four methods.