Activating filter doesn't go to first row

%3CLINGO-SUB%20id%3D%22lingo-sub-1426549%22%20slang%3D%22en-US%22%3EActivating%20filter%20doesn't%20go%20to%20first%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426549%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20end-user%20that%20has%20a%20strange%20issue%20when%20she%20activates%20a%20filter%20in%20an%20Excel%20document.%3C%2FP%3E%3CP%3EUsually%20when%20doing%20this%2C%20the%20sheet%20goes%20to%20the%20top%20row%2C%20but%20this%20doesn't%20happen%20anymore.%26nbsp%3B%3CBR%20%2F%3EIt%20just%20stays%20on%20the%20current%20view%20of%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1426549%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426624%22%20slang%3D%22en-US%22%3ERe%3A%20Activating%20filter%20doesn't%20go%20to%20first%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683463%22%20target%3D%22_blank%22%3E%40Dennis_Gewillig%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20noticed%20the%20same%2C%20if%20I'm%20down%20toward%20the%20bottom%20of%20a%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20don't%20say%2C%20though%2C%20whether%20the%20filter%2C%20%3CEM%3Eper%20se%3C%2FEM%3E%2C%20is%20working%20as%20it%20should%3B%20is%20it%3F%20If%20so%2C%20what's%20the%20problem%3F%20Just%20scroll%20up.%20Command%2FCtrol%20plus%20up-arrow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435236%22%20slang%3D%22en-US%22%3ERe%3A%20Activating%20filter%20doesn't%20go%20to%20first%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435236%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%20the%20filter%20works%20like%20it%20should.%3C%2FP%3E%3CP%3EThe%20issue%20happens%20with%20all%20Excel%20files.%20As%20a%20test%20I%20created%20a%20new%20document%20with%20two%20columns%20that%20are%20longer%20than%20the%20height%20of%20her%20screen.%3CBR%20%2F%3ELet's%20say%20that%20the%20currect%20view%20starts%20from%20row%20200%20-%20to%20260.%20When%20activating%20the%20filter%20it%20will%20just%20keep%20that%20view%20and%20thus%20won't%20scroll%20automatically%20to%20row%201%26nbsp%3B%20where%20the%20filter%20is%20put%20on.%3C%2FP%3E%3CP%3EIt's%20not%20a%20big%20issue%20of%20course%2C%20but%20still%20I%20do%20find%20it%20strange.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a end-user that has a strange issue when she activates a filter in an Excel document.

Usually when doing this, the sheet goes to the top row, but this doesn't happen anymore. 
It just stays on the current view of the sheet.

2 Replies
Highlighted

@Dennis_Gewillig 

 

I've noticed the same, if I'm down toward the bottom of a table.

 

You don't say, though, whether the filter, per se, is working as it should; is it? If so, what's the problem? Just scroll up. Command/Ctrol plus up-arrow.

Highlighted

@mathetes 

Well the filter works like it should.

The issue happens with all Excel files. As a test I created a new document with two columns that are longer than the height of her screen.
Let's say that the currect view starts from row 200 - to 260. When activating the filter it will just keep that view and thus won't scroll automatically to row 1  where the filter is put on.

It's not a big issue of course, but still I do find it strange.