I use an excel file at work with a large amount of data that I add to and pull from twice a day. To make sure I am grabbing only the recent relevant data, I have a filter applied to my 2 sheets that have raw data. In one of those sheets, when I unfilter to add more data, the sheet shoots up to near the top. While it is only a minor inconvenience to go back to the bottom, over time it can become annoying especially when I'm in a rush.
Is there some kind of setting I have on that might be taking me to a different part of the sheet when I want to stay at the bottom?
It's almost as if it takes me to the position of the filtered data. Meaning if I filter a sheet with 10000 rows of data and it filters down to 500 rows of data, when I unfilter it "takes" me up to row 500. It is strange because only 1 of the 2 sheets of data does this.
Bookmarks