Excel automatic move of screen /work area.?

[excel5028000]

Hello you all great and super helpful people! I hope everyone’s doing fine and excellent.

Something that’s been baffling me recently.


On Microsoft Office 2010—specifically Excel 2010—suppose you are on a sheet with data filled from column A thru F and more importantly vertically populated ranging from row 1 thru 6580.

Suppose you do Cntrl+Arrow down and your cursor is on the last row of the data. Then suppose you hit filter to put the filter on row 1. When you do that, the full screen automatically goes to row 1, whereas previously on your (eye level view) screen you were on around row 6580 as stated earlier.

Well this convenient and super-fast movement is where I was able to zip thru a lot of worksheets and work thru at work and everywhere else seems disabled or missing on my computer and I don’t even know what’s it called.

Unfortunately—this convenient movement of the screen or work area seems unavailable on my Excel 2016 or Excel 365 at my work computer. What gives? What’s this function called so I may enable it? Because right now when I activate the filter, I have to manually go up to row 1.



Thank you as always.

 

[ashakantasharma]

This seems to be a default basic function of Excel and should not have any Enable/Disable option. However you may share a sample date where you are facing the issue for a better understanding and resolution on the same.

 

[excel5028000]

Thank you for reply ashakantasharma.

Issue got fixed briefly when I reinstalled MS Office but still present. Not feasible to keep reinstalling although fresh install of things is always best. I am searching around. Will disclose solution if found.
Oddly enough Excel 2010 seem fine. It's my 2016 version that's plagued both at home and work.