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

word

ResolvedVersion 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:

Printing specific sections of your document

If your Word document contains sections and you want to print one specific section, you can do so by going to File - Page Setup, then entering the number of the section preceded with an 's' in the Pages box (e.g. entering s2 in the Pages box would print just section 2). Then click OK to print.

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.