Hide Horizontal or Vertical Scrollbar in Excel Workbook
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
In Excel 2003, follow below steps to hide or display horizontal or vertical Scroll bar:
Step 1. Go to Tools –> Options
Step 2. Go to “View Tab” in the Dialog Box.
Step 3. In “Window Option” section, we have Check boxes for Horizontal and Vertical Scroll Bars.
Step 4. To Hide/Display these Bars, Uncheck/Check the Check Box and Click OK
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”
Step 3. Go to “Advanced Tab”in the Excel Option Dialog Box.
Step 4. Go to “Display Options for this Workbook” Section
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:
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON'T MISS ANY NEW ARTICLE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-Box