Microsoft has modified the copy and paste functionality in the different Office 2010 applications. Let’s have a look how this works in Excel 2010.
As you can see, some new icons were added. And the best: like in other functions (for example for changing the font size), when hovering with the mouse over icons you’ll see the changes in real time.
The new icons are mostly corresponding to the options found in the dialog when selecting “Paste special” from the context menue in Excel 2007. Let’s have a closer look to the new icons:
|Paste all values and formattings to the new range.|
|Paste only the value without any formattings.|
|Paste the values/functions and number formats.|
|Paste the values/functions and formattings.|
|Paste the values and formattings, however don’t paste the border lines.|
|Also paste the widths of the source columns.|
|Transpose the copied cells.|
|In the group „Paste Values“ we can see following icons:|
|Just copy the values only, not functions.|
|Copy and paste the values only and number formats.|
|Copy and paste the values and formattings.|
|In the last group “Other Paste Options”, we’ll find following icons:|
|Just paste the formattings.|
|Paste links to the source cells.|
|Paste a picture.|
|Paste a linked picture.|
The options “Paste special” dialog have not been changed, however a new option “All merging conditional formats” has been added.
This option copies the conditional formattings and adds them to the target range. If you’ve just copied and pasted some data, you can change retrospectively the paste method. In this case, live preview does not work. Perhaps Microsoft will add this later.
The new copy and paste options are also present in Word 2010. I’m very pleased about this, it’s a very easy way to remove source formattings without the need to click on different options.
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