Show All

Hide All

It is easier to merge scenarios (scenario: A named set of input values that you can substitute in a worksheet model.) when all what-if (what-if analysis: A process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet. For example, varying the interest rate that is used in an amortization table to determine the amount of the payments.) models on the worksheets are identical. All changing cells on the source worksheet must refer to the corresponding changing cells on the active worksheet. Microsoft Excel copies all scenarios on the source sheet to the active worksheet.

1. Open all of the workbooks that contain the scenarios you want to merge.
2. Switch to the worksheet where you want to merge the scenarios.
3. On the Tools menu, click Scenarios.
4. Click Merge.
5. In the Book box, click a workbook name.
6. In the Sheet box, click the name of a worksheet that contains the scenarios you want to merge, and then click OK.
7. Repeat this process if you want to merge scenarios from more worksheets.