excel course tate modern - linking workbooks

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Linking workbooks

excel course tate modern - Linking workbooks

resolvedResolved · Low Priority · Version Standard

Mary has attended:
Excel Intermediate course
Excel Intermediate course
Word Intermediate course

Linking workbooks

How do you link workbooks?

RE: Linking workbooks

Dear Mary

Thank you for attending our Intermediate Excel training.
Linking workbooks is very simple. All you have to do is to ensure that both the files which will be linked (source File) and the file you want it to be linked to (Destination File) are open.
You simply click on the cell where you want to establish the link.
Press Equal(=) on eth keyboard
And then on the task bar which appears at the bottom of your screen click on the Workbook (file) , then the work Sheet and then the cell that you want to link. If you observe the Formula bar you


 

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips


Server loaded in 0.08 secs.