XL: Error Copying and Using Paste Special Command on Same Sheet

• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you try to use the Paste Special command in the versions of Microsoft Excel listed at the beginning of this article, you may receive the following error message:

This operation requires the merged cells to be identically sized.

CAUSE

This problem may occur if the following conditions are true:

• You copy data from a range of cells that contains merged cells.


-and-


• You attempt to paste the values only (click Paste Special on the Edit menu and click Values) on the same sheet from which you copied the values.

WORKAROUND

To work around this problem, follow these steps:

1. Select the merged cells that are in the range you want to copy.



2. On the Format menu, click Cells, and then click the Alignment tab.



3. Click to clear the Merge cells check box and click OK.
   
   Note the range of cells that you selected.



4. Select the entire range you want to copy.



5. On the Edit menu, click Copy.



6. Select the range of cells in which you want to paste the values.



7. On the Edit menu, click Paste Special. Click Values, and then click OK.



8. Select the cells that you noted in step 3.



9. On the Format menu, click Cells, and then click the Alignment tab.



10. Click the Merge cells check box and click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

REFERENCES

For more information about using the Copy and Paste commands, click the Index tab in Microsoft Excel Help, type the following text

copying, cell

Additional query words: XL97

Keywords :
Version : MACINTOSH:; WINDOWS:
Platform : MACINTOSH WINDOWS
Issue type : kbbug