Inside Microsoft Excel

Get a Paste Special peek (2010/2013)

Inside Microsoft Excel

by Kara Hiltz

Paste Special provides a lot of options for moving data that you’ve copied or cut onto your Clipboard.But sometimes knowing which of the several Paste Special options to use is a guessing game.

Excel has expanded its “live preview” capabilities to include Paste Special options. As shown in Figure A, selecting a range and using the Paste Special operation displays a palette of Paste Special options.As you hover over each option, your selected[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)