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[…]