| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Expand Selection in Auto filter
Hi,
My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expand Selection in Auto filter
Excel is not smart enough, its use the current region.
You need to manually select the table and then do the sorting cheers "NM" wrote: Hi, My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expand Selection in Auto filter
Even if I manually slect the entire data, when I sort it reduces the
expansion,selects only the coulmns I mentioned below!! "xlmate" wrote: Excel is not smart enough, its use the current region. You need to manually select the table and then do the sorting cheers "NM" wrote: Hi, My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expand Selection in Auto filter
Have you attempted selecting the entire spreadsheet prior to sort? A split
only shows the view differently. It would have no impact on sorting. "NM" wrote: Even if I manually slect the entire data, when I sort it reduces the expansion,selects only the coulmns I mentioned below!! "xlmate" wrote: Excel is not smart enough, its use the current region. You need to manually select the table and then do the sorting cheers "NM" wrote: Hi, My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expand Selection in Auto filter
I tried to sleect the entire Sheet and then sort but still the sort for some reason restricts itself to just a few columns!! The sort used to work fine until today, when I added 30 new columns in the middle of the sheet. Has that got something to do with it? Is there a column limit to sorting? "Sean Timmons" wrote: Have you attempted selecting the entire spreadsheet prior to sort? A split only shows the view differently. It would have no impact on sorting. "NM" wrote: Even if I manually slect the entire data, when I sort it reduces the expansion,selects only the coulmns I mentioned below!! "xlmate" wrote: Excel is not smart enough, its use the current region. You need to manually select the table and then do the sorting cheers "NM" wrote: Hi, My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Expand Selection in Auto filter
Hi,
Please ensure that there are no blank columns. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "NM" wrote in message ... I tried to sleect the entire Sheet and then sort but still the sort for some reason restricts itself to just a few columns!! The sort used to work fine until today, when I added 30 new columns in the middle of the sheet. Has that got something to do with it? Is there a column limit to sorting? "Sean Timmons" wrote: Have you attempted selecting the entire spreadsheet prior to sort? A split only shows the view differently. It would have no impact on sorting. "NM" wrote: Even if I manually slect the entire data, when I sort it reduces the expansion,selects only the coulmns I mentioned below!! "xlmate" wrote: Excel is not smart enough, its use the current region. You need to manually select the table and then do the sorting cheers "NM" wrote: Hi, My file has columns till DR. I have a spilt in the sheet at AP13.I am using 'Sort ascending' from the auto filter at CQ to sort the my file but my sort selection is not expanding to entire columns. Column A-AP are not getting sorted ascending, and now i have data all jumbled up! Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto filter multiple selection turn off | Excel Discussion (Misc queries) | |||
| How do I expand a filter drop-down box? | Excel Worksheet Functions | |||
| Expand Selection in Multiple Sheets | Excel Discussion (Misc queries) | |||
| # of Records Shown During Auto-Filter Selection | Excel Discussion (Misc queries) | |||
| Shift+Arrow does not expand selection | Excel Discussion (Misc queries) | |||
Hybrid Mode
