MS Excel Basics

Editing Worksheet

In Microsoft Office applications (e.g., Word, Excel, PowerPoint, Outlook) versions 2007 and later, there is an option for the Backstage View allowing you to manipulate aspects of a file. Backstage View is accessible by clicking the 'File' tab near the top-left of the application window. Contoso Potluck Solution and CLOSE Excel. Take Note Specifying a print area from the Backstage view does not save the setting with the workbook. If you want to save the print area for later use, select the range for the print area, and then on the Page Layout tab, click Print Area, and then Set Print Area. To reset the print area, select Print.

Formatting Cells

Formatting Worksheets

Working with Formula

Advanced Operations

MS Excel Resources

Selected Reading

Excel 2016 Get To The Backstage Areas

The Backstage view has been introduced in Excel 2010 and acts as the central place for managing your sheets. The backstage view helps in creating new sheets, saving and opening sheets, printing and sharing sheets, and so on.

Getting to the Backstage View is easy. Just click the File tab located in the upper-left corner of the Excel Ribbon. If you already do not have any opened sheet then you will see a window listing down all the recently opened sheets as follows −

Excel 2016 Get To The Backstage Area

If you already have an opened sheet then it will display a window showing the details about the opened sheet as shown below. Backstage view shows three columns when you select most of the available options in the first column.

First column of the backstage view will have the following options −

S.No.	Option & Description
1	Save If an existing sheet is opened, it would be saved as is, otherwise it will display a dialogue box asking for the sheet name.
2	Save As A dialogue box will be displayed asking for sheet name and sheet type. By default, it will save in sheet 2010 format with extension .xlsx.
3	Open This option is used to open an existing excel sheet.
4	Close This option is used to close an opened sheet.
5	Info This option displays the information about the opened sheet.
6	Recent This option lists down all the recently opened sheets.
7	New This option is used to open a new sheet.
8	Print This option is used to print an opened sheet.
9	Save & Send This option saves an opened sheet and displays options to send the sheet using email etc.
10	Help You can use this option to get the required help about excel 2010.
11	Options Use this option to set various option related to excel 2010.
12	Exit Use this option to close the sheet and exit.

Sheet Information

When you click Info option available in the first column, it displays the following information in the second column of the backstage view −

Compatibility Mode − If the sheet is not a native excel 2007/2010 sheet, a Convert button appears here, enabling you to easily update its format. Otherwise, this category does not appear.
Permissions − You can use this option to protect the excel sheet. You can set a password so that nobody can open your sheet, or you can lock the sheet so that nobody can edit your sheet.
Prepare for Sharing − This section highlights important information you should know about your sheet before you send it to others, such as a record of the edits you made as you developed the sheet.
Versions − If the sheet has been saved several times, you may be able to access previous versions of it from this section.

Sheet Properties

When you click Info option available in the first column, it displays various properties in the third column of the backstage view. These properties include sheet size, title, tags, categories etc.

You can also edit various properties. Just try to click on the property value and if property is editable, then it will display a text box where you can add your text like title, tags, comments, Author.

Exit Backstage View

It is simple to exit from the Backstage View. Either click on the File tab or press the Esc button on the keyboard to go back to excel working mode.

See Full List On Tutorialspoint.com

The following post about Backstage View is excerpted from Microsoft Word In 30 Minutes.

Word 2016’s Backstage View screen is a one-stop shop for many common tasks, including starting new documents and saving files. The Windows version of Backstage View also includes additional features, such as exporting files, printing, and changing certain software settings.

You can get to Backstage View at any time by clicking on File (Windows or Word Online) or the File icon (macOS) located at the top left of your screen. Navigating Backstage View is easy, thanks to the simple menu displayed on the left side of the screen:

We will go into more detail on many of these menu items later in the book. For the time being, here’s a quick overview of the tools in Backstage View for the Windows version of Word 2016: Pasword skidrow pes 2010 rar.

Info. Review your document’s properties such as file size, page count, and word count. You can also access tools for protecting, inspecting, and managing the document.
New. Start a new document from scratch or select a template for customization.
Open. Open an existing document stored on your computer, network, or the cloud.
Save and Save As. Select one of these options to save your document under its current file name or save a copy in a new location, under a new file name or as a different file type.
Print. This is where you will go when it’s time to print your Word document.
Share. Word 2016 includes a number of collaboration features. You will learn the basics of sharing documents in Chapter 5 of Microsoft Word In 30 Minutes.
Export. Save a document as .doc or .docx, or create a PDF version.
Close. If you don’t want to close your Word document using the “X” in the top-right corner of the document, you can click Close in Backstage View.
Account. If you have purchased an Office 365 subscription, you can access your account settings and recent updates here.
Options. Word 2016 includes plenty of settings you can customize to your liking.

To exit the Backstage View screen and return to your document, simply click on the back arrow at the top of the menu (Windows or Word Online) or click the Cancel button (macOS).

Backstage View for the Mac version of Word 2016 covers new file creation and opening existing documents, as well as access to basic account information. However, Save As, Print, Share, Export, and Close are not visible from the Mac version of Backstage View and have to be accessed via the File drop-down menu at the top of the screen. As for Options, many settings in the Mac version of Word 2016 can be accessed via Word > Preferences.

Backstage View in Word Online is similar to the full Windows version, but does not include Options or Account.