XL98: Cannot Show Scenario That Includes Merged Cells

MORE INFORMATION

In Microsoft Excel 98 Macintosh Edition, you can merge a number of cells into a single cell by performing the following steps:

1. Select the cells that you want to merge.
2. On the Format menu, click Cells. Click the Alignment tab. Click to select the Merge Cells check box, and then click OK.

You can also merge cells by selecting the cells and clicking the Merge and Center button on the Formatting toolbar.

You can add a scenario to a worksheet by performing the following steps:

1. On the Tools menu, click Scenarios. Click Add.
2. In the Scenario Name box, type a name for your new scenario. In the Changing Cells box, enter a reference to the cells that you want to include in the scenario, and then click OK.
3. In the Scenario Values dialog box, enter a value for each changing cell. When you are finished, click OK.
4. In the list of Scenarios, select the scenario you want to show, and then click Show.

If any of the changing cells are merged cells, you will receive the error message mentioned in the "Symptoms" section of this article.