So I have been having this problem for quite some time. The problem is that when I select a range of cells and apply auto-filter, it does not take my view to the header. Usually I work with large data and I find it hard to confirm whether the filter is applied or not, as I have to manually scroll to the heading of the data to check the same. I am currently using Excel 2019 and I have tried re installing the same but no luck. Any help would be appreciated!
Have you considered fixing your titles (headings) so they are always visible? That way you can see which column is filtered
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
That is too much of work. I work with many sheets and can't freeze them everytime. To be clear with my question, I have attached 2 pictures. The second one is the data I selected on which I want to apply the filter. I selected the range and when I apply Auto Filter, I want it to take me to the heading (Like in Attachment 1). But for me the view just stays in the same place (Same like Attachment 2).
Yeah I dont think there is much you can do about that, sorry
I just wanted to know if the problem lies with my software or is it the same for everybody else. Thanks!
Please Remove filter and change range to Table by press Ctrl+T
https://support.microsoft.com/en-us/...9-6c94334e492c
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks