Excel 2003: Hyperlinks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Insert--Hyperlink.

Follow the instructions in the dialogue box. You could also use the
HYPERLINK function but I find that rather confusing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 1
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Linking Formulae Across a Workbook 2
Trial Balance 2
Moving cell reference 3
how do I get a macro to change a cell in multiple worksheets? 1
View header 2
Sum cells in multiple worksheets which change every month 2

Back
Top