How do I get rid of the scroll bar in the middle of Excel?

How do I get rid of the scroll bar in the middle of Excel?

Hide or display scroll bars in a workbook

1. Click the File tab.
2. Click Options, and then click the Advanced category.
3. Under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars.

Why is there a scroll bar in the middle of my Excel worksheet?

If anyone else is experiencing this same issue it’s due to -> frozen row. Go to View -> Freeze Panes -> Unfreeze. Yup Excel is becoming very unreliable with every new release. Had this problem with a user today (Windows 10/Office 365 alls current).

How do I fix the scroll bar in Excel?

Press Ctrl + Shift + Right Arrow to select all the columns to the right. Then, once again, click Home > Clear > Clear All. Now we have cleared all the unnecessary content, save the document (Ctrl + S). The used range has now been reset, and the scroll bars should return back to a more usable size.

How do you change the scrolling range in Excel?

Go to File > Options, select Advanced in the left menu, then scroll down to Display Options for This Workbook to find the scroll options. To resize the horizontal scroll bar, place the mouse pointer over the three vertical dots, then click-and-drag to the right or left.

How do I enable scrolling in Excel?

Click File > Options. , and then click Excel Options. Click Advanced, and then under Display options for this workbook, make sure that the Show horizontal scroll bar and the Show vertical scroll bar check boxes are selected, and then click OK.

How do I manage scrolling in Excel?

Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet. Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right.

How do I get my scroll bar back on my screen?

Q: How do I Restore my Word or Excel Scroll Bar?

1. Click on the File menu then Options.
2. Select Advanced from the sidebar.
3. Scroll to the section for Display.
4. Ensure that the Show horizontal scroll bar and Show vertical scroll bar options are selected.
5. Click OK.

How do I restore my vertical scroll bar?

Show scroll bars in Word and Excel for Windows

1. Click File > Options.
2. On the Advanced tab, scroll to the Display section.
3. Select Show horizontal scroll bar and Show vertical scroll bar, and then click OK.