Copy and paste as link

When we copy data from our Excel file to a Word document as a link, it will be updated when we change our Excel file.
If we want to copy data from our Excel file as a link, first select the range in Excel.
Then click the “Copy” button, or click Ctrl + C on our keyboards.
We open our Word document and choose “Paste Special”.
In the dialog box, check the box for the text “Paste Link” from the list and choose “Formatted Text (RTF)”.

Click OK
The information entered into our Word document is linked with our Excel file.
If we make any changes in this Excel file, the changes will be reflected in our Word document.

Importing a text file in Excel

Excel allows us to import data from Word.
As an example, I have a Word document with several members, but I later realize that this list can be made better in Excel.
Instead of retyping we can copy the content to Excel.

To do this we need to save a Word document as text file.
So click the Office button in your Word document, and click “Save as …” the drop-down menu.
Save the file as “.txt” file.

Click “Save”
This opens the “File Conversion” dialog.
Click OK and close the file.

In Excel, choose the “Data” tab in the “Ribbon”.
And click the button “Get External Data”.
Select “From Text” in the menu.
Select the newly created “.txt” file, and click “Import”.
This opens the “Text Import Wizard”.

Select the “Delimited” box and click the “Next” button.
In step two of the wizard you select the “Delimiters” for the seperation between the excel columns.
In this case we select a Tab and Space from the list.

Click “Next”.
In the last step of the wizard we can select the data type for each column.
As this does not apply to us, click the “Finish” button.

In the “Import Data”, I give the location that I want to insert the data.
And click OK.
The data from our Word document will now be inserted and neatly divided into different columns in Excel.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats