- To open the Link menu, select the cell where you want your link. Click "Insert" → "Link".
- For "Place in This Document", enter the cell location you want to link to.
- For "Existing File or Web Page", copy and paste a URL into the "Address" field.
Link to a Location in a Workbook
Open a workbook in Microsoft Excel. If needed, you can begin a new Spreadsheet. Microsoft Excel is available to download on Windows and Mac. You can also use the online web version at https://www.office.com.
Select the cell in which you want to create your link. You can create a shortcut link in any cell in your spreadsheet.
Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
Click Link. You can find this in the Links section of the Insert toolbar. A new window will open.
Click Place in This Document. This will be in the left menu panel, under Existing File or Web Page. You'll be able to add a link to any cell in your workbook. If you want to link to a location in a different workbook, select Existing File or Web Page', select the workbook, and then click Bookmark.
Enter the cell location that you want to link to. Enter a cell location, or select from defined cells or ranges. To type a cell location, select the sheet from under the Cell Reference header. Then, type the specific cell (ex: B35) into the Type the cell reference field. If you want to add a link to a named range, select the name of the range from the Defined Names header. If you select one of these, you won't be able to type a location.
Change the displayed text (optional). By default, the link's text will be the cell that you are linking to. You can change this by typing anything you'd like into the Text to display field. You can click the "ScreenTip" button to change the text that appears when a user hovers their mouse cursor over the link. Click OK to apply your finished link.
Link to a Webpage
Copy the website you want to link to. To add a link to a webpage, you'll need to find the URL. This can be found in the address bar at the top of your web browser. Highlight the entire URL, right-click the link, then select Copy or Copy address. You can also use a keyboard shortcut. On Windows, highlight the text and press CTRL + C to copy. On Mac, highlight the text and press Command + C to copy.
Select the cell in which you want to create your link. You can create a shortcut link in any cell in your spreadsheet.
Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
Click Link. You can find this in the Links section of the Insert toolbar.
Select Existing File or Web Page. This will be the first option in the left panel. If you're using Excel 2011, select Web Page.
Paste the website link into the "Address" field. You can find this at the bottom of the window. Right-click the field, then click Paste. You can also use a keyboard shortcut. On Windows, click the field and press CTRL + V to paste. On Mac, click the field and press Command + V to paste. If you're using Excel 2011, paste the link into the "Link to" field at the top of the window.
Change the text of the link (optional). By default, the link will display the full address. You can change this to any text you'd like, such as "Company Website". Enter your new text in the Text to display field. If you're using Excel 2011, this is the "Display" field. You can also click the "ScreenTip" button to change the text that appears when a user hovers their mouse cursor over the link.
Click OK to create the link. Your link will appear in the cell you selected earlier.
Link to Another File or Folder
Select the cell in which you want to create your link. You can add a link to a document or location on your computer or server into any cell in your spreadsheet.
Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
Click Link. You can find this in the Links section of the Insert toolbar. A new window will open.
Select Existing file or webpage. This will be the first option in the left panel. This option allows you to add a link to any location or document on your computer (or server) in Excel. In Excel 2011 for OS X, click "Document" and then click "Select" to browse for a file on your computer.
Select a folder or file to link to. The quickest way to link to a specific file or folder is to use the file browser to navigate to the one you want. You can link to a folder or a specific file. Click the drop-down menu next to Look in to navigate through the folders on your computer.
Type or paste an address for the file or folder (servers). You can enter the address for the file or folder instead of navigating to it with the browser. This can be especially useful for entering locations on another server. To find the actual address for a local file or folder, open your Explorer window and navigate to the folder. Click the folder path at the top of the Explorer window to reveal the address, which you can then copy and paste. To link to a location on a server, paste the address for the folder or location that will be accessible to the reader.
Change the text that is displayed (optional). By default, the link will display the full address to the linked file or folder. You can change this by changing the text in the "Text to display" field.
Click OK to create the link. You'll see your link appear in the cell you had selected. Clicking it will open the file or folder that you specified. Users of your spreadsheet will need to have access to the linked file from the same file location as used in your link. It may be more helpful to embed the file.
Insert a Link to Send an Email
Select the cell in which you want to create your link. You can insert a mail link into any cell in your spreadsheet.
Click Insert. This is the tab on the top toolbar, between Home and Page Layout.
Click Link. You can find this in the Links section of the Insert toolbar. A new window will open.
Select E-mail Address. This will be in the left menu panel, underneath Create New Document.
Enter the email address you want to link to. Use the Email address field. You'll see the "Text to display" field fill as you add the address. mailto: will be added to the beginning of the address automatically. If you've entered email addresses before, you can select them under the Recently used e-mail addresses header.
Enter a premade subject into the "Subject" field (optional). You can leave the link as is if you'd like, but you can set a premade subject if you want to make things easier on your users.
Change the link text that will be displayed (optional). By default, the link will display mailto:[email protected], but you can change this to whatever you'd like (ex: Contact Us). Click the "Text to display" field and change the text. Click the "ScreenTip" button to change the text that appears when the user hovers the mouse cursor over the link.
Click OK to insert your link. Your new email link will be created, and clicking it will open your email client or website with a new message addressed to the address you entered.
Comments
0 comment