linking

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking

Linking

resolvedResolved · Low Priority · Version 2003

Sam has attended:
Excel Intermediate course

Linking

how do i link up work from microsoft word to excel

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


 

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When 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.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips


Server loaded in 0.08 secs.