Question Locked

Excel 2013 sort "To do this all the merged cells need to be the same size"

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I was practicing sorting and filtering successfully as I tried to self-learn these functions. One of my sorts was to find only those reports written in June when suddenly, the above message came up when I tried a sort, and my worksheet is stuck in one of my sort modes. Sadly, I do most of my work with my project numbers in numerical order, and this sort doesn't have that. What happened, and more importantly, how can I fix it?

2 replies

by scalloway1

Somewhere in your data is a merged cell or cells. You will need to go through them to demerge them. If you use the down arrow to move through each column it should be obvious what cells are merged together. Right click on the merged cells and deselect the tick in the Merge cells box.

This discussion is closed to new replies.