Copy/Paste formatting in Word, PowerPoint or Excel
When you copy information from a Web page or another document, the formatting will also be copied.
To match the formatting of the target document, copy the text and place the cursor where you want to insert the copy.
Then, go to Edit>Paste Special, and select the Unformatted Text option.
(Click the arrow under Paste in the Clipboard group on the Home tab in 2007+)
The clipboard text will be pasted to match the target.
Another way when using Word 2002 + is to click on the "Smart icon" that appears at
the lower right corner of the pasted text. You can then choose to keep the original formatting, match the destination formatting, keep text only, or apply a new style.
An additional way to transfer just the formatting between documents is to highlight the text with the formatting you wish to copy and then hold down the Ctrl key and the Shift key and press the C key (Ctrl+Shift+C). Release the keys. Select the text you want to have formatted. Hold down the Ctrl key and the Shift key and press the V key (Ctrl+Shift+V). Only the formatting is copied, not the text.
In Excel use Edit>Paste Special and select the "Formats" option.
What's So Special About "Paste Special"? Video
Paste Special can also be used with graphics.
You can change Word's default behavior; choose whether to paste Inline or Floating.
Microsoft Word MVPS FAQ
See all Topics