How to Use Tab Names as Variables in Excel


If you are working in Microsoft's Excel spreadsheet program, then you may want to use key words as variables within your spreadsheet. Excel allows you to create several spreadsheets within one file that are separated by tabs. You can name these tabs individually. Type the name of the tab in the Excel variable boxes.

  • Open your Microsoft Excel spreadsheet.

  • Locate the tabs at the bottom right-hand corner of the page. You should have several, and they should be named. By default, they are named "Sheet 1," "Sheet 2" and "Sheet 3." To change the name of the tab, double-click on it, type a new name and click the next tab.

  • Click on the "FX" box on your toolbar. Type the name of your tab in the cell labeled A1. Press "Enter." Repeat Step 3 until all of your tab names have been entered into different cells.

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

  • How to Rename an Excel Worksheet

    An Excel file is called a "workbook." Each workbook can contain more than one worksheet, organized as tabs along the bottom of...

  • How to Change a Default File Name in Word

    When you are working with any sort of template in Microsoft Word 2003, you will notice that a default file name is...

  • How to Insert a Tab Name in a Cell

    Microsoft Excel is a type of productivity software created by Microsoft. Tabs, also referred to as sheets, are separate files that exist...

  • How to Change an ActiveSheet Name

    Microsoft Excel's VBA allows automation of many common functions. One of the more generally useful ones is renaming the active worksheet. A...

  • How to Use Excel 2010

    Excel 2010 is a type of spreadsheet software that is part of the Microsoft Office suite. Excel allows you to organize information,...

  • How Do I Display a Tab Name in a Cell in MS Excel?

    Getting Excel to show the name of a tab (or worksheet name) in a cell is useful for concatenating references to specific...

  • What Are Sheet Tabs?

    Sheet tabs allow you to switch back and forth between sheets in an Excel workbook. When you create an Excel document, or...

  • List of Tabs in Workbook

    Having tabs in an Excel workbook streamlines your work and makes it easier to use. It is particularly useful for work that...

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!