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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

rss Subscribe to our RSS Feed

This entry was posted on Monday, August 25th, 2008 at 9:13 AM and is filed under Excel Training, Tips and Time Savers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«
»

4 Responses to “Paste Special Saves You Time – Explore Your Options”

  1. The Company Rocks Excels » Blog Archive » Use =INDIRECT() Function to Connect 2 Pick-From Lists in Excel Says:
    October 18th, 2009 at 6:18 AM

    [...] Paste Special Options to Save You Time [...]

  2. The Company Rocks Excels » Blog Archive » I Have 21 Excel Videos Rated 5-Stars on YouTube Says:
    December 30th, 2009 at 11:22 AM

    [...] Paste Special options in Excel [...]

  3. The Company Rocks Excels » Blog Archive » Generate Random Numbers for Excel Spreadsheets Says:
    December 30th, 2009 at 1:43 PM

    [...] Paste Special Saves You Time – Explore Your Options Share and Enjoy: [...]

  4. I Have 21 Excel Videos Rated 5-Stars on YouTube | Danny Rocks Tips and Timesavers Says:
    December 16th, 2010 at 10:32 AM

    [...] Paste Special options in Excel [...]

Leave a Reply

Powered by WishList Member - Membership Site Software