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

linking

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

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.