Sheet Information, Sheet Properties & Exit Backstage View

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.

Post a Comment

0 Comments