From the author of

Office-Wide Feature: Paste Options

Although not as pretty as the live previews for formatting charts, tables, and text, Paste Options may be the most useful new feature in Office 2010. Instead of just clicking the Paste icon to paste the most recently copied or cut item, you can click the down arrow beneath the Paste icon to view the Paste Options. As you hover the cursor over each of the tiny icons in the Paste Options gallery (see Figure
4), a live preview of the potential paste is shown in your document. When you see the one you want, click its icon. As with Office's other live previews, Paste Options lets you paste in the proper format the first timewithout having to rely on Undo as you often must do when trying multiple options. Of course, you never have to use Paste Options; you can still execute a standard paste by clicking the Paste icon or by pressing Ctrl-V.

Figure 4 When the cursor is over a Paste Options icon, a Screen Tip explains the option, shows the keyboard shortcut (if any), and displays the material in the document as it will appear if pasted.

TIP

Paste Options are especially useful in Excel. After copying or cutting a range, for example, you can use Paste Options to paste formulas, values, or transpose the data.