How To Fix Microsoft Office Excel Merged Cells Need To Be The Same Size Error Dialogue Message

Microsoft office excel Merged data has to be the same size Error

Has Microsoft Office Excel ever confronted you with the error dialogue box that says “To do this, all the merged cells need to be the same size” when you are trying to sort your columns and data? It was driving me crazy, but a little dig into the documents settings revealed the culprit. To solve it just click the little triangle in the top left hand corner of your spreadsheet once to select the whole document.Microsoft office excel Merged data has to be the same size Error

Then right click on it to reveal some options and select “Format Cells”

select all menu

This will open another menu with six tabs. Select the “Alignment” tab. Once selected, find the “Merge Cells” option.

Format Cells Option Window

Once you have found it, click it a few times until the box is empty.

Merge Cells Check Box

Once the check box is empty, click “OK” and you are back in the game!

homer-woohoo

4 thoughts on “How To Fix Microsoft Office Excel Merged Cells Need To Be The Same Size Error Dialogue Message

  1. George Freeman says:

    Thank you! Your explanation worked perfectly! I did, indeed, feel like Homer when I was done!

  2. Rockgirl2022 says:

    Great work rockstar!! wanted to bang my head against the wall but you solved it!!!!! made my day, babe <3 keep killin' it

  3. lily says:

    Thank you so much, this was very helpful

  4. Webmaster says:

    Your welcome! Glad you found it useful!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.