Excel Guides

Returning a Worksheet Name in Excel

There are a few ways to return a worksheet name in Excel. One way is to use the NAME function. This function returns the name of a worksheet, based on its position in the workbook. For example, if you have a workbook with three worksheets, and you want to return the name of the second worksheet, you would use the following formula:

=NAME(2)

Another way to return a worksheet name is to use the CELL function. This function returns information about a cell, including the worksheet name. For example, if you have a cell in the second worksheet of your workbook that contains the value "123", you could use the following formula to return the name of that worksheet:

=CELL("filename",A1)

You can also use the INDIRECT function to return a worksheet name. This function returns a reference to another cell or range of cells. For example, if you have a cell in your workbook that contains the text "Sheet2", you could use the following formula to return the name of that sheet:

=INDIRECT("'"&A1&"'!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.