Excel.Tips.Net: Incomplete and Corrupt Excel Sorting

By Allen Wyatt for Excel.Tips.Net

Incomplete and Corrupt Excel Sorting

The sorting capabilities of Excel are quite handy, and quite powerful. The different ways you sort information has been covered in quite a few different issues of ExcelTips. What happens, however, if you try to sort something and Excel omits some columns from the sort and otherwise scrambles your data?

The most common cause for this problem is that Excel isn’t recognizing all your data. If you select a single cell in the data table, and then click on either the Sort Ascending or Sort Descending tool, Excel makes its best guess as to what data you want sorted. It may not always make a perfect guess, particularly if there are blank columns, blank rows, or large empty ranges in the data.

One way to see if this is the real problem…Steps Continued Here

(Visited 9 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *