98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Word
Word
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Moving Table column lines where you wantThis tip is similar to the one i added on tabs. |