HOW CAN WE TRANSFER INFORMATION FOR EXEL TO WORLD

Dear Kingsley

Thank you for attending Excel Advanced course.

There are various methods that you can apply to transfer data from Excel to Word.

The quickest and simplest method is to copy the cells and then start Word and Paste it in a new or an existing document.

If you however want to create a link so that when you change the data in Excel and want the data to automatically update then:

Step 1: Copy the data in Excel
Step 2: In Word choose Edit > Paste Special…
Step 3: Click the Paste Link option

NB: In the As section if you choose as Excel Worksheet object then the data will be pasted as a picture and whenever make changes in the Excel you’ll have to right-click and choose Update Link. Or you can double-click on the object which will open the original Excel File and when you start making changes the Word will automatically update.

If you choose Formatted Text (RTF) then it will be pasted as a table with the link the data will automatically get updated when you change the data in Excel. If for any reason the data doesn’t get updated then you can simply right-click and choose Update Link.

If you want to simply import them in a Tab Delimited (Text only) format which means that the appearances such as Bold, Italic, Font Colour, Borders are all lost then:

Step 1: Open the Excel file
Step 2: File > Save As… (Shortcut key is F12)
Step 3: In the Save As type choose text (Tab Delimited) (*.txt)
Step 4: When you press save Button a message box will appear informing you that all the formatting will be lost. Click Yes.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please as the question as a separate posting.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003