| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to Auto sort or save a sort? | Excel Discussion (Misc queries) | |||
| How can I set up Excel to auto-sort each column independently? | Excel Worksheet Functions | |||
| Auto data sort by clicking on column | Excel Discussion (Misc queries) | |||
| Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
| How to AUTO SORT A-Z new data in a column (not menual sorting) | Excel Worksheet Functions | |||
Hybrid Mode
