|Microsoft Office Access 2003
Microsoft Office Excel 2003
Microsoft Office Outlook® 2003
Microsoft Office PowerPoint® 2003
Microsoft Office Word 2003
You can quickly create a link to a location within another Word document, Excel worksheet, PowerPoint slide, or Access database by using the Paste as Hyperlink command. This command allows you to insert a link in a source program, such as a Word document, that links to a specific location in a target document, such as a cell in an Excel worksheet. Alternatively, you can insert a link to a Word document in an e-mail message in Outlook. When you click the link in the source document, the target document opens in the corresponding program to the specific location.
The following scenarios describe possible ways to use this command:
- Excel to Word In Excel, you have a list of rows that contain structured data and numbers, but one column requires rich text and pictures, which are difficult to insert in Excel. However, from each cell in the Excel workbook, you can link to a section in a corresponding Word document that contains the rich text and pictures.
- Word to PowerPoint You have a collection of notes from a week long conference that you want to summarize with links to key PowerPoint slides that are available online for more details. You can write your summary in a Word document and add links to the specific slides of interest to your audience.
- Access to PowerPoint and Word You have a monthly budget report that you create in Access, one page for each department, and you want your staff to easily find the relevant Word document page and PowerPoint slide that amplify the key points of the report. In each page of the Access report, you can create labels that link to the specific page in the Word document and the slide in PowerPoint.
Link to a location in a target document
- Make sure that you save the target document.
- Open the target document, select the specific location that you want to link to, and then copy it. The location must be one of the following:
Open the source document in the other Office program.
Position the insertion point where you want to add the link.
On the Edit menu, click Paste as Hyperlink.
- Word A bookmark inserted in the document
- Excel A defined name or range (including a single cell) on a worksheet
- PowerPoint A slide in a presentation
Note In Access, you must be in either form or report design view. In both cases, a label is created. For more information, in Access see Create a hyperlink.
- Linking to locations within documents is fully supported in Excel, Word, and PowerPoint, as well as in Outlook messages (when you are using Word as the e-mail editor).
- When you create a hyperlink to a Web page, you can link only to text that is encoded as an anchor on the Web page. Although anchors are not displayed in your browser, they are commonly found as headings or section titles on a Web page.
- When you use the Paste As Hyperlink command, Access can be the source document but not the target document.
- To open a linked document, the person opening the document must have read access to the document location and the document itself. For example, a coworker might not have permission to open a document that is saved on your computer. To correct the issue, you can create a link to a target document on a shared network folder.