In one of the Article, i had shown how to hide or display the Horizontal and Vertical Scroll Bar of an Excel Workbook. Now here I am going to show how can we DISPLAY or HIDE, Horizontal or Vertical Scroll Bar in an Excel Workbook.

Excel 2003 || Excel 2007

Excel 2003

In Excel 2003, follow below steps to hide or display horizontal or vertical Scroll bar:

Step 1. Go to Tools –> Options
Scroll-Bar-in-Excel
Step 2. Go to “View Tab” in the Dialog Box.
Scroll-Bar-in-Excel
Step 3. In “Window Option” section, we have Check boxes for Horizontal and Vertical Scroll Bars.
Scroll-Bar-in-Excel
Step 4. To Hide/Display these Bars, Uncheck/Check the Check Box and Click OK

Excel 2007

In Excel 2007, follow below steps to hide or display horizontal or vertical Scroll bar:

Step 1. Click on “Home” Button of the Excel Workbook
Step 2. Click on “Excel Options”
Scroll-Bar-in-Excel
Step 3. Go to “Advanced Tab”in the Excel Option Dialog Box.
Step 4. Go to “Display Options for this Workbook” Section
Scroll-Bar-in-Excel
Step 5. Here there are two check boxes for Horizontal and Vertical Scroll Bar Displaying
Step 6. To Hide/Display these Bars, Uncheck/Check the Check Box and Click OK

Read this Also:

cover3d_0-89071700_1484285537__1_

Join over 10, 000+ Excel VBA Enthusiasts & get this FREE e-Book Now!