How to show or hide Horizontal Vertical scroll bar in Microsoft Excel We can scroll through the active worksheet with horizontal scroll bar at the bottom and vertical scroll bar at the right side by default. Here we will show you some tips to turn on or off the scroll bars in the Microsoft Excel worksheets. You may interest in Easily unhide all hidden sheets or ranges with several clicks in active workbook You can quickly unhide all hidden sheets or ranges with several clicks as below screenshot shown Kutools for Excel includes more than 1. Excel tools. Free to try with no limitation in 6. Read More      Download the free trial now Show or hide HorizontalVertical Scroll bar with Excel Options. You have to configure Excel settings in Excel Options dialog box, if want to display or hide HorizontalVertical Scroll bar in Excel worksheets. Show or hide HorizontalVertical Scroll bar with VBA code. Annualized Standard Deviation I have quarterly performance returns for a portfolio and I believe I got the annual standard deviation for 2006, 2007, 2008. Re VBA Code to make multiple sheets visible How about setting up an index sheet that would hold a list of Names for each set. Then when you wanted a set visible. Microsoft Excel 2007 Unhide Worksheets Vba' title='Microsoft Excel 2007 Unhide Worksheets Vba' />The following VBA code also can help you show or hide the horizontalvertical scroll bar. Please do as this Step 1 Hold down the ALT F1. Microsoft Visual Basic for Applications window. Step 2 Click Insert Module, and paste the following macro in the Module Window VBA code to hide the horizontal and vertical scroll bar Option Explicit Private Sub WorkbookActivate     With Active. Window        . Display. Horizontal. Scroll. Bar False        . Display. Vertical. Scroll. Bar False     End With End Sub VBA code to show the horizontal and vertical scroll bar Private Sub WorkbookDeactivate     With Active. Window        . Display. Hide-Unhide-Worksheet-Examples-2.png' alt='Microsoft Excel 2007 Unhide Worksheets Vba' title='Microsoft Excel 2007 Unhide Worksheets Vba' />Horizontal. Scroll. Bar True        . Display. Vertical. Scroll. Bar True     End With End Sub. Step 3 Press the F5 key to run this code. And the horizontal and vertical scroll bar will be hidden or shown. Show or hide HorizontalVertical Scroll bar with Kutools for Excel. You can easily display or hide HorizontalVertical Scroll bar in Excel worksheets with the View Options utility of Kutools for Excel. Kutools for Excel with more than 1. Excel add ins, free to try with no limitation in 6. Click the Kutools Show Hide View Options. See screenshot 2 In View Options dialog box, you need to do as follows 1 check or unchecked the Vertical Scrollbar option and Horizontal Scrollbar option according to your needs2 If you just want to show or hide the scrollbar in current worksheet, please click the OK button. But if you want to show or hide the scroolbar in all sheets, please click the Apply to all sheets button. The View Options makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scroll bar, Horizontal Scroll bar, Sheet Tab, etc. It will save your time in looking for these setting when you need to show or hide them. If you want to have a free trial of this utility, please go to free download the software first, and then go to apply the operation according above steps. Showhide HorizontalVertical Scroll bar with Kutools for Excel. Kutools for Excel includes more than 1. 2Nd Edition Introduction Reasoning Synonym. Excel tools. Free to try with no limitation in 6. Download the free trial now Related articles Recommended Productivity Tools Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer. Amazing Increase your productivity in 5 minutes. Dont need any special skills, save two hours every day New Features for Excel, Make Excel Much Easy and Powerful Merge CellRowsColumns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,More SelectInsertDeleteTextFormatLinkCommentWorkbooksWorksheets Tools.