excel training - linking

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 - Linking

excel training - Linking

resolvedResolved · Low Priority · Version Standard

James has attended:
Excel Advanced course

Linking

Are you able to link cells across a workbook ?

RE: Linking

Hi James,

Thank you for your question.

You can set up a hyperlink to another cell / worksheet / workbook.

1) Select a cell to establish the link
2) INSERT menu > Hyperlink or CTRL+K
3) Select Link to :
[Exisiting File or Web Page] for a different workbook or
[Place in This Document.] for a cell / worksheet in current workbook.
4) Once you have locate the selection, press OK

N.B. You may also add SCREEN TIP to add on instructions to the cell.

Hope this helps.

Regards,

Katie

 

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:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips


Server loaded in 0.09 secs.