Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Move Or Scroll Through Worksheet. Search for Show the Developer tab and your Excel version in your favorite search. Click and hold with left mouse button on the worksheet.
It just brings more tabs into view so you can then click the selected tab. Now youll be able to scroll in Excel again like magic. Even if a worksheet is protecte.
Following screenshot shows Scroll Lock alert displaying in MS Excel status bar.
This code moves down column A to the end of the list. Range A2Select Establish For loop to loop numrows number of times. The scroll bar is added in a top-down orientation. Microsoft Excel also shows an alert in Status Bar when Scroll Lock is turned on.