How to Hide Vertical and Horizontal Scroll Bars in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on January 2, 2023

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


  1. In the menu to the left, go to Options (at the end of the list).


hide horizontal scroll bar options


  1. 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.

See also

AI Formula Generator

Try for Free

See all How-To Articles