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 dataSelect the range of data that contain the items or attributes you wish to copy.From the Edit menu, click Copy.OR press Ctrl+CHighlight 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.
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.
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 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+CHighlight 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.
Can't find what you're looking for? Try Google Search!
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