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
Related posts:
26. March 2012 at 16:21
I recently installed Office 2010 on a laptop running Windows 7 Home, 64 bit. the paste options that I see highlighted in your article are missing from my Excel. It shows “paste text only,” but that is the only icon. It also shows Use Import Wizard…and Paste Special…, but that is it. It seems to default to Paste test only, as when I paste, I am not getting formats or formulas. Very frustrating…any ideas?
26. March 2012 at 17:08
Hi Larry DeVries…
as far as I know, normally the other copy options are only not visible, if you are in edit mode for the cell.
I have also seen some similar problems here (I think so) on a MS Answers Forum. Seems that some other software can cause the problem.
If this does not help, I recommend to ask the question on the MS Answers Forum or on the Excel Guru Forum or on the TheCodecage Forum.
Regards
12. May 2012 at 19:05
I absolutely hate these new icons in Windows 10! I cannot work out from the little pictures what each is supposed to do & you don’t get any information when you hover over them.
Neither can I find a way to get text instead without buying a program from Microsoft (& others) that will return the ribbon to the Classic view!!! Thats a good way to make money – change things so that users don’t like them & then sell them a download to make it look as it always did! Way to go Microsoft.
12. May 2012 at 19:19
Hi Pam…
I did also had some learning curve for getting familiar with the ribbon. However, there are some helping tools on the net, for example the interactive guides for Office 2010. For example, the guide for Microsoft Excel is located here: Microsoft Excel 2010: Interactive menu to ribbon guide.
An addtional tool is the Ubit Classic Menue, which creates a new toolbar and emulates the old menues. As far as I know, the Add-In is free for private use. Hope this helps.
Best Regards