excel training courses - 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 training courses - Workbooks

excel training courses - Workbooks

resolvedResolved · Low Priority · Version Standard

Veronique has attended:
Excel Intermediate course

Workbooks

Hi,

How do I link workbooks?

Thanks,
Veronique

RE: workbooks

Hi Veronique

Thank you for your question.

You can link one cell in one file to another cell in a different file by:

Opening both files

Choosing the cell that you want the linked result to appear in

Press =

Go to the other file and clicking on the cell you want to link to

Press Enter.

Amanda


 

Excel tip:

Use the Ctrl-key for quick navigation in Excel 2010

If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key.

View all Excel hints and tips


Server loaded in 0.1 secs.