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.
Then right click on it to reveal some options and select “Format Cells”
This will open another menu with six tabs. Select the “Alignment” tab. Once selected, find the “Merge Cells” option.
Once you have found it, click it a few times until the box is empty.
Once the check box is empty, click “OK” and you are back in the game!
