word

Forum home » Delegate support and help forum » Microsoft Word Training and help » Word

Word

resolvedResolved · Low Priority · Version Standard

Evelyn has attended:
Word Advanced course
Excel Advanced course

Word

How can I merge an excel spreadsheet into word?

RE: Word

Hiya Evelyn

There are a couple of ways of doing this, now this will depend on what version of Word you are using if this is for 2003 then you can either insert an Excel spreadsheet by clicking the insert excel worksheet from the formatting toolbar

Or you can link the excel spreadsheet in Word which has more benefit because you can update the excel spreadsheet from either Excel or Word, and the changes will reflect in your document.

To link the excel file you will need to have the excel file saved or open, its better if you have the excel file open, then you will need to copy the data to be linked, then go to Word
and then when in the right place you can go to the Edit menu, and click paste special, when the paste special window opens you will be able to choose paste link, then click OK

then as you change anything in Excel this will reflect in Word, and if you change things through Word you will be taken to Excel with all the functions of Excel

Hope this is what you are after

Mark East

 

Training courses

 

Training information:

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.


 

Word tip:

Moving Table column lines where you want

This tip is similar to the one i added on tabs.

When you are moving table lines the pain is that they jump, but if you use the ALT key and then click on the table column/row line it will allow you to move it anywhere you want.

The best bit about this shortcut is that when you press the ALT key the ruler changes and show's you actual cell sizes.

View all Word hints and tips


Server loaded in 0.09 secs.