Display Options For Workbook in Excel

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

About Smart Office - philippospan

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on July 25, 2017, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Display Options For Workbook in Excel.

Comments are closed.