When you launch Microsoft Excel 2016, it automatically opens the Recent and New screens. Before you start building that workbook, searching Excel 2016’s template gallery for existing templates, can save you a lot of time and work.
Hold down the control key on your keyboard and press O (the letter not the number) whilst you are in your regular worksheet view.Ĭreating a new workbook can be a lot of fun! Firstly, decide what you would like to achieve with your workbook, for example, do you need an invoice, contact list, financial statement or a personal budget. TIP: The keyboard shortcut combination, Ctrl+O will quickly navigate to the Open section of the Backstage view. Once unpinned, the workbook will move down the Recent list and once pinned, it will move to the top of the list. By clicking to the right of each worksheet in your Recent area, you can pin and unpin workbooks. In the area numbered 4 in the screenshot above, you will note pins which appear on the right-hand side of each worksheet. A Pinned workbook is one that you use frequently. The Recent section displays workbooks in date order of when they were accessed, with Pinned workbooks always displayed at the top of the list.Ĥ. Recent and Pinned are options that make it easy to find workbooks you used recently or ones you repeatedly need to access quickly. Locate the workbook in your preferred location and click to open.ģ. With Microsoft Office 365 you can browse for worksheets that you used recently, that were shared with you via a Microsoft Online OneDrive account, your own cloud-based OneDrive account, documents hosted on a corporate SharePoint Server or on your traditional computer hard drive. Worksheet location – select where the workbook you are looking for is saved. This will launch the Open section of the Backstage view, as shown in the screenshot below:Ģ. In the Backstage view tabs list, click on Open. To open an existing workbook, click on the File tab to launch the Backstage view.ġ. At first glance it may appear that there is not much to opening a workbook, you double click the workbook icon in a folder or email attachment, and it opens, right? There are a couple of workbook opening tricks you may not be aware of, for example, you can quickly open workbooks that you used recently without having to spend time finding them.
* How to Open Excel Workbooks in Excel 2016 To get started in Excel 2016, you may want to open a workbook that you created earlier or one that has been shared with you by another MS Office user. The properties area provide you with useful information such as when the workbook was created and by whom.
These are security and workbook sharing options, you can use these to, for example, password protect a workbook.ĥ. If the worksheet has no name yet, this will be Book1, Book2, etc.Ĥ. Click on these to navigate to different options.ģ. Backstage view tabs – these are all the different option areas for the Backstage view. The Back button – this will take you back to your worksheet and exit the Backstage view.Ģ. These options, as numbered in the screenshot below, are as follows:ġ. This will launch the Backstage view that opens on the Info page by default.ĭepending on which tab you click on in the Backstage view, you will be presented with different options. In an open Excel workbook, click on the File tab:Ģ. To access the wonderful world of the Excel 2016 Backstage view:ġ. Similar to the behind the scenes activity of a stage play, the Backstage view in Excel contain all the tools needed to create, manage and share an Excel workbook.
Test your Excel skills with the corresponding FREE Online Multiple Choice The File Tab and Backstage View – 2016 Excel Basics Test The File button in Excel provides access to workbook saving, retrieving, information, security settings and a multitude of other options, which are not readily available in the normal workbook view.Īptly named the Backstage View, this is where you will find all the tools you need to create and manage Excel workbooks like an expert!
* Excel to PDF – Create PDF copies of Worksheets to Share in Excel 2016 * Save Workbooks and Recover Unsaved Workbooks * How to Open Excel Workbooks in Excel 2016 * The areas of the Backstage View – Excel 2016 Learn Excel Basics Lesson Free Online Microsoft Excel Tutorial
The File Tab & Backstage View Excel Tutorial The File Tab and Backstage View Excel Tutorial – Excel 2016 Tutorial – Learn Excel Basics Lesson – Free Online Microsoft Excel Tutorial