Question

Locked

hyperlink in excel 2003

By saif.rehman ·
Can i use hyper link to show specific rows only in a sheet e.g i use to links on of which will shows rows ranging from 30 to 50 and the other one show rows from 60 to 90

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Inserting Hyperlinks into Excel.

One of the features built into Excel is support for the Internet. One aspect of this is the ability to add hyperlinks to your Excel workbooks. When you insert a hyperlink, there are two types you can use. You can insert either an absolute or a relative hyperlink. To insert a hyperlink:

1. Select the cell in which you want the hyperlink inserted.
2. Click on the Insert Hyperlink tool on the toolbar, or choose Hyperlink from the Insert menu. Excel displays the Insert Hyperlink dialog box. (Click here to see a related figure.)
3. If you are using Excel 2000 or a later version, the content of the cell you selected in step 1 shows up in the Text to Display box. You can change it if you want.
4. In the Link to File or URL box (Excel 97) or the Type the File or Web Page Name box (Excel 2000) or the Address box (Excel 2002 or Excel 2003), specify the address for the page that will be loaded when the user clicks on your hyperlink. Typically this is a URL, but it can also be a file or resource on your system. You can also select an address from the drop-down list or use the Browse button to help locate the resource.
5. If you are using Excel 97 and you want Excel to use a relative hyperlink, make sure the Use Relative Path for Hyperlink check box is selected.
6. When completed, click on OK.

If you indicated in step 5 that you want to use a relative hyperlink, Excel assumes that the information in the Link to File or URL box (Excel 97) or the Type the File or Web Page Name box (Excel 2000) or the Address box (Excel 2002 or Excel 2003) should be added to what is called a base URL to create a full URL. The base URL is specified in the following way:

1. Choose Properties from the File menu. Excel displays the Properties dialog box.
2. Make sure the Summary tab is selected. (Click here to see a related figure.)
3. In the Hyperlink Base box, indicate the first part of any URL specified using relative references.
4. Click on OK when finished.

Please post back if you have any more problems or questions.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums