{"id":12092,"date":"2011-11-20T08:40:52","date_gmt":"2011-11-20T08:40:52","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=731"},"modified":"2022-08-02T21:44:53","modified_gmt":"2022-08-02T21:44:53","slug":"hide-horizontal-or-vertical-scroll-bar-in-excel-workbook","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/hide-horizontal-or-vertical-scroll-bar-in-excel-workbook\/","title":{"rendered":"Hide Horizontal or Vertical Scrollbar in Excel Workbook"},"content":{"rendered":"

In one of the Article,<\/a> I had shown how to hide or display the Horizontal and Vertical Scroll Bar of an Excel Workbook using Excel VBA code.<\/span> Now here I am going to show how can we DISPLAY or HIDE<\/strong>, Horizontal or Vertical Scroll Bar in an Excel Workbook by choosing excel option manually.<\/p>\n

Excel 2003<\/a> || Excel 2007<\/a><\/span><\/p>\n

<\/a><\/p>\n

Excel 2003<\/h2>\n

In Excel 2003, follow the below steps to hide or display the horizontal or vertical Scroll bar:<\/p>\n

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

<\/a><\/p>\n

Excel 2007<\/h2>\n

In Excel 2007, follow the below steps to hide or display the horizontal or vertical Scroll bar:<\/p>\n

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

Hide or disable the Horizontal or Vertical Scroll bar using the VBA code<\/h1>\n

Hiding or disabling the Horizontal and Verical scroll bar, is possible via excel vba too. Here are the articles, you can read:<\/p>\n