How to reference data from another worksheet in excel

How to reference data from another worksheet in excel? This is a problem often encountered by many excel users. PHP editor Yuzai has summarized several simple and easy-to-understand methods to help you easily reference data from another worksheet in Excel, making your work more efficient and convenient. Next, let’s learn about these practical tips!

In a workbook, there are two worksheets: "2019" and "2018". We need to reference the data from "2018" in the "Same period last year" column in the "2019" worksheet.

#2. First select the "2019" worksheet, click cell C3, and enter the formula symbol "=" in this cell, as shown in the figure.

3. Now you want to reference the data in the "2018" worksheet, so click the label of the "2018" worksheet with the mouse, as shown in the figure.

4. Then click the cell where the data you want to reference is located in the "2018" worksheet. The data to be referenced here is cell B3. After clicking cell B3, the formula in the formula edit bar is: "='2018'!B3", which means that the data in cell B3 in the worksheet is referenced in 2018. as the picture shows.

5. Click the "Enter" button (a check mark) in the formula edit bar to confirm that the entered formula takes effect, as shown in the figure.

#6. After the formula takes effect, return to the "2019" work, where the data in cell C3 is the data in the referenced "2018" worksheet. Using this method, you can reference data in other worksheets in the current worksheet, as shown in the figure.

The above is the operation method that the editor brings to you on how to reference data from another worksheet in Excel. Have you learned it? Isn’t it difficult at all! Finally, I hope that my sharing can be helpful to everyone. Friends should also practice more diligently after class and become more proficient in the use of Excel software, so that future work and study can be more efficient and convenient.

The above is the detailed content of How to reference data from another worksheet in excel. For more information, please follow other related articles on the PHP Chinese website!