Excel like a finance pro.
← The libraryPractice · 2 questions →
Editing shortcut
Insert a hyperlink
Ctrl + K on Windows, ⌘ + K on Mac.
CommonDifficulty 950 · Capable
When to use it
Inserts or edits a hyperlink on the selected cell: a web address, a file, an email, or a place in the workbook.
The shape of it
- Windows
Ctrl + K
- Mac
⌘ + K
Worked examples
Web link
Select a cell, Ctrl + K, paste a URL, Enter → The cell becomes a clickable link
Link to a source.
Internal link
Ctrl + K, Place in This Document, pick a sheet → A jump to that sheet
Table of contents sheets.
Edit a link
Ctrl + K on an existing link → Edit or remove it
Same shortcut edits.
Worth knowing
- HYPERLINK formulas are better when the address comes from a cell.
- Right-click, Remove Hyperlink, to strip one.
- Select the cell with arrows to avoid triggering the link.
Where it goes wrong
- Clicking a link cell opens it, so use keyboard selection to edit.
- File links break when the file moves.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.