Excel Reference Tab Name

Click on the tab for sheet1 and in cell b2 enter the following formula.

Excel reference tab name. When you create an excel table excel creates a default table name table1 table2 and so on but you can change the table name to make it more meaningful. Cell retrieves the workbook name and sheet and the mid and find functions are used to extract just the sheet name. Sheet1 and followed by an exclamation mark before we mention the cell address and cell address is b2. Go to the cell which you want to reference the current sheet tab name please enter tabname and then press the enterkey.

Reference the current sheet tab name in cell with kutools for excel. In case of single cell worksheet name and cell address i e. So in order to reference an excel cell or range of cells from another sheet we need to get a worksheet name first i e. The mid function then extracts up to the next 32 characters.

Once you hit enter the formula will evaluate and the cell will show the word orange. To get the name of the current worksheet i e. Current tab you can use a formula based on the cell function. Reference tab name with a formula to reference a tab name in a cell with a formula in excel you can create a formula based on the mid function the cell function and the find function.

Select any cell in the table to show the table tools design tab on the ribbon. Type the name you want in the table name box and press enter. In the example shown. Then the current sheet tab name will be display in the cell.

This is an excessive number but because sheet names cannot have more than 31 characters it ensures the full name is returned whatever it may be.