Paste Special Saves You Time – Explore Your Options

I love the Paste Special options in Excel (and Word and PowerPoint.) They save me time. They help to ensure that I am always referring to the latest data. And they help me to be more productive. What’s not to like?

In this video lesson, Danny will demonstrate how to get the most out of each Paste Special option.

Here are the steps to follow in this video lesson:

1. When you want to copy the “results” of a formula and not the actual formula, choose “Edit, Paste Special, Values.”
2. If you want to copy the “source formatting” as well as the Values, choose “Edit, Paste Special, Values and Number Formatting.”
3. To change the orientation (from Vertical to Horizontal, e.g.) choose “Edit, Paste Special, Transpose.”
4. To ensure that your copied data remains current, choose “Edit, Paste Special, Paste Link.”
5. You can also use the Paste Special Dialog Box to choose Paste Special “Formats” and “Comments.”
6. Experiment with Paste Special Add, Multiply, Subtract & Divide.

Find the Excel Training Video that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.

Related Videos

• Transpose Your Data
  
• Use Paste Special, Add to Combine Data from 2 Columns