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:
If you already have an opened sheet then it will display a window showing detail 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 following options:| Option | Description |
|---|---|
| Save | If an existing sheet is opened, it would be saved as is, otherwise it will display a dialogue box asking for sheet name. |
| 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 |
| Open | This option will be used to open an existing excel sheet. |
| Close | This option will be used to close an opened . |
| Info | This option will display information about the opened sheet. |
| Recent | This option will list down all the recently opened sheets |
| New | This option will be used to open a new sheet. |
| This option will be used to print an opened sheet. | |
| Save & Send | This option will save an opened sheet and will display options to send the sheet using email etc. |
| Help | You can use this option to get required help about excel 2010. |
| Options | Use this option to set various option related to excel 2010. |
| 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 your 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.
Sheet area is the area where where you type your text. The flashing vertical bar is called the insertion point and it represents the location where text will appear when you type. When you click on a box then box becomes highlighted.When you double click the box flashing vertical bar will come and you can start entering data then. 
There are following three important points which would help you while typing:
You can scroll your sheet by rolling your mouse wheel, which is equivalent to clicking the up-arrow or down-arrow buttons in the scroll bar.
Step (2) : Select a folder where you would like to save the sheet, Enter file name which you want to give to your sheet and Select a Save as type, by default it is .xlsx format.
Step (3) : Finally, click on Save button and your sheet will be saved with the entered name in the selected folder.
Step (2) : Now you'll see the Insert dialog with select Worksheet option as selected from the general tab. Click Ok button
Now you should have your blank sheet as shown below ready to start typing your text.
You can use a short cut to create a blank sheet anytime. Try using Shift+F11 keys and you will see a new blank sheet similar to above sheet is opened.
Step (2) : Now you'll see the Move or Copy dialog with select Worksheet option as selected from the general tab. Click Ok button
Select Create a Copy Checkbox to create a copy of current sheet and Before sheet option as (move to end) so that new sheet gets created at end.
You can rename the sheet by double clicking on it.On double click, name become editable. Enter any name say Sheet5 and press Tab or Enter Key.
Step (2) Select Sheet Name to unhide in Unhide dialog to unhide the sheet.
