In our previous contributions we have already – sometimes more or less detail – presented some new features in Excel 2010. However there are some more new features (such as screenshots) we would like to talk about in this and subsequent articles. We will compare the features of Excel 2007 with them in Excel 2010. As I usually use the german version of Excel 2007, I first changed the language to English before writing this article. Some of the figures below show Excel 2007 in the background and Excel 2010 in the foreground for better comparing. So, let us begin by comparing the ribbons. Please note, that you can click on some images to load a larger view.
If we compare both versions, we will note some changes in the home tab. Please look at the red bordered areas in the figure above. As you can see, the „Paste“ is now disabled per default in Excel 2010. The previous menue entry for copying as a picture has moved to the „Copy“ button. And the entries of the „Copy“ button in Excel 2010 were redesigned in Excel 2010.
We already have written an article about. On the home tab, you will also find a new button for settings the text direction from left to right, right to left or using the context.
Excel 2010 introduces slicers, so we can find a new entry in the button „Format as Table“.
A new option for deleting the hyperlinks was also added to the button „Clear“. On the bottom right corner of the ribbon you can see a new icon which allows you to minimze or restore the ribbon. However, double-clicking on a tab is still working. Let’s have a look on the „Insert“ tab now:
As you probably already know, Excel 2010 introduces Sparklines and Slicers and allows now to insert equations in worksheets. An interesting option is the button „Screenshot“, which allows you to insert screenshots from your active applications in Excel. This option is also present in Word 2010 or PowerPoint 2010. I find it very useful, for example when writing blog articles in Word. If you click on the button, you’ll get a preview of the available screenshots. Please note, that the applications should be visible on your desktop and not minimized to the taskbar.
If you click on an entry of the preview list, a screen of the application is directly inserted in the active sheet in Excel 2010. If you choose „Screen Clipping“, you can first select an area of your screen before inserting it. I tried it out when writing this article in German in Word 2010.
If we compare the „Page Layout“ tab of both applications, we can see the new button „Sheet Right-to-Left“ for siwtching the sheet direction. The buttons „Bring Forward“ and „Send Backward“ are always enabled in Excel 2010.
The tab „Formulas“ remains unchanged compared to Excel 2007 except that the new functions of Excel 2001 can be selected from their categories.
We haven’t noticed any changes in the other tabs „Data“, „Review“ and „View“. On the „Developer“ tab, some features concerning XML functions have been removed. I don’t know, if they will be added later.
There are two remaining questions at this point, where are the tabs „Maninweb“ and „Gemini“ coming from? Well, the first one is a tab I created and customized in the Excel Options. You can have a look on our article „The new options in Excel 2010“, explaining how to do this.
The tab „Gemini“ is not installed by the Office Installer, this is an external Add-In from Microsoft from the Gemini Project.
The Add-In is the result of collaboration between the Excel and SQL teams and provides powerful data analysis features. This includes fast manipulation on very large data sets, combines data from multiple data sources and the ability share your analysis through SharePoint 2010. We will write some articles about this project later.
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