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 ... |
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
