Ctrl+K in Excel: How to Insert and Edit Hyperlinks

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, Ctrl+K opens the Insert Hyperlink dialog for the selected cell, where you can link to a webpage, file, email address, or place in the workbook. If the cell already contains a hyperlink, Ctrl+K opens the dialog to edit that link.

What Ctrl+K does in Excel

Ctrl+K is Excel’s keyboard shortcut for inserting or editing a hyperlink. It does not enter a formula or search the workbook. Instead, it opens a dialog for defining where the selected cell should take someone when they activate the link. The cell can display a web address, a filename, or more useful wording such as View the report.

The shortcut is most useful when you are building a workbook with references to supporting documents, source websites, other sheets, or email contacts. A hyperlink can be attached to text in a cell, and it can also be placed in a blank cell by specifying what text should appear there. The text displayed in the cell and the destination address are separate things: changing one does not necessarily change the other.

Ctrl+K applies to the current selection. If you are in the middle of typing or editing a cell, press Enter or Esc first so Excel returns to its normal worksheet state. Then select the cell you want to link and use the shortcut.

How to insert a hyperlink with Ctrl+K

To add a link in Excel for Microsoft 365 on Windows, follow these steps:

  1. Select the cell that should contain the hyperlink. For a new link, this can be an empty cell or a cell with existing display text.
  2. Press Ctrl+K. The Insert Hyperlink dialog opens.
  3. Choose the type of destination, such as an existing file or webpage, a location in the current workbook, or an email address.
  4. Enter or select the destination. If needed, edit the text that Excel will show in the cell.
  5. Choose OK to create the link.

For a webpage, enter its full address, including the protocol when appropriate, such as https://example.com. For an existing cell value, Excel may use that value as the display text; you can change the display text in the dialog without changing the destination. After insertion, the cell usually uses hyperlink formatting, often blue underlined text, although the workbook’s styles or formatting may make it look different.

You can also create a link from the ribbon: select the cell and choose Insert > Link. The ribbon route is helpful if you forget the shortcut or are using a device where the keyboard combination differs. Right-clicking a cell and choosing Link is another common route, although the context-menu wording can vary slightly between Excel versions.

Choose the right hyperlink destination

A link can point to more than a website. The destination options let a workbook act as a practical index for related information. Choose the destination type that matches how readers will use the file:

  • Existing File or Web Page: Link to a webpage or a file, such as a PDF, Word document, or another workbook. A file link may depend on the file staying at the same location.
  • Place in This Document: Jump to a worksheet or a cell within the current workbook. This is useful for navigation menus, contents pages, or links from a summary sheet to detailed calculations.
  • Email Address: Create a link that opens the reader’s configured email application with an address prepared. It does not send the message by itself.
  • Create New Document: In versions that show this option, make a link associated with a new document. The exact dialog presentation can depend on the Excel build.

For example, a project tracker might use a cell labeled Open requirements to point to a requirements document, while another cell labeled Go to budget links to a particular worksheet in the same workbook. Clear display text makes the purpose of a link easier to understand than a long URL or a bare file path.

Link to another worksheet or cell

To make an internal workbook link, select the cell that will contain the link, press Ctrl+K, and choose Place in This Document in the dialog. Select the target sheet and, if the dialog provides a cell reference field, enter a destination such as A1. Confirm the selection and click OK. Activating the resulting link moves the view to that location in the workbook.

This kind of link is useful in large workbooks with many tabs. A front-page contents list can point to sections such as Assumptions, Monthly Results, and Detail. It can also help a reader move from a dashboard to the data behind a particular figure. Use descriptive labels and verify the target after creating the link; a link to the wrong sheet can be confusing even if it technically works.

An internal link is different from a formula that refers to another cell. A formula such as a calculation on a summary sheet updates a value; a hyperlink changes the selected location when activated. A workbook can use both: formulas for results and links for navigation.

Edit, remove, or follow a link

To change a hyperlink, select its cell and press Ctrl+K. Excel opens the editing version of the hyperlink dialog, where you can change the destination or the displayed text. You can also right-click the linked cell and choose Edit Hyperlink. If you only need to change the visible wording, you can edit the cell text directly, but take care not to replace the entire hyperlink accidentally.

To remove the link while keeping the cell’s text, right-click the cell and choose Remove Hyperlink. This removes the navigation behavior but leaves the displayed value in place. If you delete the contents of the cell, both the text and the link are removed. Ctrl+Z can undo a recent hyperlink insertion or removal, provided you have not performed later actions that change the undo history.

To follow a hyperlink, click it. Depending on Excel settings and the link type, you may need to hold Ctrl while clicking a cell link in the Windows desktop app. Links to websites may open in the default browser, and file links may open the associated application. Excel can show a security warning for some external destinations; review the address before choosing to continue, particularly in a workbook received from someone you do not know.

Common Ctrl+K problems and fixes

If Ctrl+K does not open the hyperlink dialog, first check whether Excel is currently editing a cell. Press Enter or Esc and try again. Also confirm that Excel, rather than another application or a dialog, has focus. On a laptop, the Ctrl key itself is the same, though other keyboard settings or remote-desktop software can affect shortcut input.

If the dialog opens but the link will not work, check that the destination is complete and correctly spelled. For a website, a missing character in the address can send the link to the wrong place or cause an error. For a file on a shared drive, confirm that the intended readers have access and that the file will remain at the referenced location. A link to a file stored on one person’s local computer may not work for coworkers whose computers use different paths.

Sometimes a URL typed into a cell becomes a hyperlink automatically after you press Enter. That behavior is separate from Ctrl+K. If you do not want Excel to automatically turn internet or network paths into links, in Windows desktop Excel go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and clear Internet and network paths with hyperlinks. Menu labels may vary in other platforms or releases. You can still add a link manually with Ctrl+K when automatic formatting is disabled.

A link may also appear to have vanished if the cell’s formatting has changed. The link can remain active even when its text is not blue or underlined. Select the cell and use Ctrl+K or the right-click menu to inspect or edit its destination rather than relying only on its appearance.

Windows, Mac, and Excel for the web

On Windows desktop Excel, use Ctrl+K. In Excel for Mac, the usual equivalent is Command+K. The dialog and ribbon layout may differ from Windows, but the basic task is the same: select a cell, open the link dialog, choose a destination, and confirm it. A Windows Ctrl-key instruction should not be assumed to work identically on a Mac.

In Excel for the web, Ctrl+K is also a shortcut for inserting a link when the worksheet has focus. The web version runs in a browser, so browser focus and keyboard behavior can sometimes affect shortcuts. If the shortcut is intercepted or does not open the link control, use the Insert tab and its Link command instead. Some dialog details and available options can differ from the desktop application, especially for file destinations and workbook navigation.

Keyboard layouts and language settings can alter how shortcuts feel, but the key distinction is the platform modifier: Ctrl on Windows and Command on Mac. On a shared workbook, adding or editing a link changes workbook content, so save the file and make sure collaborators can access any external destination you include.

Ctrl+K versus the HYPERLINK function

Ctrl+K creates a hyperlink through Excel’s dialog. The HYPERLINK function creates a link from a worksheet formula, which can be handy when the destination or display text comes from cells or when you want links generated consistently down a list. The function does not replace Ctrl+K for every task: the dialog is often simpler for a one-off link or for choosing a location in the workbook.

Assume you enter the following formula in cell C2, with no other required cell layout. It displays the word Microsoft and links to the specified website:

=HYPERLINK("https://www.microsoft.com","Microsoft")

The expected result in C2 is the clickable text Microsoft. The first argument is the destination and the second is the friendly text shown in the cell. If you omit the friendly text, Excel displays the link location instead. For links built from cell values, check that the referenced cells contain valid addresses and readable labels; otherwise the formula may produce a link that is difficult to interpret or does not point where intended.

Frequently Asked Questions

What does Ctrl+K do in Excel?
It opens the Insert Hyperlink dialog for the selected cell in Windows desktop Excel. If that cell already has a link, you can use the dialog to edit it.

How do I add a link to another sheet in Excel?
Select the cell for the link, press Ctrl+K, choose Place in This Document, select the target worksheet and cell reference, then confirm. The exact dialog layout can vary by platform.

What is the Mac equivalent of Ctrl+K in Excel?
Use Command+K in Excel for Mac. If it does not work in a particular context, select Insert > Link from the ribbon.

How can I remove a hyperlink but keep its text?
Right-click the linked cell and choose Remove Hyperlink. The link is removed while the displayed cell text remains.

Why does Ctrl+K not work in Excel?
Excel may not have keyboard focus, or you may still be editing a cell. Press Enter or Esc, click the worksheet, and try again; alternatively, use Insert > Link.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.