excel5028000
New Member
- Joined
- Mar 5, 2020
- Messages
- 9
- Office Version
- 365
- 2016
- Platform
- Windows
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.
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.