If you have only used Paste in MS Excel to paste content that you have cut or copied from another location, you are not making use of a very powerful tool in this latest version of MS Excel. For a long time now in past versions, Paste Special has given you the ability to paste only individual components of your selection, such a values or formatting or even some combinations of components such as pasting values and numbers formats but no other formatting.
Follow the steps below to access Paste Special:
- Click on CTRL + ALT + V (my favorite), which also works in MS Word and PowerPoint.
- On the Home tab, click to expand Paste Options and then click Paste Special.
You can avoid lots of formatting snafus by availing yourself of these options. The Paste Special shortcuts that were available in previous versions of Excel from a pop-up menu on the Standard toolbar are now right in front of you when you click Paste on the Home tab. These options include some of my favorite time savers, such as Paste Values and No Borders. No Borders will paste everything except any borders on the source content which will leave the destination borders intact.
The Paste option and the Paste Special dialog box also offer the Transpose option, which will paste copied columns of data as rows and vice versa.
It also offers Operations. With Operations, you copy a value, select the range to which you would like to apply the value and then select the option to Add, Subtract, Multiply, or Divide by the copied value for each cell in the destination page.
Makes you want to run out and get your license for MS Office 2007 doesn’t it?