![]() ![]() If the cell you want to reference is in another worksheet that's in your workbook (the same Excel file), follow the following steps. Reference a cell from another worksheet in the current workbook Press Enter to create the cell reference.įor example, we click the B3 cell, resulting in the cell containing the reference to display "=B3" and mirror any data changes made in B3. Click the cell in the same worksheet you want to make a reference to, and the cell name is automatically entered after the equal sign. ![]() Click the cell where you want to enter a reference to another cell.If the cell you want to reference is in the same worksheet, follow the steps below to reference it. Reference a cell in the current worksheet Reference a cell from another worksheet in the current workbook.Reference a cell in the current worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |