HOW TO: Create a Link to a Worksheet within an Excel WorkBook in FrontPage 2000

Article translations Article translations
Article ID: 229808 - View products that this article applies to.
This article was previously published under Q229808
Expand all | Collapse all

On This Page

SUMMARY

This article describes how to link a web page to a particular worksheet in an Excel workbook.

Create a Link to a Specific Worksheet

When you create a link to an Excel workbook, it will open to the last worksheet that was viewed. To create a link to a specific worksheet follow these steps:
  1. Open the workbook to the worksheet you want to link to. Select cell A1.
  2. On the Insert menu, point to Name, and click Define.
  3. Type a name that contains only letters and numbers. Click OK.
  4. Save the workbook into the FrontPage web by clicking Save on the File menu.
  5. Open a FrontPage web in Page view, and select the text or image you want to hyperlink from.
  6. Click Hyperlink from the Insert menu. Choose the Excel workbook created earlier from the list of files.
  7. In the URL line, put your cursor after (workbook).xls and type #(name) where (name) represents the name you defined in step two. For example, if the workbook you created was entitled 'Workbook' and the Name you defined in step two was 'worksheet', the URL line would read:
    Workbook.xls#worksheet

  8. Click OK. Click Save from the File menu.Note: Additional links can be created in a single worksheet. Repeat the previous steps replacing cell A1 in step 2 with the cell you would like to link to.



Properties

Article ID: 229808 - Last Review: October 27, 2002 - Revision: 1.0
APPLIES TO
  • Microsoft FrontPage 2000 Standard Edition
Keywords: 
kbhowto kbhowtomaster KB229808

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com