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

By Frefel1 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Merged cells

by Scalloway1 In reply to Excel 2013 sort "To do t ...

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.

Related Discussions

Related Forums