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

Troubleshooting

Sorting Out Sorting Problems

Q1:I tried to run a multicolumn sort on my list, but the result came out scrambled and my column labels disappeared.
A1: 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 check a 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.

Top 10 Is for Numbers Only

Q1:After turning on AutoFilter, I chose the Top 10 option for one field in my list. Instead of displaying the dialog box that lets me select further options, however, Excel simply beeped or displayed a list that didn't contain nearly as many items as I specified.
A1: The Top 10 option works only with numeric values. If you've selected a field that contains text, Excel balks and refuses to even display an error message. If the column includes a mix of text and numbers, Excel ignores the text values and bases the Top 10 selection only on numbers in that column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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