See all How-To Articles

How to Hide Vertical and Horizontal Scroll Bars in Excel

This tutorial demonstrates how to hide vertical and/or horizontal scroll bars in Excel.

 

hide horizontal scroll-bar initial data

 

Hide Horizontal Scroll Bar

By default, horizontal and vertical scroll bars are displayed in Excel. But while working in Excel, you may need to disable a user from scrolling horizontally or vertically in a worksheet.

 

hide horizontal scroll bar initial data

 

To hide the horizontal scroll bar, follow these steps:

1. In the Ribbon, go to the File tab.

 

hide horizontal scroll bar file tab

 

2. In the menu on the left side, go to Options (at the end of the list).

 

hide horizontal scroll bar options

 

3. In the Excel Options window, go to Advanced, scroll down to the Display options for this workbook section, uncheck “Show horizontal scroll bar,” and click OK.

 

hide horizontal scroll bar options 2

 

Making this change hides the worksheet’s horizontal bar. As you can see in the picture above, this display option refers only to the current workbook, but you could also choose any open workbooks.

 

horizontal scroll bar hidden

 

Hide Vertical Scroll Bar

To hide the vertical scroll bar in your workbook, follow Steps 1 and 2 above again. Then in Step 3, also uncheck Show vertical scroll bar in the Excel Options window.

 

hide vertical scroll bar

 

Unchecking these two boxes hides both horizontal and vertical scroll bars.

 

horizontal and vertical scroll bar hidden

 

You can also use VBA code to hide scroll bars in Excel.

Google Sheets doesn’t have this option.