Changes to Excel 2016's interface include modifications to the layout of the Start, New, and Save As screens, new options on the File menu and Quick Access toolbar, simplified Ribbon icons, an Active Tab indicator, as well as new Ribbon tabs and command buttons.
Figures 1-1 through 1-4 in the Display Screen and Menu Updates gallery above show you the first part of the modified layouts of the Start, New, Open, and Save As screens, respectively, in Excel 2016. The biggest change to the Start menu in Fig. 1-1 (beside the greeting) is the appearance of Pinned and Shared with Me category options along with the default Recent option that lists workbook files you've edited lately. These options make it easy to open workbooks you've recently shared or pinned because you often work with them. The biggest change to the Open screen shown in Fig. 1-3 is the Folders option that enables you to switch from a list of pinned or recently edited workbooks to a list of pinned or recently opened folders that may contain the workbook file you want to work with (a folder list similar to the one shown on the Save AS screen in Fig. 1-4).
The following three submenus have been added to the File menu in the Excel 2016 Backstage view:
Fig.1-6 in the Display Screen and Menu Updates gallery above shows the Quick Access toolbar with the new AutoSave and Add-Ins buttons, The AutoSave button indicates when the edits you make to any workbook saved in the cloud on OneDrive or one of your SharePoint sites are automatically saved. The Add-ins button on the right side of the Quick Access toolbar contains the following three menu options for adding new features to Excel:
Until very recently, the only way to quickly and easily identify which tab on the Excel Ribbon was active was by scanning the command icons displayed on it. Now, with the introduction of the Active Tab indicator, you can tell at once which tab is current without reference to any of the command buttons displayed below. The Active Tab indicator (the heavy green underline) shown above the mouse cursor in Fig. 1-7 in the preceding Ribbon and Tab Updates gallery immediately tells you that the Home tab is current without looking at any of its command icons. Likewise, in Fig. 1-8 in the same gallery, you can tell at a glance that the Insert tab is now active because the Active Tab indicator now appears under its tab label.
In an attempt to make Office apps such as Excel faster and easier to navigate on all the devices on which it runs, Microsoft has simplified the icons representing various commands on the tabs of the Ribbon. By and large, these simplified icons are a bit larger than the original as well as a bit flatter in appearance (see Fig. 1-8 in the Ribbon and Tab Updates gallery above). Simplified icons now appear in all current versions of Office applications, including Excel 2016 and 2019.
Microsoft has replaced the original Help window in Excel 2016 with a new Help task pane (F1) and Help tab on the Ribbon (see Fig. 1-9 in the Ribbon and Tab Updates gallery above). The Help tab contains command buttons that enable you to open the Help tab, contact support. suggest new features, review basic tutorials, as well as go online for information on using Excel. The Help task pane enables you to search for help topics as well as select help on accomplishing common tasks such as entering formulas and functions, formatting your worksheet, creating tables and charts, and so forth.
Excel 2016 now makes it easy to mark up your worksheets with ink using your finger or a stylus and the command buttons on the Draw tab (see Fig. 1-10 in the Ribbon and Tab Updates gallery above). The Draw tab now includes more options for the pens you select as well as a Add Pen button that makes it easy to define a custom pen, pencil, or highlighter to use in inking. In addition, the tab includes new Ink to Shape and Ink to Math command buttons that enable you to convert ink to actual drawn shapes in your worksheet.
The new Acrobat tab that appears on the Excel 2016 Ribbon contains command buttons makes it easy to convert your worksheets into Adobe PDF files as well as send them out for review using the Acrobat PDF Maker (see Fig. 1-11 in the Ribbon and Tab Updates gallery above). When you send out a converted PDF worksheet to team members in this fashion, they can then comment on its contents and send them back to you using Adobe Acrobat Reader DC (Document Cloud) app.
Copyright © 2018 Mind Over Media® - All Rights Reserved.