Expand Selection in Auto filter

N

NM

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.
 
X

xlmate

Excel is not smart enough, its use the current region.
You need to manually select the table and then do the sorting

cheers
 
N

NM

Even if I manually slect the entire data, when I sort it reduces the
expansion,selects only the coulmns I mentioned below!!
 
S

Sean Timmons

Have you attempted selecting the entire spreadsheet prior to sort? A split
only shows the view differently. It would have no impact on sorting.
 
N

NM

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?
 
N

NM

Thanks much Ashish, your solution worked! I had blank coulmns in between.I
am grateful to you for your help, as since yesterday I couldn't do my work!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto filter sort ascending not working while sheet protected 6
Cannot expand the selection to entire spreadsheet when sorting 2
Drop Down Sort Button. 2
Hopefully an easy question 4
auto filter on columns 2
Filters/Circular References 0
Column hidden and Auto filter 2
How do I pick row 3 to be the header row in Excel 1

Top