How to Keep Excel From Expanding Cells When Sorting. The Excel software automatically expands rows and columns when you sort data and more room is needed for the extra data.