Excel Guides

Referencing a Worksheet Name in Excel

When referencing a worksheet name in Excel, you can use a number of different methods. The most common method is to use the sheet's name followed by an exclamation point. For example, if you wanted to reference the worksheet named "Sheet1", you would use the following syntax:

Sheet1!A1

You can also reference a worksheet name by using its index number. To do this, you would use the following syntax:

Sheet1!A1

If you have more than one worksheet with the same name, you can use the sheet's index number to disambiguate between them. For example, if you had two sheets named "Sheet1", you could reference them as "Sheet1 (2)" and "Sheet1 (3)".

Another way to reference a worksheet name is by using the INDIRECT function. This function takes a string as its input and returns a reference to the cell or range that is specified by that string. For example, the following formula would return a reference to cell A1 on the worksheet named "Sheet1":

=INDIRECT("Sheet1!A1")

You can also use the INDIRECT function to reference an entire range of cells. For example, the following formula would return a reference to all of the cells in column A on the worksheet named "Sheet1":

=INDIRECT("Sheet1!A:A")

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.