{"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 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> <\/a><\/p>\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 Hiding or disabling the Horizontal and Verical scroll bar, is possible via excel vba too. Here are the articles, you can read:<\/p>\n In one of the Article, I had shown how to hide or display the Horizontal and Vertical Scroll Bar of an Excel Workbook using Excel VBA code. Now here I am going to show how can we DISPLAY or HIDE, Horizontal or Vertical Scroll Bar in an Excel Workbook by choosing excel option manually. Excel […]<\/p>\n","protected":false},"author":45,"featured_media":13931,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1673],"tags":[],"class_list":["post-12092","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-formula","category-excel-functions"],"yoast_head":"\nExcel 2003<\/h2>\n
\n
\nStep 2. Go to “View Tab” in the Dialog Box.
\n
\nStep 3. In the “Window Option” section, we have Check boxes for Horizontal and Vertical Scroll Bars.
\n
\nStep 4. To Hide\/Display<\/strong> these Bars, Uncheck\/Check<\/strong> the Check Box and Click OK<\/p>\nExcel 2007<\/h2>\n
\nStep 2. Click on “Excel Options”
\n
\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
\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>\nHide or disable the Horizontal or Vertical Scroll bar using the VBA code<\/h1>\n
\n