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

linking

ResolvedVersion 2007

Diana has attended:
Excel Introduction course

Linking

Can you link data between two workbooks?

RE: Linking

Hi Diana,

Thank you for your question and welcome to the forum.

Navigate to the workbook where you would like the data linked to, click into a cell and type=

Then switch to the other workbook and double click on the cell that needs to be linked and then press enter.

I hope this answers your question.

Regards

Simon

Wed 14 Oct 2009: Automatically marked as resolved.

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

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.1 secs.