How do you turn off scroll lock in excel

#How do you turn off scroll lock in excel full#

Delete or resize any which are outside of the range you wish to use. Click OK to close the Excel Options window.Р вЂќР вЂћll the comments/notes will now be visible. In older versions of Excel, the description will be Comment and indicators. From the Advanced section, scroll to the Display sub-section and select Indicators and notes, and comments on hover. However, depending on your specific settings, they might not be visible at all. Option 4: Identifying comments / notesР вЂќР’В¬omment/note boxes are often identified in the worksheet with a small red triangle in the corner of the cell. While it is less likely that worksheet objects are the cause of scroll bar issues, if none of the above options work, then this might just be your problem. Fixing problems caused by worksheet objects When returning to Excel, the scroll bars should hopefully return to a more usable size. In the Immediate Window, type the following and press Enter. Ensure the Immediate window is open by selecting View > Immediate Window (Ctrl + G). Open the Visual Basic Editor from the Developer tab (If you do not have the Developer tab visible, press Alt + F11). Some users report that an additional step is required.Р вЂќР вЂЎollow the steps from Option 2 to clear the unnecessary content. Option 3: Clear all the unnecessary content & reset used range If that doesnР Р†Р вЂљРІвЂћСћt work, repeat the same process, but delete the unnecessary rows by using Home > Delete > Delete Sheet Rows and Home > Delete > Delete Sheet Columns The used range has now been reset, and the scroll bars should return back to a more usable size. Now we have cleared all the unnecessary content, save the document (Ctrl + S). Then, once again, click Home > Clear > Clear All. Press Ctrl + Shift + Right Arrow to select all the columns to the right. Select the entire column to the right of what should be your last used cell. Press Ctrl + Shift + Down Arrow to select all the rows down to the bottom. Looking at your spreadsheet, find the cell you believe should be the last used cell (remember to look in hidden rows and columns too). Option 2: Clear all the unnecessary content & save If youР Р†Р вЂљРІвЂћСћve been unlucky (boo!!!), then move onto Option 2 below. You might be lucky if Excel deems youР Р†Р вЂљРІвЂћСћve not changed the used range, the scroll bars will return to normal size (yay!!! whoop whoop).

Press Ctrl + Up Arrow or Ctrl + Left Arrow to get the selected cell back to a Р Р†Р вЂљР’Вnormal locationР Р†Р вЂљРІвЂћСћ.

Keep pressing Ctrl + Z to undo any changes made to those cells.

Press the Escape key to exit data entry for any cell which is selected.

If you suddenly find yourself in parts of the worksheet you do not wish to populate with data, try this first: The used range is the most likely cause of issues with the scroll bars, so we will tackle this first. Even if the objects are not visible, they still occupy a location on the worksheet, and the scroll bar size will be set accordingly.

#How do you turn off scroll lock in excel full#

The scroll bars must be big enough to enable the user to view the full width or height of these objects.Р вЂќР’Вepending on the settings applied, inserting new rows or columns within the area occupied by the object, could result in that objectР Р†Р вЂљРІвЂћСћs size increasing. That object could be a comment/notes box, a chart or shape, etc. The scroll bar size can also be determined by the bottom right position of a worksheet object. Once this has happened, the scroll bar needs to be tiny as the worksheet might now be 1,048,576 rows high or 16,384 columns wide. This is an extremely easy mistake to make (I know, IР Р†Р вЂљРІвЂћСћve made it myself many times). Formatting that cell, or entering data into it by accident will result in that cell, and every cell above or to the left of it being in the used range. A user might accidentally stray into cells outside of the area needed then make some changes.Р вЂќР вЂЎor example, press Ctrl + Down Arrow and suddenly the cell the bottom of the spreadsheet is in full view and selected.

Occasionally, the used range can become excessively large, which is nearly always caused by user error. For example, if a worksheet has only two changes (1) Cell A1 contains the letter Р Р†Р вЂљРЎС™AР Р†Р вЂљРЎСљ (2) Cell F10 is empty but has been formatted, then the used range is A1:F10. This is the range of cells containing any values, formulas, formatting, etc. The sizes of the horizontal and vertical scroll bars is normally determined by the dimensions of the used range. Two potential factors determine the size of the scroll bar:

Anything else? Why does the tiny scroll bar occur?.

Option 5: Identifying charts, shapes and other objects.

Fixing problems caused by worksheet objects.

Option 3: Clear all the unnecessary content & reset used range.

Option 2: Clear all the unnecessary content & save.

Fixing problems caused by the used range.

Size and placement of worksheet objects.