Reference Another Sheet in Excel: How to do it

When working in Excel, sometimes it’s necessary to reference another sheet to get specific data from it. If you’re not familiar with this feature, today we’re going to show you how to use it.

How do I reference another sheet in Excel?

1. Manually select the sheet

1. Select the cell in which you wish to reference another sheet.
2. Type = and switch to the desired sheet.
    
3. Select the values you wish to use.
   
4. Go back to the original cell. You should now see that the formula field and cell have changed to include the formula.
   
5. Press Enter.

2. Enter the sheet name

1. Select the cell you wish to use.
2. Type =WindowsReport!A1 or if your sheet has a space in its name use the following formula =’Windows Report’!A1
   
3. Press Enter.

This method is useful if you know the sheet name and the cells that you’ll be using.

How do I reference another sheet in the Excel workbook?

1. Ensure both workbooks are open.
2. Select the cell you want to use.
3. Type = and switch to the second sheet.
4. Select the field you want to use.
5. Go back to the original sheet and press Enter.

You can also use the following formula to access an open xlsx file: =[WindowsReport.xlsx]Sheet1!A1

If the file isn’t currently open, use =C:\Documents\[WindowsReport.xlsx]Sheet1!A1

As you can see, it’s easy to reference another sheet in Excel, and the best way to do that is manually. However, you can also do that with a formula if you know the cell numbers and sheet names.

To learn more about this subject, we have a great guide on how to get data from another sheet in Excel that shows you how to use different functions.

Speaking of functions, don’t miss our guide on how to apply a function to an entire column in Excel. We also have a great article on how to freeze a row and a column in Excel, so don’t miss it.