98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking
Linking
Resolved · Low Priority · Version 2003
Thu 26 Jun 2008, 15:21Delegate Sam said...
Sam has attended:
Excel Intermediate course
Linking
how do i link up work from microsoft word to excel
Mon 30 Jun 2008, 12:48Trainer Stephen said...
RE: linking
Hi Sam
Thank You for your question
I am assuming that you have information in a table in word that you want also to appear in Excel, so that if you change the data in Word, it also changes in the Excel workbook
Select the table in word and copy it to the clipboard.
Open your excel workbook and select the start cell where you wish the data to go.
Click on Edit-Copy-Paste Special, and then select the "Paste Link" Option.
The data will now appear in your spreadsheet and any changes in the source will be reflected in the spreadsheet.
Hope this helps
Regards
Stephen
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
