Backstage View in Excel 2016

The Backstage view is a feature that provides many options for managing your files. You can save, open, print, and share your workbooks easily. Think of it as the "behind-the-scenes" area for everything that doesn't involve typing data into cells.

How to Access Backstage View

1. Click the File tab on the Ribbon.
2. The Backstage view will appear, giving you access to all file-level tasks.

Key Features of Backstage View

1. Return to Excel

You can use the arrow to close Backstage view and return to your active Excel worksheet.

2. Info

The Info pane will appear whenever you access Backstage view. It contains information about the current workbook, such as file properties and protection settings.

3. New

From here, you can create a new blank workbook or choose from a large selection of templates to jump-start your project.

4. Open

From here, you can open recent workbooks, as well as workbooks saved to your OneDrive or on your computer.

5. Save and Save As

Use Save and Save As to save your workbook to your computer or to your OneDrive cloud storage.

6. Print

From the Print pane, you can change the print settings and print your workbook. You can also see a live preview of your document.

7. Share

From here, you can invite people to view and collaborate on your workbook. You can also share your workbook by emailing it as an attachment.

8. Export

You can choose to export your workbook in another format, such as PDF/XPS or Excel 1997-2003.

9. Publish

Here, you can publish your workbook to Power BI, Microsoft's cloud-sharing service for advanced data visualization.

10. Close

Click here to close the current workbook without exiting the Excel application.

11. Account

From the Account pane, you can access your Microsoft account information, modify your theme and background, and sign out.

12. Options

Here, you can change various Excel options, settings, and language preferences to customize how the program behaves.

FAQs on Backstage View

1. How do I get out of Backstage view?

Simply click the back arrow in the top-left corner or press the Esc key on your keyboard.

2. Is Backstage view different from the Ribbon?

Yes. The Ribbon is for editing the data inside the workbook, while Backstage view is for managing the workbook file itself.

3. Can I customize the Backstage view?

While you cannot change the layout of Backstage view, you can use the 'Options' tab within it to customize Excel's overall behavior.

Conclusion

Mastering the Backstage view in Excel 2016 is essential for efficient file management. Whether you need to print a report, share a file with a colleague, or change your account settings, Backstage view is your go-to destination.