MS Excel Backstage

Excel Backstage

The Backstage view is a new feature included in Excel 2010 to allow users print sheets, open sheets, share sheets and many more all from only one stage. For this, you should click on File Tab present at top left corner of window.
Excel Backstage

In case you are already working in an excel sheet, Backstage View will show details about recently opened sheet. Once you select an option on first column, two more columns open showing the information related to options selected as shown below
The First column will show the following options.
SaveThis option allows you to save the changes made to a new or already existing file before closing. If you forget to save, this option will immediately prompt you to save the file and provide a valid name to the sheet.
Save AsThis option allows you to save the changes you made to a file for the first time and assign new name to your file in .xlsx default format Microsoft Excel 2010
OpenThis option lets you open a file already created earlier for viewing or editing.
CloseThis option lets you to close the current file
InfoThis option provides you the information about the opened file.
RecentThis option displays all the files that you have recently opened.
NewThis option lets you open a new excel sheet.
PrintThis option lets you print pages from the currently opened excel file.
Save & SendThis option lets you save and send the opened file to anyone using email and other options.
HelpThe option lets you access help on the various excel topics in the Microsoft excel 2010.
OptionsYou can set various other options related to file using this option in Microsoft Excel 2010.
ExitThis option closes and allows exit of Excel application.

Sheet Information

On clicking the Info tab, you will find following options
  • Compatibility Mode: If the opened excel file was created in previous version of Microsoft Excel 2007 a convert button will allow you to change its format to new excel format.
  • Permissions: This option limits the file access by creating a password. This password will work as a key to open the file and even to lock the file that disables anyone to make any changes to it.
  • Prepare for Sharing: This option tells you about various details of your file by highlighting them before you plan to share the file.
  • Versions: This option lets you access the previous saved versions of the file in case you have saved it many times.

Sheet Properties

On clicking the Info tab, you will find third column that consists of various properties like categories, title, sheet size, tags etc. These options also let you edit displayed properties.

Exit Backstage View

You can easily exit from the Backstage View by simply pressing the Esc button on the keyboard or using the File Tab. This will take you to the Excel File working mode.

Excel Entering Values

Inserting values or texts in the excel sheet is very simple. By default, your will get a black new excel sheet when you start the application as shown below:
The area in the Excel File where you can enter the text is termed as the Sheet area. The particular vertical bar where your text will appear is termed as the insertion point and it is highlighted on clicking the box. You can start entering text by double clicking on the box. 
You can now simply move your mouse cursor at the insertion point and start entering the text by typing in. The following figure shows the Excel Sheet where “Hello Excel” has been typed into the insertion point.
As you will start typing, the following three points will assist you in typing:
  • You can move to the next column by pressing Tab.
  • You can move to the next row by pressing Enter.
  • You can also create a new line in the same column by pressing Alt + Enter.

No comments: