The dialog box changes, depending upon the icon selected. Then, specify the location of the file that you want to link to. In addition, you can create a hyperlink that consists of an e-mail address.
You can create hyperlinks to a file on your hard drive, a Web page on the Internet, a new document, or a location in your current workbook. Select an icon in the Link To column that represents the type of hyperlink you want to create. Use the Insert Hyperlink dialog box to add hyperlinks to your Excel worksheets. Excel responds with the Insert Hyperlink dialog box, as shown in Figure 28.4. 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.
0 kommentar(er)
