Excel 2003: Hyperlinks
 

I have a file that is a balance sheet and another file that contains
individual worksheets for each item on the balance sheet, e.g.

Balance Sheet Items:
- Assets
- Depreciation
- Liabilities

That means there are worksheets in another file for each of those three
items. How can I put a hyperlink to these items in the actual balance sheet
so that when you click on them you are taken right to the specific worksheet
in the other file?

Excel 2003: Hyperlinks
 

Insert--Hyperlink.

Follow the instructions in the dialogue box. You could also use the
HYPERLINK function but I find that rather confusing.
--
Brevity is the soul of wit.


"oceanmist" wrote:

I have a file that is a balance sheet and another file that contains
individual worksheets for each item on the balance sheet, e.g.

Balance Sheet Items:
- Assets
- Depreciation
- Liabilities

That means there are worksheets in another file for each of those three
items. How can I put a hyperlink to these items in the actual balance sheet
so that when you click on them you are taken right to the specific worksheet
in the other file?