Excel For Mac 2016 How To Get To The Backstage Area

Home > Document > Excel > Where is Excel Options in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

Where is Excel Options in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365?

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.

  • Excel Backstage View is the area in Excel program window where you can manipulate the properties of Excel file itself. To open Excel Backstage View, click 'File' Tab in Excel Ribbon, as shown in below image. Excel Backstage View is opened, as shown in below image. Excel Backstage view has a three-column structure as shown in above image.
  • This topic itemizes all keyboard shortcuts for Excel 2016 for Mac. Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel 2016 for Mac. However, not all do.
  • Excel 2016 and higher. When you click on File in Excel 2016 and higher you can see a different amount of buttons and tabs in Backstage View. The first image is from Excel up to date in Aug-2019 and the second from the first few versions of Excel 2016. Note: the names and idMso's in blue in the table are the tabs. After a Excel 2016 update.

On the Page Layout tab, in the Page Setup group, click Breaks, and then click Insert Page Break. Move a page break On the View menu, click Page Break Preview. Rest the pointer on the page break line until the pointer changes to a, and then drag the page break line.


Familiar way to open Excel Options if you have Classic Menu for Office

If have installed Classic Menu for Office on your computer, you will discover that the classic style drop down menus and toolbar come back into Ribbon under Menus. So you can follow your use habit in Excel 2003 to seek for Excel Options in Microsoft Excel 2007/2010/2013:

  • Click the Tools drop down menu under Menus tab;
  • Then you will view the Excel Options item. Click it, and you will enter into Excel Options window.

Figure 1: Open Excel Options window from Classic Menu

Open Excel Options from Excel 2007 Ribbon if you do not have Classic Menu for Office

  • Click the Office button at the upper-left corner;
  • At the bottom, you will view the Excel Options button. Click it into Excel Options Window.

Figure 2: Excel Options button in Excel 2007 Ribbon

Open Excel Options from Excel 2010/2013/2016/2019 Ribbon if you do not have Classic Menu for Office

  • Click the File tab jumping into backstage view;
  • Then you will view the Options button at left bar. Click it into Excel Options window.

Figure 3: Open Excel Options window from Excel 2010 Ribbon

Excel For Mac 2016 How To Get To The Backstage Area In The World

There is another way to find out the Options button in the backstage view:

For

Excel For Mac 2016 How To Get To The Backstage Area In Photography

How
  • Click the File tab;
  • Click the Help button at left bar;
  • In the middle pane, you will view the Options button under the Tools for Working With Office.

More Tips for Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

Classic Menu for Office

It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.


Classic Menu for Office 2007

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Screen Shot of Classic Menu for Excel

Comments are closed.