How to show or hide Vertical & Horizontal Scroll bar in Microsoft Excel 2016 ?

You can scroll through the worksheet using the horizontal and the vertical scroll bars which can be found at the bottom and the right side respectively.

Here’s a simple tips demonstrating how you can turn show or hide the scroll bars in Microsoft Excel 2016 using Excel Options Dialog.

How to show or hide Vertical and Horizontal Scroll bar in Microsoft Excel 2016 ?

1. Click File from the Ribbon and select “Excel Options”.

2. In the Excel Options dialog , select “Advanced” category from the left sidebar. and scroll down to the “Display options for this workbook” section and uncheck the options “Show horizontal scroll bar” and “Show vertical scroll bar” to turn off the scroll bars and then click the OK button.

image

To turn on the scroll bars back , follow the above steps and then enable both of the options.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...