You have a spreadsheet of supplier names, and your manager wants each name to open the supplier's website in a new tab. You have a long catalog sheet, and the table of contents on Sheet1 should jump straight to the right product row on Sheet2. You have a list of employee email addresses, and clicking any name should open a fresh email in Outlook. All of that is hyperlinks — and Excel makes them surprisingly easy once you know which path to take.

The short version. Two main ways. Press Ctrl+K on the cell you want to be a link, fill out the Insert Hyperlink dialog, click OK. Or write the HYPERLINK function as a formula: =HYPERLINK("https://example.com","Click here"). The first method is faster for one-off links.

The second is the only way to build links from data that already lives in your sheet — pull a URL from column A, a label from column B, glue them together with a formula, and you have hundreds of hyperlinks in one fill-down. Both methods cover every link type Excel supports: web pages, email addresses, files on disk, other sheets in the same workbook, even brand-new documents.

This guide walks through both methods end to end. We will cover Ctrl+K and all five categories in the Insert Hyperlink dialog, the full HYPERLINK function syntax, linking to another sheet within the same workbook, linking to a specific cell, building mailto links, removing hyperlinks one at a time or in bulk, and the autocorrect setting that decides whether typing a URL becomes a link automatically. By the end the entire feature will feel small — because it is small. Most of what makes hyperlinks feel confusing is just the dialog box being unfamiliar.

Let us start with the dialog approach, because that is what most people reach for first. Click the cell you want to turn into a link — or select the text inside a cell that already has content. Press Ctrl+K on Windows or Cmd+K on Mac. The Insert Hyperlink dialog opens. (You can also right-click the cell and pick Link from the menu, or use Insert tab > Links group > Link. They all open the same dialog.)

The dialog has two key fields and a column of four (or five, depending on your Excel version) icons down the left. The fields at the top are Text to display and Address. Text to display is what the user sees in the cell. Address is where the click actually goes. If you already have text in the cell when you press Ctrl+K, that text shows up in the Text to display field automatically. Fine — leave it or change it. Whatever ends up there is what the cell will say after you click OK.

The icons down the left side switch between link categories. Existing File or Web Page is the default and the one you will use most. It lets you type a URL into the Address field, browse to a file on your hard drive, or pick from a list of recently used files.

Place in This Document jumps to a specific cell in the same workbook — pick the target sheet, type a cell reference like A1, click OK. Create New Document makes a brand-new file (rare; mostly used by people building document libraries). Email Address builds a mailto link that opens the user's default email client with the address already filled in.

So how do you create a hyperlink in Excel that points to a web page? Click the cell. Press Ctrl+K. Make sure Existing File or Web Page is selected on the left. Type the full URL into the Address field — including the https:// prefix. Optionally change the Text to display from the URL to something readable, like "Supplier website" or "View documentation." Click OK. Done. The cell shows the friendly text in blue and underlined, and clicking it opens the URL in your browser.

One detail people miss: if you leave the Text to display empty, Excel uses the URL itself as the label. That is fine for short URLs and ugly for long ones. A cell that says "Acme product page" reads better than the same cell showing https://acme.example.com/products/widgets/categories/heavy/page=3 in tiny font. Almost always, set the Text to display before clicking OK. You can edit it later by pressing Ctrl+K on the cell again, but it is faster to get it right the first time.

For an email link, click the Email Address icon on the left side of the dialog. Type the address into the E-mail address field — Excel automatically prepends mailto: for you, so just type the plain address like orders@example.com. You can also pre-fill a subject line in the Subject field. The friendly text (Text to display) might be the recipient's name, or simply "Email orders." Click OK. Clicking the cell later opens a fresh message in whichever email client the user's computer has set as default — Outlook, Apple Mail, Thunderbird, whatever it is.

For a file on disk, stay on the Existing File or Web Page screen and use the file browser in the middle — Current Folder, Browsed Pages, Recent Files. Or click the small folder icon to browse anywhere on your computer. Pick a file and Excel inserts the full path into the Address field. Clicking the link later opens the file in whatever app handles that file type — Word for .docx, Excel for .xlsx, Acrobat for .pdf, and so on.

Worth mentioning: file links can be either absolute (the full path, like C:\Users\Sarah\Documents\report.pdf) or relative (relative to where the workbook is saved). Absolute paths break the moment the file moves or you email the workbook to someone else. Relative paths only work when the linked file lives in or near the same folder as the workbook. For workbooks you will share, prefer storing files in the same folder and using relative links — or, better, host the files in OneDrive or SharePoint and use web URLs.

Linking to another sheet inside the same workbook is the move that turns a flat spreadsheet into a navigable mini-app. Imagine a workbook with a Dashboard tab, a Sales tab, a Inventory tab, and an Employees tab. On the Dashboard, you want four big buttons — click Sales, jump to Sales!A1; click Inventory, jump to Inventory!A1. Hyperlinks do exactly that.

Click the cell on the Dashboard. Press Ctrl+K. On the left side of the dialog, click Place in This Document. The middle of the dialog now shows two boxes: one for the cell reference (default A1) and one listing every worksheet and every defined name in the workbook. Click the destination sheet — Sales, Inventory, whatever it is. Optionally type a different cell into the cell-reference box (B7, or D42, or wherever you want to land). Set the Text to display to something readable like "Sales summary." Click OK. The cell is now a one-click jump to that sheet.

The syntax under the hood is SheetName!CellRef. So a link to cell A1 on the Sales sheet is internally written Sales!A1. If your sheet name contains a space, Excel wraps it in single quotes — 'Q1 Sales'!A1. You do not have to type that yourself when you use the dialog, but it is worth knowing because the HYPERLINK function below uses it directly.

For the dialog method, the only gotcha is defined names. If you have given a range a name (Formulas tab > Name Manager), it shows up in the same list as worksheet names, just below the Cell Reference box. Click a defined name and the link points there instead of a hard-coded cell. Defined-name links are more resilient — if the underlying data moves, the link follows. Hard-coded cell references stay stuck pointing at A1 even after you insert rows above it.

The HYPERLINK function is where Excel hyperlinks stop being a one-by-one task and become a fill-down. The syntax is =HYPERLINK(link_location, [friendly_name]). The link_location can be any text — a URL, a mailto address, an internal reference like #Sheet2!A1, or a file path. The friendly_name is what shows in the cell. Both arguments can be hard-coded strings, cell references, or the output of other functions.

Suppose column A has supplier names and column B has their websites. In column C you want a single clickable cell that says "Visit website" per row. Type =HYPERLINK(B2,"Visit "&A2&" website") in C2 and fill down. Now C2 says "Visit Acme website," C3 says "Visit Beta Co website," C4 says "Visit Charlie Inc website," each linking to the appropriate URL in column B. Twenty suppliers? One formula, fill down once, twenty links built. That is the whole reason the HYPERLINK function exists — to make hyperlinks composable with the rest of your data.

Compare that to the dialog. Twenty suppliers, twenty Ctrl+K presses, twenty dialog confirmations. Boring and error-prone. The formula approach is fundamentally faster anywhere you have a list of targets in cells already.

The trade-off: HYPERLINK results are formulas, not real Excel hyperlinks in the technical sense. They look the same and behave the same when you click them, but a few advanced features differ. You cannot right-click a HYPERLINK formula and pick Edit Hyperlink — you have to edit the formula directly. Pivot tables and Power Query sometimes treat formula links and dialog links differently. And formula links recalculate every time the workbook recalculates, which on giant sheets adds a few milliseconds. None of these matter for most workbooks. Just know they exist.

How to create link in Excel that jumps to a specific cell — not just a sheet, but a particular row deep inside it. The dialog handles this easily. Press Ctrl+K, pick Place in This Document, type the cell reference into the cell-reference box (D42, or B500, or wherever), pick the target sheet, click OK. The link now lands the user directly on that cell, which Excel will scroll into view if it is below the fold.

For the HYPERLINK function, the syntax is the same as sheet-only links — just add the cell reference after the bang: =HYPERLINK("#Sheet2!D42","Jump to D42"). Single-quote the sheet name if it has spaces. You can also reference a range like #Sheet2!D42:F50 — clicking the link selects the whole range, which is a small but pleasant detail when you want to draw attention to a block of data.

What about a cell that does not exist yet? You can write =HYPERLINK("#Sheet3!A1","Go to Sheet3") even before Sheet3 exists. The link will not work until you create Sheet3, but it will not throw an error either — Excel just silently does nothing on click. That is occasionally useful for template workbooks where users add sheets over time.

To remove a hyperlink while keeping the text: right-click the cell and pick Remove Hyperlink. The cell goes back to plain text. To remove every hyperlink in a worksheet at once: press Ctrl+A to select everything, right-click any selected cell, and pick Remove Hyperlink. Excel strips them all in one go. If you have a mix of links and you want to remove some but not others, hold Ctrl and click each one to multi-select, then right-click and Remove Hyperlink.

How do I create a hyperlink in Excel from existing data? Use the HYPERLINK function as covered above — column A has labels, column B has URLs, column C has =HYPERLINK(B2,A2) filled down. Faster than the dialog by a factor of ten once your list is more than five rows long.

A few small details that come up after you have been using hyperlinks for a while. First, formatting. A new hyperlink picks up the workbook's Hyperlink cell style — blue text, underlined. After you click a hyperlink, the cell switches to the Followed Hyperlink style, usually a dimmer purple. Both styles are editable from Home tab > Cell Styles. Right-click Hyperlink, pick Modify, and change the font color, bold, underline, or background. The change applies to every existing hyperlink in the workbook, so you only do it once.

Second, copying hyperlinks. Ctrl+C then Ctrl+V on a hyperlinked cell copies the link, the text, and the formatting. Paste Special with the Values option pastes only the displayed text, stripping the link. That is the fastest way to convert a column of hyperlinks into a column of plain text — select the column, Ctrl+C, right-click and Paste Special > Values.

Third, hyperlinks and Excel tables. When you turn a range into a table (Ctrl+T), hyperlinks inside the table keep working, and they also pick up any conditional formatting or banded rows the table applies. Sorting and filtering preserve hyperlinks correctly — the link follows the row, not the position. That is the right behavior, and it makes hyperlinked columns a perfectly safe pattern inside tables.

Fourth, Excel on the web vs Excel desktop. The web version (Excel for the Web in a browser) supports hyperlinks the same way — Ctrl+K opens the same dialog (Insert tab > Link), HYPERLINK formulas work identically. The one difference is that on Excel for the Web, hyperlinks to files on your local hard drive will not resolve, because the browser cannot reach into your file system. Web URLs, email addresses, and internal sheet links all work fine.

Fifth, the protocol matters. Web links must start with http:// or https://. Email links must start with mailto:. File links must start with file:/// (three slashes) or just be a normal file path. Skip the protocol and clicking the link may do nothing, or Excel may guess wrong. The dialog adds the right protocol for you automatically. The HYPERLINK function does not — you have to type the full thing yourself.

One more pattern worth knowing: dynamic hyperlinks that follow whatever cell you click. Combine HYPERLINK with CELL or ADDRESS to build a link target on the fly. For example, =HYPERLINK("#"&CELL("address",B2),"Edit this row") creates a link to whatever cell B2 happens to be, even after you insert rows above. That kind of formula composition is impossible with the Ctrl+K dialog, and it is where HYPERLINK shines for dashboard builders.

Another: build navigation buttons that change based on user input. Cell A1 holds a sheet name typed by the user. Cell B1 holds =HYPERLINK("#"&A1&"!A1","Go to "&A1). Now whichever sheet name the user types in A1, clicking B1 jumps there. Tiny example, but it is the foundation of every Excel-based mini-app where the user navigates by clicking instead of finding tabs at the bottom of the window.

One final tip about how do you create a hyperlink in Excel without using the mouse at all. Tab into the destination cell with arrow keys, press Ctrl+K, the dialog opens with focus on Text to display. Type the label, Tab to Address, type or paste the URL, press Enter. From keystroke to live link in maybe five seconds, no mouse touched. That is the workflow people who build big workbooks all day use, and it is roughly twice as fast as the right-click route.

To recap. Two main ways to create a hyperlink. The dialog: click the cell, press Ctrl+K, pick a link type on the left (Existing File or Web Page, Place in This Document, Create New Document, Email Address), fill in Text to display and Address, click OK. The formula: =HYPERLINK(link_target, friendly_text) where link_target can be a URL, a mailto, an internal reference like #Sheet2!A1, or a file path. Both methods cover every kind of link Excel supports.

To link to another sheet, use Place in This Document in the dialog, or =HYPERLINK("#SheetName!A1","label") in a formula. To remove a hyperlink, right-click and pick Remove Hyperlink — the text stays, the link goes. To stop Excel from auto-hyperlinking URLs you type, uncheck the AutoFormat As You Type option in File > Options > Proofing.

The whole feature is small once you have done it three or four times. The Ctrl+K shortcut handles 80% of cases, the HYPERLINK function handles the rest, and between them you can wire a workbook into a fully navigable mini-app — table of contents on the front, jumps to every detail sheet, links to source files and supplier websites, mailto buttons for the team. None of it is technically advanced, all of it makes a workbook far more usable.