• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Sorting Out Sorting Problems

I tried to run a multicolumn sort on my list, but the result came out scrambled and my column labels disappeared.

The most likely cause of this problem is that Excel couldn't identify the header row in your list. If you use the Sort dialog box, you can select a check box that tells Excel that your list has a header row. Other common sorting problems are caused by blank rows or columns in the list, in which case Excel doesn't sort the records below the blank row or to the right of the blank column. To work around this problem, select your list, minus the header rows, and choose the No Header Row option. You'll need to make a mental note of which column number corresponds with each column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint