Earlier I was analyzing a bunch of data and needed to go through a couple hundred columns and fill out specific data in each column. One of the tasks I needed to complete was adding a URL to a single cell and once that URL was added to the cell I needed to then create a hyperlink for each specific cell to a configuration application that had specific data about each URL. Do complete this easier I needed a keyboard shortcut to initiate the hyperlink addition configuration window in Office Excel. Below I describe what the keyboard shortcut is and what it does.
Microsoft Office Excel Worksheet Example:
The above worksheet example is what will be used as an example in this article. Notice the content in cell B7 that says “SOME CELL CONTENT YOU WANT TO MAKE A HYPERLINK” which is currently not a hyperlink. The first step is to highlight the Excel cell that you want to make a hyperlink to some URL (external or internal) as shown in the below example image.
Highlight Cell That Will Become A Hyperlink:
After highlighting the correct cell use the “Ctrl-K” keyboard shortcut to launch the Insert Hyperlink configuration window shown below.
Insert Hyperlink Configuration Window In Office Excel:
Type the URL you want the text in the cell to link to and click the OK button. The example image below shows the text in the cell now links to Google.
Text In Cell Is Now Linked To A URL:
The Control key plus the K key will make adding many hyperlinks to cells much easier!