Excel Scroll Lock Stuck Code Is Viewed

Those users cant scroll down their spreadsheets with the scroll bar or their mouse wheels.

So, it might be worth checking if the Shift key is in any way jammed.

If so, you probably wont be able to scroll down in other software along with Excel.

The spreadsheet will probably scroll fine in applications such as LibreOffice Calc.

While working on a shared spreadsheet, this is important that a user must restrict the other user from changing the data that the primary user has inserted, and this can be done by the excel row limit.

By using this method, we actually physically make the unwanted rows disappear from the workspace.

In this way, we can restrict the user to have access to the restricted rows.

By not checking this option, Excel will now not allow the users to select the locked cells.

You can also use the shortcut key F4 to select the properties window.

Excel Scroll Lock Stuck Code Is Viewed

Other sheets will not get impacted as the property is only changed for that worksheet, whose code is viewed and then changed.

Suppose if we have hidden the first 10 rows, then this does not mean that the 11 th row will get 1 st.

This is because of the fact that excel wants the user to notify that some of the rows are hidden.

Here we discuss how to limit the rows in excel using 1) hide feature 2) Protect worksheet, and 3) VBA Scroll Lock along with practical examples and downloadable templates.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.