Go to the Backstage View by clicking on the File tab in the Ribbon. Step #2: Click On The Enable Content Button And Select Advanced Options Once you're in the Backstage View, you'll notice the prominent security warning which Excel uses to inform you that macros have been disabled.
- MS Excel Basics
- Editing Worksheet
- Formatting Cells
- Formatting Worksheets
- Working with Formula
- Advanced Operations
- MS Excel Resources
- Selected Reading
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 −
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 | 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. Vocalizer tts all voices torrent. 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.
To save paper and your sanity, print your Excel 2016 worksheet directly from the Print screen in Excel’s Backstage view by clicking File→Print (or simply pressing Ctrl+P or Ctrl+F2). As you see here, the Print screen shows you at-a-glance your current print settings along with a preview of the first page of the printout.
Funimation fairy tail episode 184. Nonton anime & download anime Fairy Tail (2014) Episode 178 Subtitle Indonesia lengkap full episode & batch - Nonton Anime.
You can also add a Print Preview and Print command button to the Quick Access toolbar that opens this Print screen in the Backstage view. Simply click the Customize Quick Access Toolbar button followed by the Print Preview and Print option on its drop-down menu to add this button at the end of the toolbar. Then click this button anytime you want to preview a report before sending it to your printer.
You can use the Print Preview feature in the Print screen before you print any worksheet, section of worksheet, or entire workbook. Because of the peculiarities in paging worksheet data, you often need to check the page breaks for any report that requires more than one page. The print preview area in the Print panel shows you exactly how the worksheet data will page when printed. If necessary, you can return to the worksheet where you can make changes to the page settings from the Page Layout tab on the Ribbon before sending the report to the printer when everything looks okay.
When Excel displays a full page in the print preview area, you can barely read its contents. To increase the view to actual size to verify some of the data, click the Zoom to Page button in the lower-right corner of the Print panel. Check out the difference here — you can see what the first page of the four-page report looks like after you zoom in by clicking this Zoom to Page button.
After you enlarge a page to actual size, use the scroll bars to bring new parts of the page into view in the print preview area. To return to the full-page view, click the Zoom to Page button a second time to deselect it.
Excel indicates the number of pages in a report at the bottom of the print preview area. If your report has more than one page, you can view pages that follow by clicking the Next Page button to the right of the final page number. To review a page you’ve already seen, back up a page by clicking the Previous Page button to the left of the first page number. (The Previous Page button is gray if you’re on the first page.)
To display markers indicating the current left, right, top, and bottom margins along with the column widths, click the Show Margins button to the immediate left of the Zoom to Page button. You can then modify the column widths as well as the page margins by dragging the appropriate marker.
When you finish previewing the report, the Print screen offers you the following options for changing certain print settings before you send it to the printer:
Print button with the Number of Copies combo box: Use this button to print the spreadsheet report using the current print settings listed on the panel. Use the combo box to indicate the number of copies you want when you need multiple copies printed.
Printer drop-down button: Use this button to select a new printer or fax to send the spreadsheet report to when more than one device is installed. (Excel automatically displays the name of the printer that’s installed as the default printer in Windows.)
Settings drop-down buttons: These include a Print What drop-down button with attendant Pages combo boxes: Use the Print What drop-down button to choose between printing only the active (selected) worksheets in the workbook (the default), the entire workbook, the current cell selection in the current worksheet, and the currently selected table in the current worksheet. Use the Pages combo boxes to restrict what’s printed to just the range of pages you enter in these boxes or select with their spinner buttons.
Beneath the combo boxes, you find drop-down list buttons to print on both sides of each page in the report, collate the pages of the report, and switch the page orientation from Portrait (aligned with the short side) to Landscape (aligned with the long side). Additionally, you can select a paper size based on your printer’s capabilities other than the default 8.5″ x 11″ letter, and customize the size of the report’s margins (top, bottom, left, and right, as well as the margins for any header and footer on the page).