0
As a workbook can have multiple sheets there are occasions where you would be referring to data on different sheets from each other. It is then a requirement that you specify which sheet you are referring to. So there needs to be a sheet reference along with a cell reference. This is done by having the name of the sheet followed by an exclamation mark, after which you can have the cell. The cell A6 on Sheet2 would be referred to as follows:
Sheet2!A6
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
How do you use a sheet for another sheet in Excel?
You can reference other sheets in the same workbook by putting the sheet name followed by an exclamation mark and then the cells you want. While on Sheet1, to reference cell C7 on Sheet3, you could do this: =Sheet3!C7
How do you make a result sheet in Excel?
how to create a excel sheet
What is the full form of PFA in Excel sheet?
Pfa the excel sheet
How do you link data in a row on excel master sheet to row on another sheet on Mac Excel 2011?
Use the name of a sheet, followed by an exclamation mark and a cell reference. The following would take the value in cell C21 on Sheet2 and put it wherever the formula is typed. =Sheet2!C21
in excel What do you call a reference to a cell on another sheet?
It is still called a reference. You might also perhaps call it a link, but that term is generally reserved for when referencing a separate workbook.
What do you call a reference to a cell on another excel sheet?
It is still called a reference. You might also perhaps call it a link, but that term is generally reserved for when referencing a separate workbook.
How do you make a cover sheet in excel?
Add a sheet
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?
Calculating DSCR in Excel sheet
How is a sheet made active on excel 2007?
Select the sheet.
What is a position of a cell in a spreadsheet?
Every cell in an excel spreadsheet has a 'Reference', this reference is found by looking at the Letter at the top of the sheet and the number on the Left of the sheet. Assuming you have your options on the default settings, the top, left hand cell would be cell reference A1, the one below that would be A2, the one to its right would be B1.
What is the cell address of the last cell of the Microsoft Excel 2003?
The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.
