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

March 8, 2008 by
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.

Comments

Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.