Receiving Error Message: This Operation Requires The Merged Cells To Be Identically Sized When Using MS Excel XP

March 8, 2008 by · Leave a Comment
Filed under: Excel, How To 
  1. Select the merged cells that are to be copied.
  2. Click Format menu, select Cells, and then click the Alignment tab.
  3. Uncheck Merge cells field and then click OK.
  4. Choose the entire range of cells to be copied, and then click Edit menu and select Copy.
  5. Select where the data should be pasted and then click Paste Special from the Edit menu.
  6. Click Values and then click OK.
  7. Select the range of cells just pasted.
  8. Click Format menu, select Cells, and then select the Alignment tab.
  9. Check Merge cells field and then click OK.

Tags: ,