In Microsoft Excel, it’s a common task to refer to cells on other worksheets or even in different Excel files. At first, this can seem a little daunting and confusing, but once you understand how it works, it’s not so hard.
In this article, we’ll look at how to reference another sheet in the same Excel file and how to reference a different Excel file. We’ll also cover things like how to reference a cell range in a function, how to make things simpler with defined names, and how to use VLOOKUP for dynamic references.
How to Reference Another Sheet in the Same Excel File
A basic cell reference is written as the column letter followed by the row number.
So the cell reference B3 refers to the cell at the intersection of column B and row 3.
When referring to cells on other sheets, this cell reference is preceded with the other sheet’s name. For example, below is a reference to cell B3 on a sheet name “January.”
=January!B3
The exclamation point (!) separates the sheet name from the cell address.
If the sheet name contains spaces, then you must enclose the name with single quotation marks in the reference.
='January Sales'!B3
To create these references, you can type them directly into the cell. However, it is easier and more reliable to let Excel write the reference for you.
Post a Comment Blogger Facebook
We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.