Display Options For Workbook in Excel

Posted on

Sometimes it may occur to us, when we are working in an Excel Workbook for the Horizontal or Vertical Scroll bar not to be displayed. We may even cannot see the Sheet Tabs, or even nor the Objects that we know exist in our Workbook. What has happened? All will be explained in the post described below.

Display Options for Workbook

First we must open the Workbook that these instances are happening. Then we must select the File tab in order to move to Backstage View. Once in Backstage View, from the drop down menu that appears from the left, we must select the category Options as shown in the image below.

Excel - Info - Options

Once we select the Options command, the Excel Options dialog box appears, where from the left of the window we must locate and select the category Advanced as we can see in the image below.

Excel Options - Advanced

Once the Advanced category is selected, we must navigate with the scroll bar which is located at the right of the dialog box in order to find the area in the Excel Options window which mentions the following as shown in the image below:

Display Options For This Workbook

If we select the drop down menu at the right of this area, we can select from which Workbook the adjustments to take place as shown in the image below.

For This Workbook

Under this area we have available the following commands in order to activate or to deactivate, depending how we want our Workbook to be displayed.

  • Show Horizontal Scroll Bar: The Horizontal Scroll Bar will be displayed or not in our Workbook
  • Show Vertical Scroll Bar: The Vertical Scroll Bar will be displayed or not in our Workbook
  • Show Sheet Tabs: The Sheet Tabs will be displayed or not in our Workbook
  • Group Dates in the AutoFilter Menu: The Full List of Dates will be displayed or not in the AutoFilter Menu
  • For Objects Show: Objects will be displayed or not in the Workbook
  •     All
  •     Nothing (Hide Objects)

Display Options Workbook

Once we have done all the adjustments needed for our Workbook, we must select the OK button which is located at the bottom right corner of the Excel Options window in order for them to take place.

You can check out the video below, which describes the Display Options for Workbook in Excel.

Don’t forget to subscribe to My YouTube Channel.

YouTube Channel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s