File Backstage

In Excel 2010 the Office button was replaced with the File Tab.
This is also commonly known as backstage view.
This tab is displayed in different colours in the different applications.

Save

Saves the active workbook.

History

(Added in 2016)

Close

Closes the active workbook.

Feedback

(Added in 2016)

Customising

This tab / window is fully extensible and can be totally customised.
For more details, please refer to the Customize Ribbon page.

Start Screen

When you open a new instance of Excel a start screen will be displayed.

Check your Options

The Start Screen will be displayed when this option is ticked.
Check your (Excel Options)(General tab, Show the start screen when this application starts)
When this is not ticked, a default blank workbook will be displayed instead.

Start Screen

Instead of seeing a blank workbook, you see the File, Home tab instead. Also known as the Start Screen.
This gives you a choice of clicking on "Blank Workbook" or choosing your first workbook to open.

File Tab

Once a workbook has been opened (regardless of whether it has been saved) a lot more options will appear.

Info

Protect Workbook

This drop-down controls what types of changes users can make to the active workbook.

Mark as Final - Saves the workbook as read-only to prevent accidental changes and discourage editing. Typing, editing and proofing commands are all disabled.

Encrypt with Password - Displays the "Encrypt Document" dialog box letting you add a password. This will be required when the workbook is opened. Your workbook remains open after the password has been added.
Protect Current Sheet - Displays the "Protect Sheet" dialog box.
Protect Workbook Structure - Displays the "Protect Structure and Windows" dialog box.
Restrict Access - (Removed in 2016) Grant people access while removing their ability to edit, copy and print.
Add a Digital Signature - Displays the "Sign" dialog box.
Protecting Workbooks

Inspect Workbook

This drop-down checks for any potential issues before sharing the active workbook.

Inspect Document - Displays the "Document Inspector" dialog box.
Check Accessibility - Displays the Accessibility Checker task pane.
Check Compatibility - Displays the "Compatibility Checker" dialog box.

Manage Workbook

This drop-down lets you access previous versions.

Check Out - (only shown ??) Edit a private copy and prevent other people from making changes.
Recover Unsaved Workbooks - (Added in 2010) Displays the Open dialog box defaulting to the "username"/Local/Microsoft/Office/Unsaved folder.
Delete All Unsaved Workbooks - (Added in 2013) This will delete all draft versions of unsaved files.
Refresh Server Version List - (Removed in 2016) Check the server for the latest versions.

Browser View Options

This displays the "Browser View Options" dialog box. This lets you choose which worksheets and named items will be shown when the workbook is viewed in a browser.

Properties

This displays the most useful Workbook Properties.

Properties - Drop-Down.
Open File Location -
Show All Properties -

New

Lets you create a blank workbook and access any workbook templates.
Search - This is disabled.

Open

This displays a list of recently opened files.
The shortcut keys (Ctrl + F12) and (Ctrl + O) will quickly display the Open dialog box
You can pin a file to the list by hovering over it and clicking on the pin.
Any pinned files will stay at the top of the list.

Recent Workbooks - Displays a list of the workbooks you last opened.
OneDrive - Lets you open a file from OneDrive.
OneDrive - Personal - Lets you open a file from OneDrive.
Other Web Locations -
This PC - Displays a list of recent folders and a Browse button allowing you to browse to any folder.
Browse -
Add a Place - Lets you add locations from SharePoint or OneDrive.

Save As

This displays a list of recently saved to folders.
You can pin a folder to the list by hovering over it and clicking on the pin.

OneDrive - Lets you save a file to your OneDrive.
OneDrive - Personal -
Other Web Locations -
This PC - Displays the current folder. Displays a list of recent folders and a Browse button allowing you to browse to any folder.
Add a Place - Lets you add locations from SharePoint or OneDrive.
Browse - (Added in 2016)

Print

A preview of the workbook is display on the right hand side of the screen.

Print - Prints the active worksheet to your default printer.
Copies - Lets you choose the number of copies.

Printer

Printer - Displays a drop-down list of available printers.
Printer Properties - Displays the selected printer properties dialog box. These specific options will depend on the type of printer(s) connected.

Settings

Displays the common options from the Page Setup dialog box.

Print What - This drop-down contains the following options:
Print Active Sheets - (default)
Print Entire Workbook -
Print Selection -
Ignore Print Area -
Print Range - All the pages will be printed by default however you can print just a selection of pages by entering values into the To and From boxes.
Print Options - This drop-down contains the options:
Print One Sided - (Added in 2016, Removed in 2016)
Print On Both Sides - Flip pages on long edge
Print On Both Sides - Flip pages on short edge
Collated - The drop-down contains the options: Collated, Uncollated
Orientation - The drop-down contains the options: Portrait Orientation and Landscape Orientation
Paper Size - A4, Letter, More Sizes
Margins - Last Column Setting, Normal, Wide, Narrow, Custom Margins
Scaling - No scaling, Fit Sheet on One Page, Fit All Columns on One Page, Fit All Rows on One Page, Custom Scaling Options

Page Setup

Page Setup dialog box.

Share with People - Lets you save the file to a OneDrive location.
Email - Send as Attachment - Creates a new email with a copy of the active workbook as an attached file.
Email - Send a Link - Creates a new email with a hyperlink to the active workbook.
Email - Send as PDF - Converts the active workbook to PDF format and attaches it to a new email.
Email - Send as XPS - Converts the active workbook to XPS format and attaches it to a new email.
Email - Send as Internet Fax - Sends the active workbook as a fax using an online fax service provider.

Export

Create Adobe PDF -
Create PDF/XPS Document -
Change File Type - Please refer to Workbooks > File Extensions for more information.

Publish

Publish to Power BI -
Save to Cloud -

Account

SS - top level

Office Background -

Office Theme -

Connected Services -

Manage Account -
Displays information about your account if you are signed in.

Update Options -

About Excel - Displays the About dialog box telling you which version of Office you are using.
Whats New - Displays the latest Whats New in Excel dialog box.

Feedback

Options

Shortcut Key is (Alt + F, T)

M.S EXCEL File Backstage

File Backstage