Work with hyperlinks in Excel. Each time that you create a hyperlink to a file in that location, you only have to specify the file name, not the path. Nov 08, 2005 I have to distribute an excel file containing an hyperlink to a external program that is supposed. Icon but, i can not know in. Opening a.exe file from an. For quick access to related information in another file or on a web page, you can insert a hyperlink in a Microsoft Excel worksheet cell. You can also insert.
Applies To: Excel 2013 For quick access to related information in another file or on a web page, you can insert a hyperlink in a Microsoft Excel worksheet cell. You can also insert hyperlinks in specific chart elements or images.
What do you want to do? Create a hyperlink to an existing file or webpage • On a worksheet, click the cell where you want to create a hyperlink. Tip You can also select an object, such as a picture or an element in a chart you want to use to represent the hyperlink. • Do one of the following: • You can also right-click the cell or graphic and then click Hyperlink, or you can press Ctrl+K. • On the Insert tab, in the Links group, click Hyperlink. • Under Link to, click Existing File or Web Page. • Do one of the following: • To enter the name and location of a known file or webpage that you want to link to, type that information in the Address box. Flight Simulator 2004 Planes.
• To locate a Web page, click Browse the Web, open the Web page that you want to link to, and then switch back to Excel without closing your browser. Or, to use recently linked pages, click Browsed Pages and then click the web. • To select a file, click Current Folder, and then click the file that you want to link to or, to use recently used files click Recent Files, and then click the file. Tip You can change the current folder by selecting a different folder in the Look in list. • If you want to create a hyperlink to a specific location in the file or on the webpage, click Bookmark, and then double-click the bookmark that you want to use. Note The file or webpage that you are linking to must have a bookmark.
• In the Text to display box, type the text that you want to use to represent the hyperlink. • To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK. Create a hyperlink to a new file • On a worksheet, click the cell where you want to create a hyperlink. Tip You can also select an object, such as a picture or an element in a chart you want to use to represent the hyperlink. • Do one of the following: • You can also right-click the cell or graphic and then click Hyperlink, or you can press Ctrl+K. • On the Insert tab, in the Links group, click Hyperlink.
• Under Link to, click Create New Document. • In the Name of new document box, type a name for the new file. Tip To specify a location other than the one shown under Full path, you can type the new location preceding the name in the Name of new document box. Or you can click Change to select the location that you want and then click OK. • Under When to edit, click Edit the new document later or Edit the new document now to specify when you want to open the new file for editing. • In the Text to display box, type the text that you want to use to represent the hyperlink. • To display helpful information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.
Create a hyperlink to a specific location in a workbook To link to a location in the current workbook or another workbook, you can either define a name for the destination cells or use a cell reference. To use a name, you must name the destination cells in the destination workbook. How to name a cell or a range of cells • Select the cell, range of cells, or nonadjacent selections that you want to name. • Click the Name box at the left end of the formula bar. • In the Name box, type the name for the cells, and then press ENTER. Tips: • You can also select an object, such as a picture or an element in a chart that you want to use to represent the hyperlink. • • Right-click the cell or graphic and then click Hyperlink, or you can press Ctrl+K.