Excel Guides

Deriving the Worksheet Name in Excel

To derive the worksheet name in Excel, you can use a simple formula that concatenates the value in cell A1 with the string "Worksheet." For example, if cell A1 contains the value "MyFirst," then the formula would return "MyFirstWorksheet."

If you need to derive the worksheet name for a specific cell, you can use the CELL function. The CELL function returns information about a cell, including the sheet name. For example, if cell A1 is on Sheet1, the formula would return "Sheet1!A1."

You can also use the INDIRECT function to return the worksheet name for a specific cell. The INDIRECT function returns a reference to a cell or range of cells. For example, if cell A1 is on Sheet1, the formula would return "Sheet1!"&A1.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.