Excel Reference Tab Name

It references the table data without any header or total rows.

Excel reference tab name. Sales amount and commission amount are column specifiers that use the names of the columns they represent. 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. Please do as follow to reference the active sheet tab name in a specific cell in excel. The month tabs of the worksheet contain a table that looks like this.

Select a blank cell copy and paste the formula mid cell filename a1 find cell filename a1 1 255 into the formula bar and the press the enter key. Indirect a2 a1 without the quotation marks before the equals sign or after the final parentheses. Once you hit enter the formula will evaluate and the cell will show the word orange. The vlookup formulas on the summary tab lookup and extract data from the month tabs by creating a dynamic reference to the sheet name for each month.

Assuming that you want to reference the current worksheet name in cell b1 you can use the following formula to achieve it. Current tab you can use a formula based on the cell function. Click on the tab for sheet1 and in cell b2 enter the following formula. Deptsales is a custom table name.

In the example shown. You can use a default table name such as table1 or change it to use a custom name. Cell retrieves the workbook name and sheet and the mid and find functions are used to extract just the sheet name. 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.

To get the name of the current worksheet i e. Reference the current sheet tab name in cell with formula. Sheet1 and followed by an exclamation mark before we mention the cell address and cell address is b2.