data transfer

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data transfer

Data transfer

resolvedResolved · Low Priority · Version 2003

Lucy has attended:
Excel Introduction course

Data transfer

How do you transfer word data to excel?

Edited on Thu 17 Jul 2008, 08:56

RE: data transfer

Hi Lucy,

Thank you for your post, welcome to the forum.
Answer to your question:

If your word data is in the form of a table, then the transfer is quite simple, select the entire table (or part of) and copy it.

In your Excel worksheet, select the start cell for your entry and click Paste, if you wish to apply other options try Paste Special and choose from the options available.

If your word data is purely text, you will have to import this as an object, by importing as an object will enable the edit option to be present (double click on the text box to edit it in Word). You can also click the Link check box which will ensure that any changes made to the original Word document will be reflected in your text box in Excel.

To insert the Word Document choose the Menu option, Insert>Object, Choose the tab Create From File and either enter the File path or Browse to navigate to the folder where it is located. Once you have your target document located, select it and click the Insert Button, click the Link tick box to capture any changes, and press OK.
The document will be inserted in a Text box which can be moved to your required location.

I hope that has answered your question, if so please click the resolved link, regards Pete

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips


Server loaded in 0.09 secs.