Asked in
Academic Writing
Microsoft Excel

What is a method used in referencing information from one worksheet to another?

Answer

User Avatar
Wiki User
November 18, 2009 11:52PM

You use the name of the Sheet you want to refer to, followed by an exclamation mark, followed by the cell reference. So to get cell A1 on Sheet1 from another sheet it would be done like this:

=Sheet1!A1