Thursday, May 29, 2014

Paste Special Live Preview in Excel 2010

If you right-click a range of cells and select Paste Special, Excel 2010 brings up a live preview of the possible menu choices, as shown below.
  



Clicking an option lets you see a preview of how your spreadsheet will appear if you choose that option.


The short cut key for paste special Alt + E + S. Doing so, the paste Special window will open.


As you can see, the short cut key for each option is given as underlined character. For example, Paste Special-Formats has underlined "t". Hence, if you want to paste format only, you have to go for Alt+E+S+T. Similar procedures must be followed for other paste special options.



No comments:

Post a Comment