M.S EXCEL File Backstage

Your Ads Here

 

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.

Your Ads Here

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

See also: M.S EXCEL Selecting

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. See also: M.S EXCEL File Backstage 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 - Your Ads Here Your Ads Here 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) See also: M.S EXCEL Entering Data 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 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

See also: M.S Excel Shortcut Menus

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)

Personalise your copy of Microsoft Office

Startup Options

Your Ads Here