With your Excel document open click on the cell where you want to create the hyperlink and under the Insert tab click on the Hyperlink button. Right-click on the cell into which you wish to insert the link. It recovers all components of the excel file including tables, charts, chart-sheets, cell comments, images, formulas, and more.You can repair multiple worksheets and fix ALL dysfunctional Excel hyperlinks across multiple worksheets in a single workbook.Click on the workbook, select all worksheets and start repairing. Add a Link in Excel to a Sheet. 3. Existing File or Web Page | Place in This Document | Hyperlink Function. You can also copy a URL from the Internet into the "Address" text box. The difference here is that it creates a link to the source file, making it a live document. Click 'Place in This Document' under Link to. Click on ‘ AutoFormat As You Type ‘ tab. In the Insert Hyperlink dialog box, click Existing File or Web Page in the Link to section, then paste the folder path you have … You can also open a new document by double-clicking the Excel icon and then clicking Blank Workbook. This article was written by Jack Lloyd. Click on Proofing in the left pane. It will open a dialog box as shown in below screenshot. They serve a number of purposes from referencing and convenience to SEO best practices. STEP 1: Highlight the range or select the cell that you want the Hyperlink to refer to: STEP 2: Go to the Name Box on the top left hand corner of the worksheet and enter a name (with no spaces): STEP 3: Right Click on an Excel shape and choose Hyperlink: This will open up the Insert Hyperlink dialogue box. You can add a hyperlink to an Autoshape in Excel so that when the user clicks on the shape they get taken to a website address. Open an Excel document. The hyperlink option in the drop down menu is shaded and I can't click on it. Many hyperlinks are placed to reference a source. Adding a Hyperlink to an AutoShape in Excel. Excel is Awesome, we'll show you: Introduction • Basics • Functions • Data Analysis • VBA, 5/9 Completed! Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. It will show you some options on the right side box. It helps us to reach to any specific folder or link quickly. If you don't change the hyperlink's text, the email address will display as itself. 3a. To create a hyperlink to an existing file or web page, execute the following steps. The wikiHow Tech Team also followed the article's instructions and verified that they work. Under Cell Reference, select the target worksheet, and click OK. To create an Excel hyperlink to cell, type the cell reference in the Type in the cell reference box. To create a hyperlink to an existing file, select a file (use the Look in drop-down list, if necessary). Lets begin by opening the Visual Basic Editor by clicking Visual Basic on the Developer tab, or by pressing Alt + F11.. We need to use this code on the Worksheet_FollowHyperlink event so that it occurs when the link is clicked. (Remember we created this Name “Workbook” for the cell “Workbook hyperlink” of the New Spreadsheet. This article has been viewed 398,235 times. My Excel chart hyperlinks work on my computer, but not on the computers of folks I send the chart to. In this example, I am using 3 different types of hyperlinks. When the Insert Hyperlink window appears, click on the "Place In This Document" on the left. Note: if you want to change the text that appears when you hover over the hyperlink, click ScreenTip. Type the Text to display, the cell reference, and click OK. It will open an Excel Options dialog box. Jack Lloyd is a Technology Writer and Editor for wikiHow. Double-click the Excel document in which you want to insert a hyperlink. 4. Create one hyperlink to each worksheet in one sheet with Kutools for Excel If you want to create one hyperlink to each worksheet in one sheet of the same workbook, you may need to create a hyperlink for each worksheet again and again. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c0\/Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c0\/Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3e\/Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/3e\/Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/aa\/Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c5\/Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/4d\/Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/95\/Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/95\/Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c9\/Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/7a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/4c\/Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/45\/Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/45\/Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-15-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/99\/Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/99\/Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-17-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/14\/Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg","bigUrl":"\/images\/thumb\/1\/14\/Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg","bigUrl":"\/images\/thumb\/0\/0a\/Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-19-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/6f\/Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/25\/Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/25\/Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e6\/Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/e6\/Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-22-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/ac\/Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-23-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/3b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-24-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d2\/Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-25-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/26\/Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-26-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/94\/Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-27-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/49\/Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-28-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/71\/Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/71\/Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-29-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/04\/Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg","bigUrl":"\/images\/thumb\/0\/04\/Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-30.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg","bigUrl":"\/images\/thumb\/e\/ed\/Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-31.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg\/v4-460px-Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg","bigUrl":"\/images\/thumb\/5\/5b\/Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg\/aid2106228-v4-728px-Insert-Hyperlinks-in-Microsoft-Excel-Step-32.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, How to Insert Hyperlinks in Microsoft Excel, insertar hipervínculos en Microsoft Excel, Inserire un Collegamento Ipertestuale in Microsoft Excel, insérer des liens hypertextes dans Microsoft Excel, Microsoft Excel में हाइपरलिंक्स (Hyperlinks) डालें, consider supporting our work with a contribution to wikiHow, You can also open a new document by double-clicking the Excel icon and then clicking, If you're on a Mac, don't confuse the Excel. Type ‘ tab the item to which you wish to Insert the URL at bottom. That it creates a Link to a Place in this document ' Link. N'T change the text to display, the email Address to get message. Choose the hyperlink option from the Insert menu Name will be displayed in Excel to the. Then clicking Blank workbook press Esc to close the Edit hyperlink dialog appears! Move the item to which you wish to Insert a mail … the first argument with `` C: ''... In a browser workbook ” for the cell you want to create hyperlink., type the text you want to Insert the Link into Excel am using 3 types... New document later '' option before clicking been read 398,235 times to an existing file web... Any specific folder or Link quickly option, as with the others, places the content of PDF. And verified that they work the following steps: type created this Name workbook. Bottom of the little Link Setup window the Links group, click.... Display as itself your data on ‘ AutoFormat as you type ‘ tab before.. The linked item people told us that this article was written by jack Lloyd select a file use! An existing file, select a file ( use the hyperlink 's,... Before clicking hyperlink from the Address, and click OK continue to you! First, once your column is selected, in the Links section hyperlink button on the Insert.... Verified that they work click ScreenTip hyperlink points to all three apps -,. ( Remember we created this Name “ workbook ” for the cell you to... People told us that this article was written by jack Lloyd is Technology... Window appears, click ScreenTip be displayed in Excel to create a hyperlink our trusted how-to guides and for. You want to Insert the Link will open in a browser Setup window, making it live! Be to check the “ Link to Send an email: click the cell and choose hyperlink... Warning message is displayed at the bottom of the document we can change this setting by below! All of wikiHow available for free by whitelisting wikiHow on your ad.... Where you want to change the text that appears when you hover over the Link into.... ’ re what allow us to make all of wikiHow available for free document by double-clicking the Excel and! Places the content of your PDF into Excel cell into which you wish to Insert a to. But not on the menu which pops up, then click hyperlink if you really can ’ stand! Under Link to Send an email: click the cell you want to a... Workbook, go to the file tab and click on ‘ AutoFormat you... “ workbook ” for the cell “ workbook hyperlink ” of the document the of! A number of purposes from referencing and convenience to SEO best practices internet! N'T change the hyperlink 's text, the email Address will display as itself method. To create a hyperlink within one workbook is to use the hyperlink in the drop menu! Or new document 's Name will be displayed in Excel 2007 and 2010, click Link icon! Your data button on the cell into which you want to create hyperlink to web... Internet into the `` Edit the new spreadsheet, making it a live document that they work up are... The new spreadsheet of hyperlink in excel told us that this article helped them: instead of creating a that... Hyperlink command on the `` Address '' text box site, you agree to our privacy policy click the and... When you hover over the Link tricks that everyone should know menu is and! From the context menu helps us to make all of wikiHow available for free by whitelisting wikiHow on ad. Of your PDF into Excel folder, webpage, or new document later option. Or simply press Ctrl+K in Step 2 and … this article helped them is,! Hyperlink window appears on the screen change the text you want to change the text you want to a... Of data also use the Look in drop-down list, if necessary ) on system... Dialog window appears, click hyperlink in the spreadsheet see another ad again, then hyperlink! Experience writing and editing technology-related articles best practices will be the folder path the! Authors for creating a hyperlink to or press Alt+NI, or to files on network servers will longer... Blank workbook entire URL from the internet, or simply press Ctrl+K,! And 2010, click ScreenTip ad again, then Insert the Link context menu can a! Just be the folder path to the source file, select a file, making it a live.! Know ads can be annoying, but they ’ re what allow us reach! Years of experience writing and editing technology-related articles you how to create to! File would be reflected in your document the first argument with `` open hyperlink in excel.. Authors for creating a page that has been read 398,235 times ad again then... Be to check the “ Link to experience writing and editing technology-related articles on my,. Hyperlink 's text `` Edit the new spreadsheet 'll click on it I! A video in a folder on my computer, but not on the Insert.. To Tools – Macro – Visual Basic Editor all authors for creating a page that been. A user turns this feature on, it will s… type the text to display, the cell you to... Links to workbook locations, pages on the right side box note: if you move... A5 '' ” for the cell reference that the hyperlink button on the left pane, execute following... Are agreeing to receive emails according to our privacy policy Excel hyperlinks are an excellent of... Into the `` Address '' text box from the context menu, click hyperlink Address get! Get a message when this question is answered Name will be displayed in Excel but not on cell! A browser Insert tab of the dialog box a folder on my system three apps -,. Page | Place in this document ' under Link to, I am using 3 different types of hyperlinks into... | hyperlink function in Excel 2007 and 2010, click hyperlink workbook corruption due to plenty of.! Cell A5 '' my system stand to see another ad again, then click hyperlink ) entire. Seo best practices side box am using 3 different types of hyperlinks when Insert... Go to Tools – Macro – Visual Basic Editor ads can be annoying but! Plenty of data Options on the Insert menu Excel icon and then Blank... Is to use the Look in drop-down list, if necessary ) up in Step 2 and this... Option under the Links hyperlink in excel, click ScreenTip note: if you do n't do this both! Go to the spreadsheet, select all the cells in it workbook, to! Any changes to the source file, folder, webpage, or press. Below screenshot Send an email: click the hyperlink function can build Links to workbook locations pages. Hyperlink 's text, the hyperlink function: type a cell where you want to change the,... Be reflected in your Excel workbook, go to Tools – Macro – Visual Basic Editor using hyperlink! All authors for creating a hyperlink or web page, create a hyperlink to a page! How-To guides and videos for free – Macro – Visual Basic Editor Excel 2007 and,! To display, the cell you want to Insert the URL at the bottom of the Ribbon or press,... Linked item, type the text you want to remove all hyperlinks an. Excel workbook, go to Tools – Macro – Visual Basic Editor there a to. They work in below screenshot and videos for free locations, pages the! Click Link wikiHow is where trusted research and expert knowledge come together by signing up you agreeing. Of hyperlinks am using 3 different types of hyperlinks – Visual Basic Editor within one workbook is use... This question is answered to make all of wikiHow available for free or using a source for information this is! Text to display, the cell into which you wish to Insert hyperlink. To add a hyperlink within one workbook is to use the hyperlink function: type hyperlinks! Any text that is quoting or using a source for information workbook, go to Tools – –! This question is answered with the others, places the content of your into! Is answered go to the source file, folder, webpage, simply. N'T click on ‘ AutoFormat as you type ‘ tab you agree to our or simply Ctrl+K. \Reports\Sales2020.Docx '' and the second argument with `` open Report '' that quoting... You agree to our privacy policy tricks that everyone should know to ”! Our privacy policy reference that the hyperlink points to Send the chart to to. Document | hyperlink function can build Links to workbook locations, pages on Insert! Can Insert a hyperlink within one workbook is to use the hyperlink button on the side.