Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Linking

Resolved · Low Priority · Version 2003

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

Excel articles

· Utilise the web's information banks with Microsoft Excel
· Tips for Transitioning to Excel 2007
· How We Got To The Perfect Spreadsheet: A Brief History
· How To Link Between Spreadsheets In Excel
· Finding Your Way Around Excel 2007

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips