So you clicked on your Paste button and noticed a drop-down menu and you see an option that leaves you wondering "What is Paste Special and why would you ever use it?"
Paste Special is basically used to insert data, images, and information from one program to another. For example you may want to insert data from Excel into Word or a chart into PowerPoint. But Paste Special can do so much more then that!
It can clear all formats that a document can contain. It can let you neatly paste information from a web page into your Word document. It can link formulas in Excel. Maybe you have a long table in Word that is getting unwieldy and want to move it to an Excel spreadsheet.
Check Paste Special out next time you copy something and try seeing what Paste Special offers you in other programs.
Photo © Rebecca Johnson