Cell reference of another worksheet! Flashcards
1
Q
How to use the copy and paste options for cell reference of another worksheet?
A
Open 2 sheets and write a function in a cell on the first one. Now, copy the formula using Ctrl+C and paste it on the same cell in the 2nd worksheet using ctrl+V.
2
Q
What do we use in the sheet reference?
A
In the sheet reference method, we use sheet number followed by an explanation mark and then cell address to refer to a cell of a particular worksheet.
3
Q
Example of sheet reference and what it’s referring to
A
Example is =Sheet1!D4 and here we are referring to the cell D4 of Sheet1
