You’re special, and my co-workers and I want you to know it. And because you’re special, we want you to know about a special feature available in Microsoft applications like Word, Excel, Publisher and PowerPoint. The feature is called “Paste Special.”
The Paste Special feature comes in handy when you’re trying to move information from one document to another. Paste Special allows you to insert the contents of the Windows clipboard into your document in a variety of formats.
Here’s an example of how you can use the Paste Special feature:
- Highlight and copy a table in a Microsoft Word document or a range of cells in a Microsoft Excel spreadsheet.
- Open your Microsoft Publisher document.
- Go Edit > Paste Special…
- Highlight one of the suggested formats such as “Picture (Windows Metafile).”
- Click OK.
If you follow the steps in this example, Publisher will insert the contents of the clipboard as an image. Experiment with the various formats. See which one works best for you.
When plain copy/paste just doesn’t do the job, try Paste Special. You may very well find that the solution you are looking for is a single click away!
Thank you for the tip. I already tried it and it works great. It will be really handy when I list the Christmas and Easter Flower Memorials in the bulletin because I keep track of them in Excel first.