Microsoft Office Tutorials and References
In Depth Information
Reference Another Worksheet Range in a Formula
Reference Another Worksheet
Range in a Formula
You can add flexibility to your formulas by adding
references to ranges that reside in other worksheets.
This enables you to take advantage of work you have
done in other worksheets, so you do not have to
waste time repeating your work in the current
worksheet.
Referencing a range in another worksheet also gives
you the advantage of having automatically updated
information. For example, if the data in the other
worksheet range changes, Excel automatically
updates your formula to include the changed data.
Reference Another Worksheet Range in a Formula
1 Click in the cell in which you
want to build the formula, type
, and then type any operands =
and operators you need before
adding the range reference.
2 Press + until the
worksheet you want to use
appears.
Search JabSto ::




Custom Search