Cell Reference to Other Worksheets
Cell reference in Excel are not limited to just the current worksheet. You can also reference cells from other worksheets within the same workbook. Let’s walk through an example to understand how to create these references.
Suppose we have two worksheets : “Sheet1” and “Sheet 2”. In “Sheet 2” we have value Student name that we want reference in “Sheet 1”.
Follow the below steps to create direct reference to “Sheet 2” from “Sheet 1”:
Step 1: Activate a cell in “Sheet 1” where you want to display the referenced value.
Step 2: Type an equal sign(=) in that cell to start a formula or reference.
Step 3: Switch to “Sheet 2” by clicking on its tab at the bottom of the Excel window.
Step 4: Locate the Specific cell that contains the desired value.
Step 5: Click on that cell to include it in the reference.
Step 6: Press Enter to complete the reference.
Once you press Enter, a reference is created in “Sheet 1” that points to the corresponding cell in “Sheet 2”. This means that any changes made to the referenced cell in “Sheet 2” will automatically reflect in the referenced value within “Sheet 1”.
Relative, Absolute and Mixed Cell Reference in Excel
Microsoft Excel, sometimes known as MS Excel, is a potent spreadsheet program. In Excel, each worksheet consists of a number of cells that are made up of rows and columns. Each cell has a unique reference, which enables users to quickly access and address the required cell (or cells) within the functions. In Excel, cell references are crucial, particularly when working with huge data sets in functions and formulas.
This article covers a quick overview of Excel Cell References. The various sorts of cell references that Excel offers and the detailed instructions for using each one are also covered in the article.