I have multiple columns and when I use auto filter to filter the data to highest to lowest. My problem is that when I filter column A to highest to lowest, other columns are also being filtered and I do not know how to unselect the hishest to lowest so the data for the other columns will go back. Is there a way to unselect it? Or any better solution so only specific column will be sorted and other columns will remain untouched.
Did you try to use Custom Sorting?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
When you use a filter, ALL rows are filtered, not just he range you have selected.
After you have applied a filter and want to remove it, click "Sort and Filter", then click Clear
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks