Browser View Options In Excel 2016

In Excel 2016, we have the option to specify how we want a Workbook to be displayed in a browser window. This way we can choose what we want to be viewed in our Workbook, when other people view it in a browser window. This is where the Browser View Options command appears in Excel. All you need to do is to follow the steps below:

First of all, we must select the File tab in order to move to backstage view. Once in backstage view, we make sure the Info category is selected from the left and then from the middle of the drop down menu we navigate and locate the area named Browser View Options as shown in the image below. Here we are notified that we can Pick What Users Can See When This Workbook Is Viewed On The Web.

Browser View Options

Once we select the Browser View Options command, the Browser View Options window appears as shown in the image below. This window is separated by two tab, the Show tab and the Parameters tab. In the image below the Show tab is activated, where we can choose the sheets and the named items that we want to be shown when viewed in the browser.

In the image below, the Entire Workbook view option is selected and right below we notice that all our Sheets in our Workbook are activated.

Browser View Options - Show

In the image below, I have activated the drop down menu, where we can choose from either one of the following:

  • Entire Workbook
  • Sheets
  • Items in the Workbook

Browser View Options - Show

In the image below I have selected from the drop down menu Sheets, and right below we have the option to activate or deactivate the Sheets that are in our Workbook.

Browser View Options - Show

In the image below I have selected from the drop down menu Items In The Workbook, and right below we have the option to activate or deactivate the Items that are in our Workbook.

Browser View Options - Show

In the following image I have activated the Parameters tab. Once on the Parameters tab, we can either Add a Parameter that is in our Workbook by using the Add button. Once we have added parameters in the Browser View Options, we can either Delete it, or Delete All in case we have added many of them.

Browser View Options - Parameters

Once we have finished all the adjustments needed in the Browser View Options window, we press the Ok button in order to return to our Workbook.

Below you can check out the video describing the Browser View Options command in Excel 2016.

About officesmart

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 October 4, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Browser View Options In Excel 2016.

Comments are closed.