Share this article
Improve this guide
Reference Another Sheet in Excel: How to do it
This can be done simply by selecting the desired values
2 min. read
Published onOctober 4, 2024
published onOctober 4, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
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
2. Enter the sheet name
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?
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 toget data from another sheet in Excelthat shows you how to use different functions.
Speaking of functions, don’t miss our guide on how toapply a function to an entire column in Excel.
More about the topics:Excel,Microsoft Excel
Milan Stanojevic
Windows Toubleshooting Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He’s a PC enthusiast and he spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
