This also opens the “insert hyperlink” dialog box. Note: Another approach is to right-click the selected cell and choose “hyperlink” from the context menu. For Excel for Mac, press the keys “Command+K.” The “insert hyperlink” dialog box opens, as shown in the following image.Īlternatively, once the cell is selected, press the keys “Ctrl+K” together. Next, click “hyperlink” from the “links” group of the Insert tab. Step 1: Select the cell where a hyperlink needs to be inserted. The steps to insert a hyperlink by using the “insert hyperlink” dialog box are listed as follows: A screen tip is a customized message displayed when the cursor rests on the hyperlink. This dialog box also allows creating a screen tip by clicking the “ScreenTip” option on the top-right side. This box helps create hyperlinks based on the kind of destination specified by the user. “Insert Hyperlink” is a dialog box that can be accessed from the Insert tab of Excel. Switch to the tab “AutoFormat as you type.” Deselect the checkbox of “internet and network paths with hyperlinks.” This will prevent Excel from creating automatic hyperlinks. Note 2: To stop Excel from creating automatic hyperlinks, select the option “stop automatically creating hyperlinks” from the AutoCorrect Options button.Īlternatively, from the AutoCorrect Options button, click “control AutoCorrect options.” The AutoCorrect dialog box will open. Once the cursor assumes this sign, release the mouse button. Click the cell containing the hyperlink and hold the mouse button until the cursor changes to a “cross” or “plus” sign.Select an adjacent cell and use the arrow keys to select the cell containing the hyperlink.Note 1: To select the cell containing the hyperlink (without being taken to the destination), use either of the following methods: When a hyperlink is undone, the URL typed in Excel is considered simply as a text string. In the succeeding image, the AutoCorrect Options button is shown in a red box and the “undo hyperlink” option is highlighted in green. This button appears right below the cell containing the hyperlink.
It also automatically capitalizes the first word after a full stop.
#2–Insert Multiple Hyperlinks with Pictures as the Destination.
#1–Insert Multiple Hyperlinks with Web Pages as the Destination.Method #2–“Insert Hyperlink” Dialog Box.