Microsoft KB Archive/258950

= XL2000: Error Copying and Using Paste Special Command on Same Sheet =

PSS ID Number: 258950

Article Last Modified on 10/8/2003

-

The information in this article applies to:


 * Microsoft Excel 2000

-



This article was previously published under Q258950





SYMPTOMS
When you try to use the Paste Special command in Microsoft Excel 2000, 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 on the same sheet from which you copied the values.



WORKAROUND
To work around this problem, follow these steps:  For each set of merged cells in the range you want to copy, do the following:  Select the merged cells. Note the range of cells that you selected. On the Format menu, click Cells, and then click the Alignment tab. Clear the Merge cells check box and then click OK.  Select the entire range you want to copy.</li> On the Edit menu, click Copy.</li> Select the top left cell of the range in where you want to paste the values.</li> On the Edit menu, click Paste Special. Click Values, and then click OK.</li> For each range of cells you noted in step 1C, do the following:  Select the cells to merge.</li> On the Format menu, click Cells, and then click the Alignment tab.</li> Select the Merge cells check box and then click OK.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="references_section">