Auto-Sort Won't Sort All Column Cells
Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The
spreadsheet has several columns which sort easily, but the last column will only sort a select tiny block of cells. Is there a way to correct this so the Auto-Sort will sort the entire column? Many thanks!! |
Auto-Sort Won't Sort All Column Cells
Check for blank rows or columns (hidden rows and columns too)
Also, look at your column headers. Does the last column have a column header that uses the same formatting as the other columns? What about Data - Sort and trying it from there? "TikiTembo" wrote: Hi. I'm having some trouble with the Auto-Sort feature in Excel 2003. The spreadsheet has several columns which sort easily, but the last column will only sort a select tiny block of cells. Is there a way to correct this so the Auto-Sort will sort the entire column? Many thanks!! |
All times are GMT +1. The time now is 07:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com