linking workbook

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

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

Linking workbook

resolvedResolved · High Priority · Version 2003

starlette has attended:
Excel Intermediate course

Linking workbook

how do I link sifferent workbooks on a window

RE: linking workbook

Hi Starlette

Thank you for your question and welcome to the forum.

To link one cell to another (regardless of whether the cells are in the same file or different files):
Note: if you are linking to a cell in a different workbook, make sure both files are open before you create the link.

1. Select the cell you want to create a link in.
2. Type in =
3. Navigate to and select the cell you wish to link to and click on it.
4. Press Enter.

And voila, you have a link.
Amanda

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips


Server loaded in 0.08 secs.