Use the Excel Paste Special Feature


After copying data, you can use the Excel Paste Special command to paste specific cell contents such as formulas, formats, or comments from the clipboard into an Excel worksheet.

You can also use Paste Special to paste a link to Excel data or data from another program, such as Microsoft Word.



To use Paste Special to link to Excel data

  • Select the range of data that contain the items or attributes you wish to copy.
  • From the Edit menu, click Copy.OR press Ctrl+C
  • Highlight the cell where you want to place the range.
  • From the Edit menu, click Paste Special.



  • From the Paste Special dialog box displayed, under the Paste section, choose All or All except borders option. Other options included:



  • Under Operation section, specify which mathematical operation, if any, you want to apply to the copied data.



    Note: Mathematical operations can be applied only to values. To use an option other than None, you must choose All, Values, All except border, or Values and number formats under Paste section.

  • To avoid replacing values in your paste area when blank cells occur in the copy area, select Skip blanks check box.
  • To change columns of copied data to rows, or vice versa, select Transpose check box.
  • Click OK button when finish.

    To use Paste Special to link data from another program (MS Word)

  • In Microsoft Word, highlight the range of text that you wish to copy.
  • From the Edit menu, click Copy.OR press Ctrl+C
  • Highlight the cell where you want to place the range in Excel.
  • From the Edit menu, click Paste Special to display the dialog box.



  • In the As box, click the Microsoft Office Word Document Object.
  • Choose the Paste link: option to link the pasted data to its source document. To paste and embed the information without creating a link, choose Paste: option.
  • Click OK button.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

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

    Google
     

    Back to Top


    >> Next Topic : What you can do with Excel AND( ) Function?

    << Previous Topic : Creating Excel Pie Chart - The Step-by-step guide.


    You're viewing the Excel Paste Special info page, click here to go back to the Home Page