To create a text hyperlink in a cell, select the cell and choose Insert Links Hyperlink (or press Ctrl+K). You can create hyperlinks from cell text or graphic objects, such as shapes and pictures. Or, you can insert a hyperlink that displays a Web page in the default Web browser. For example, you can create a series of hyperlinks to serve as a table of contents for a workbook. You can set up hyperlinks to display files on your own computer, your network, and the Web. Part IV: Using Advanced Excel Features Working with HyperlinksĪ hyperlink is clickable text that provides a quick way to jump to other workbooks and files.
Reviewing the Available ActiveX Controls. Understanding the Different Web Formats. Working with External Reference Formulas. Using Formulas for Data Validation Rules. Types of Validation Criteria You Can Apply. Displaying a Sparkline for a Dynamic Range. User Interface Choices for Modifying Chart Elements. Understanding the Dimensions of an Array. Conditional Sums Using Multiple Criteria. Conditional Sums Using a Single Criterion. Creating Custom Views of Your Worksheet. Preventing Certain Cells from Being Printed. Copying Page Setup Settings across Sheets. Adding a Header or Footer to Your Reports. Using Named Styles for Easier Formatting. Adding a Background Image to a Worksheet. Entering Dates and Times into Your Worksheets. Entering Text and Values into Your Worksheets. Your selected text is now a link to the other document. Click OK again to close the Insert Hyperlink window. The bookmark is added to the file address. Select the named bookmark from the list, then click OK. Using the Look in field and its drop-down arrow ( 3), navigate to the folder where document B is located. Check the Text to display to make sure it has the word you want as the link text ( 2). On the Insert Hyperlink window, make sure Existing File or Web Page is selected on the left ( 1 in the screen shot). Word 2007: Insert tab > Links group > Hyperlink button. Open document A and select the text where you want to insert the link to document B. Word 2007: Insert tab > Links group > Bookmark button. Insert a bookmark at that place in document B, giving it a meaningful name (make sure there are no spaces or punctuation in the name):. Open document B (the document you want to link to) and go to the place where you want the link in document A to point to. Create a bookmark at the specific location in document B The steps and screens for Word 20 are almost exactly the same the screen shots in these steps are from Word 2003. 
NOTE: I would expect that if you moved the documents from their saved and linked locations, the links will break. You can link from one Word document (doc A) to a particular place in another Word document (doc B) using Bookmarks.
0 kommentar(er)
