How to Hide the Scroll Bars in Excel for Office 365

When you are working with a lot of data in an Excel spreadsheet, screen real estate becomes very important. Constantly having to scroll to see important information can get tedious, especially if the information you need to see is only a cell or two out of view.

If you find that the scroll bars are getting in the way of your navigation, or if you are often clicking on them by mistake and moving the window view to the wrong part of the spreadsheet, then you might like to get rid of those scroll bars. Our tutorial below will show you where to find that option in Excel for Office 365.

How to Hide the Horizontal and Vertical Scroll Bars in Excel

The steps in this article were performed in the Microsoft Excel for Office 365 version of the program, but will also work in most newer versions of Excel as well.

Note that this setting only applies to the workbook that is currently open. This does not change the default setting for these scroll bars. Other workbooks and new workbooks that you create will still have the scroll bars.

Step 1: Open Excel.

Step 2: Select the File tab at the top-left of the window.

select the file tab

Step 3: Choose the Options button at the bottom of the left column.

open the excel options menu

Step 4: Select the Advanced tab at the left side of the Excel Options window.

click the advanced tab

Step 5: Scroll down to the Display options for this workbook section of the menu, then click the boxes to the left of Show horizontal scroll bar and Show vertical scroll bar to remove the check mark.

how to hide the scrollbars in excel

Step 6: Click the OK button at the bottom of the window to apply the changes.

Is your spreadsheet printed at the left side of the page? Find out how to center a printed worksheet so that it isn’t left-aligned on the page.