How to Create a Formula That Spans Multiple Microsoft Excel Worksheets

See Microsoft Excel: Tips and Tricks for similar articles.

Creating a formula that spans multiple Excel worksheets is easy. Just follow these steps.

This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.

  1. If you haven't named cells, do the following:
    1. Select the sheet and cell into which you wish to type the formula.
    2. Type "=".
    3. Select the sheet that includes the data you will use in your formula.
    4. Select the cell that contains the data.
    5. Enter an operator (+, -, *, /).
    6. Either select another cell in that sheet or select another sheet and cell to complete the formula.
  2. If your formula contains named cells or ranges, do the following:
    1. Select the sheet and cell into which you wish to type the formula.
    2. Type "=".
    3. Enter the formula using names.