Damian Gardner
asked on
Excel spreadsheet won't sort all columns together
Hello. We have a spreadsheet from one of our users, where he added 3 columns (N,O,P) onto the existing sheet, and while they look like the rest of the columns, there's something about them that will not allow N,O,P to be sorted along with the rest of the worksheet. A thru M can be sorted, and N-P - but not ALL together...the SORT function becomes greyed out if you try. I want to try and resolve this without attaching the file, if possible (sensitive info). if absolutely necessary, I can create an abbreviated version of it perhaps.
thank you in advance
thank you in advance
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok - it says I need to remove AutoFilters before I can do that. I'll see if I can find where that's set...
ASKER
I found it. had to turn off autofilters for both sections, and now I can sort. thank you gentlemen!
ASKER
Yeah - I'm not sure if its a mix of table and range, actually.
thanks guysCopy-of-2016---Airgas.xls