After starting Excel 2010, the software presents itself as you can see in the following figure. At first glance, the Ribbons and symbols seems not to have been changed. However, we can notice that the Office Button has now a new look.
Lets explore it more. When clicking on the drop button (red bordered area in the image above), you can see some common tasks in the Office Backstage (the new designation of this area) and, if you had opened and/or saved some documents before, the list of recent documents.
On the upper right-hand side, you can see a little pin for permanently store this document in the list. A feature that also was present in Excel 2007. Lets now click on “New” for creating new documents.
While Excel 2007 loaded a separate dialog, all relating tasks can be now accomplished in the Office Backstage. Very nice. Like Excel 2007, you can explore with Excel 2010 the template directory on Microsoft Online. For example, I searched a calendar template from there. Navigating within the online directory is more intuitive now, a breadcrumb allows you to quickly browse the directory.
Lets go back by first clicking on “Home” and then create a new workbook by selecting “Blank Workbook” in the list and clicking on “Create”. As you can see in the next figure, I filled and formatted some cells in the first worksheet of the workbook. The I saved the workbook as “Textdatei.xlsx” (German file).
When calling the Office Backstage again, we get more information about this workbook. In essence, this dialog contains the same functionality as in Excel 2007, but these tasks are significantly easier to achieve in Excel 2010.
Clicking on “Protect Workbook” calls a submenu, where you can find options to encrypt the document, to protect your workbook or your worksheets with a password or to add a digital signature. In Excel 2007, some of these options were located in different places. When clicking on “Check Issues”, you can choose between inspecting your current document or checking the accessibility and compatibility of your workbook and worksheets. A new and very interesting feature is the accessibilty check of your document, which scans the document for informations that people with disabilities could hav difficulties to read. Performing this check on our document shows a warning, that names for tables like “Sheet1” may be avoided. The last button “Manage Versions” offers options to recover draft versions or delete them.
Lets now call the “Print” option in the backstage. The view contains most common tasks, for example selecting the printer, specifying which sheets should be printed, selecting the paper settings, margins or orientation.
When clicking on “Share”, the backstage looks like in the figure above. You’ll find here option for mailing the workbook or sheets, creating PDF or XPS documents or publishing the current document on servers like Sharepoint. A little bit confusing is the option to save the workbook in different file formats.
The other options on the left side of the Office Backstage allows you to call the Excel Options or Commands from external Addins. We will talk about these option in later articles in our blog.
This article has also been published in German and in English on the following sites:
- Excel Ticker Blog, German
- Professional Excel Solutions by Maninweb.de, English
- Professional Excel Solutions by Maninweb.de, German