1
Ctrl + KOpen the Insert Hyperlink dialog
Opens the dialog to set a link on the selected cell. Enter the display text and the link target.
Tip: If a link already exists on the cell, the edit dialog opens instead.
HyperlinkCtrl+KLink Setup
How to Insert Hyperlinks in Excel Cells with Ctrl+K
and When to Use Them
Are you still right-clicking every time to set a link in Excel? With Ctrl+K, the hyperlink dialog opens instantly.
Shortcuts you will master in this article
Ctrl + K
Setting many reference links in a list creates compounding overhead
Internal portals, SharePoint references, related files, jumps to data on other sheets — Excel involves more linking than you might expect. Repeatedly going through right-click → 'Hyperlink' for each one adds up quickly.
Ctrl+K is the same shortcut used in browsers, so once learned, it works across multiple applications.
Hyperlink Setup: Three Common Scenarios
Covers the three most common patterns: URL links, in-document references, and email links.
2
'Existing File or Web Page'Link to a URL or external file
Enter the URL (https://...) or file path in the Address field.
Tip: Links to OneDrive or SharePoint files are configured the same way.
3
'Place in This Document'Jump to another sheet or cell in the same workbook
Specify a sheet name and cell address (e.g., Sheet2!A1) to create a click-to-navigate link to that location.
Tip: Useful for creating navigation shortcuts to frequently referenced sheets in large workbooks.
4
'Email Address'Set up a mailto link
Enter an address and subject line to create a link that opens the email application when clicked.
Tip: Adding email links to contact lists makes them more convenient to use.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Tips for Getting the Most Out of Hyperlinks
In lists with many reference files or URLs, make Ctrl+K the default habit for link setting.
For in-workbook references, 'Place in This Document' creates cross-sheet navigation.
Links set with Ctrl+K are opened with Ctrl+Click.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + K | Insert Hyperlink |
F5 | Go To |
Ctrl + F | Find |
Frequently Asked Questions
Q. How do I remove a hyperlink?
A. Right-click the linked cell → 'Remove Hyperlink'. The cell content (text) is preserved.
Q. I want to open links with a single click, not Ctrl+Click.
A. Excel defaults to Ctrl+Click for opening links. There's no built-in setting for single-click open, though it's possible with a macro.
Q. Ctrl+K isn't working.
A. If Japanese IME input is active, Ctrl+K may not function correctly. Switch to half-width alphanumeric mode and try again.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →