"Discover the Excel 2007 Paste Special Secrets!"


Yes, discover the secret of Excel 2007 Paste Special feature!

Maybe you are familiar with the basic copy and paste feature, whereby Excel copies all the information in the range of cells you selected: formatting, formulas, text, and other values you enter.

How about the paste special? Paste Special allows you to specify that only the entries be copied (without the formatting) or that just the formatting be copied (without the entries).

This page going to explains to you the Excel 2007 paste special options.


To use the Paste Special dialog box

  • Select the range of data you wish to copy.
  • On the Home tab, in the Clipboard group, click Copy icon.

  • OR press Ctrl+C.
  • Click the cell where you want to paste the range.
  • On the Home tab, in the Clipboard group, click the down arrow of the Paste icon and click the Paste Special option.
  • From the Paste Special dialog box displayed, select the necessary option from the Paste section:
  • Excel 2007 paste special

    Each option is explain as follow:

    Excel 2007 paste special option

  • In the Operation section, select the available suitable option.
  • For example, if you select the Add option, Excel adds the corresponding values in the source range and the destination range and replaces the destination range with the new values.
  • The Skip Blanks option prevents Excel from overwriting cell contents in your paste area with blank cells from the copied range. It is useful if you're copying a range to another area but don't want the blank cells in the copied range to overwrite existing data.
  • The Transpose option can change the orientation of the pasted entries. For example, if the original cells' entries run down the rows of a single column of the worksheet, the transposed pasted entries will run across the columns of a single row (see steps below).


To use the Transpose option

  • Select the range of data you wish to copy and transpose.
  • On the Home tab, in the Clipboard group, click Copy icon.

  • OR press Ctrl+C.
  • Click the cell where you want to place the range.
  • On the Home tab, in the Clipboard group, click the down arrow of the Paste icon and click Transpose.


Related Topics:

The Quick Method to Move One Place to Another in Excel 2007
Using the Excel 2007 Pick List Feature to Boost up Your Entering Data Speed!
How to Change the Excel 2007 Cell Color?
Excel 2007 Help - Your Personal Virtual Assistant!



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 paste special info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.