1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Insert a Hyperlink in Excel Using Shortcut Keys

By

Insert a Hyperlink in Excel
Insert a Hyperlink in Excel using Shortcut Keys

Insert a Hyperlink in Excel using Shortcut Keys

Click image to enlarge

Insert a Hyperlink in Excel Using Shortcut Keys

Related tutorial: Insert Hyperlinks and Bookmarks in Excel

This Excel tip covers how to quickly insert a hyperlink for selected text using shortcut keys in Excel.

The key combination that can be used to insert a hyperlink is:

Ctrl + k

Example: Insert a Hyperlink using Shortcut Keys

For help with these instructions click on the image above

  1. In an Excel worksheet click on cell A1 to make it the active cell

  2. Type a word to act as anchor text such as Spreadsheets and press the Enter key on the keyboard

  3. Click on cell A1 to again make it the active cell

  4. Press and hold down the Ctrl key on the keyboard

  5. Press and release the letter ( k ) key on the keyboard to open the Insert Hyperlink dialog box

  6. In the Address: line at the bottom of the dialog box type a full URL such as:
    http://spreadsheets.about.com

  7. Click Ok to complete the hyperlink and close the dialog box

  8. The anchor text in cell A1 should now be blue in color and underlined indicating it contains a hyperlink

Testing the Hyperlink

  1. Place the mouse pointer over the hyperlink in cell A1

  2. The arrow pointer should change to the hand symbol

  3. Click on the hyperlink anchor text

  4. Your web browser should open to the page identified by the URL

Remove the Hyperlink

  1. Place the mouse pointer over the hyperlink in cell A1

  2. The arrow pointer should change to the hand symbol

  3. Right click on the hyperlink anchor text to open the Context drop down menu

  4. Click on Remove Hyperlink option in the menu

  5. The blue color and the underline should be removed from the anchor text indicating that the hyperlink has been removed

Other Keyboard Shortcuts

  • Apply Currency Formatting
  • Applying Italics Formatting
  • Add Borders in Excel
  • ©2014 About.com. All rights reserved.