You usually can’t hyperlink in Excel because the cell or sheet is not editable, Excel is treating the entry as text, automatic link creation is turned off, or the destination is unavailable. To add one manually in Excel for Microsoft 365 on Windows, select a cell, press Ctrl+K, enter or choose a destination in the Insert Hyperlink dialog, and select OK.
First, identify what is going wrong
People use “can’t hyperlink” to describe several different problems. The command might be unavailable, a web address might stay as plain text, a link might appear but not open, or Excel might display a formula instead of a clickable link. Each symptom points to a different cause, so check what happens before changing settings.
- The Link command is greyed out: Check whether the sheet or workbook is protected, or whether you have permission to edit the file.
- A typed address stays plain text: Automatic hyperlink formatting may be off, or the cell may be formatted as Text.
- The link exists but does not open: The destination may be wrong, unavailable, or blocked by a security prompt or organizational policy.
- You see formula characters in the cell: Excel may be treating the formula as text, or Show Formulas may be on.
Try adding a link to a blank cell in a new, unprotected workbook. If that works, the problem is likely specific to the original sheet, its permissions, or its formatting rather than a general Excel failure.
How hyperlinks work in Excel
A hyperlink connects a cell or an object to a destination. That destination can be a website, a file, a location in the current workbook, or an email address. A cell can display readable text such as Open the guide while linking to a longer web address or file path. The displayed text does not have to match the destination.
Excel can create a link through the Insert Hyperlink dialog or through the HYPERLINK function. Either way, the link is stored in the workbook; opening an external destination also depends on the device, available software, network access, and security settings. For example, a link to a local file on one computer may not work for someone whose computer does not have that file at the same path.
Add a hyperlink manually
In Excel for Microsoft 365 on Windows, select the cell that should contain the link and press Ctrl+K. You can also use Insert > Link on the ribbon. In the dialog, choose the appropriate destination type, enter the address or select the target, set the text to display if needed, and select OK. If you want to link to another cell or sheet in the workbook, choose Place in This Document and select the destination.
For a website, include the complete address, such as https://example.com/help. For a file, browse to it or enter its path. For an email link, enter the recipient address. If the link should be on words already in a cell, you can select that cell and use the display-text option in the dialog. You can later right-click the cell and choose Edit Hyperlink to inspect or change its destination.
On a Mac, Command+K is the usual shortcut for inserting a link; the ribbon’s Insert tab also provides a link command. Excel for the web has a link command as well, although dialogs and available options can differ from the desktop app. If a shortcut does not open the dialog in your version, use the ribbon command instead.
Why typing a web address may not make a link
Excel can automatically turn some typed web and network addresses into hyperlinks, but this behavior depends on an AutoFormat setting. In Windows desktop Excel, check File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type. Look for Internet and network paths with hyperlinks and enable it if you want Excel to format addresses automatically. The wording or location may differ slightly in other Excel versions.
Automatic formatting is not required to create a link. If the option is off, use Ctrl+K or Insert > Link. Also check the cell’s number format: if it is Text, Excel may preserve what you type as literal text rather than interpreting it as an address or formula. Change the format to General, then re-enter the address. Changing the format alone may not convert content already entered; retype it or edit the cell and confirm the entry.
A website address can also look like a link without being one. If it is only underlined or colored because of cell formatting, clicking it may do nothing. Use the Link command to add a real destination, or right-click the cell and check whether Edit Hyperlink is available.
When the Link command is unavailable
If Insert > Link is disabled, first consider whether the workbook is open in a mode that prevents editing. A file opened read-only, a workbook with restricted permissions, or a sheet protected against changes may limit what you can do. Check the title bar for read-only status and look under Review for protection controls. If you are allowed to edit the workbook, use Review > Unprotect Sheet to remove sheet protection; a password may be required.
Protection settings and managed files vary, so do not assume that every disabled command has the same cause. If the file is shared through a work or school service, an administrator or the file owner may control editing. Save a separate copy if you are unsure whether changing protection or formatting is appropriate. If the Link command is available in a new workbook but not the original, that comparison is useful evidence that the original file has a restriction or unusual state.
When a hyperlink is present but will not open
A link can be correctly created but still fail at the destination. Check for spelling errors, missing parts of the web address, and accidental spaces. Test the address in a browser. For a file or network folder, confirm that it exists and that you have access. A path such as C:\Reports\guide.pdf refers to a location on a particular computer; it is not a reliable shared link if other users do not have the same path.
Excel may display a warning before opening an external link. A warning is a security check, not proof that the hyperlink is broken. Read the message and proceed only if you trust the destination. In a managed workplace, security policy may restrict certain links or file types; ask your IT administrator rather than disabling protections indiscriminately. If a web link opens the wrong app, check the operating system’s default browser or the application associated with that kind of file.
For a workbook shared with others, prefer a stable, shared web address or an approved cloud-storage link over a local drive path. A link that works for its creator can fail for a recipient who lacks permission, is signed in to a different account, or cannot reach the network location.
Use the HYPERLINK function
The HYPERLINK function is useful when you want the destination or the displayed label to come from worksheet data. It creates a clickable link from a link location and optional friendly text. With a web address in A2 and a label in B2, enter this formula in C2:
=HYPERLINK(A2,B2)
For a fixed destination and label, a formula can also be entered directly. For example, in a blank cell use =HYPERLINK("https://example.com","Open the website"). It displays Open the website as a link to that address. If the formula appears literally, confirm that the cell is not formatted as Text, remove any leading apostrophe, and re-enter the formula. Also check whether Show Formulas is enabled; on Windows, Ctrl+` toggles that display, and the equivalent key combination can differ on Mac keyboards.
If the formula returns an error or the link does not work, inspect the value supplied as the destination. A malformed address, a path that is unavailable to the current user, or a destination that Excel cannot use may be the underlying issue. The function does not grant access to a file or bypass a website’s permissions. For ordinary static links, the Insert Hyperlink dialog is often easier to maintain than a formula.
Excel desktop, Mac, and web differences
The core idea is the same across Excel for Windows, Mac, and the web: add a destination to a cell, then make sure the person opening it can reach that destination. The ribbon names, keyboard shortcuts, and dialog layouts can vary. On Windows, Ctrl+K is the common shortcut; on Mac, use Command+K. If your version presents different choices, use the Insert tab’s link command and follow the dialog shown in that app.
Excel for the web runs in a browser and may handle local files or certain desktop-specific destinations differently from the installed app. A link to an online resource is generally a better choice for a workbook shared online than a path to a file stored only on your computer. If a feature is missing in the web app, opening the workbook in desktop Excel may expose additional editing options, provided you have permission to do so.
Frequently Asked Questions
Why is Insert Hyperlink greyed out in Excel?
Common causes include a protected worksheet, read-only status, or limited editing permissions. Check Review for sheet protection and confirm that you can edit the workbook. If you lack permission, ask the owner for an editable copy or access.
Why doesn’t Excel automatically hyperlink a URL?
The AutoFormat option for Internet and network paths may be off, or the cell may be formatted as Text. You can enable automatic formatting in Excel’s AutoCorrect options or create the link manually with Ctrl+K or Insert > Link.
How do I make a URL clickable in Excel?
Select the cell, press Ctrl+K on Windows, enter the web address, and select OK. Alternatively, type a HYPERLINK formula with the destination and optional display text. Confirm the address is complete and that the cell is not storing the formula as text.
Why does my Excel hyperlink open a warning?
Excel can warn before opening external destinations because links may lead to untrusted websites or files. Check the destination carefully and continue only if you trust it. In a work-managed environment, ask IT about policy restrictions instead of turning off security protections.
Why does a hyperlink work for me but not for someone else?
The other person may not have access to the target, may be using a different account, or may not have the file at the same local path. Use a shared location and verify that recipients have permission to open it.
A quick troubleshooting checklist
To narrow down the cause without changing unrelated settings, try these checks in order:
- Test Ctrl+K or Insert > Link in a blank cell.
- Check whether the workbook is read-only and whether the sheet is protected.
- If a typed address stays plain, inspect the AutoFormat setting and the cell’s Text format.
- If a formula is displayed, check for a leading apostrophe, Text formatting, or Show Formulas.
- If a link will not open, test its destination and confirm that the current user has access.
- For shared files, replace local-only paths with links recipients can reach.
These checks separate link creation from link access. Excel may be working correctly even when the destination is inaccessible, and a disabled automatic-format setting does not prevent you from adding a hyperlink manually.
Related
- Scenario Manager in Excel: Meaning and How to Use It
- Excel Scenario Manager: How to Create and Compare Cases
- Scenario Manager and Data Tables in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Remove Duplicates: Why No Duplicates Are Found and What to CheckIf Excel’s Remove Duplicates command reports that no duplicates were found, it means no two rows matched across…
- Open in Excel from the Web: Files and LinksTo open a web-based spreadsheet in Excel, either open the workbook in Excel for the web and choose…
- How to Merge Cells in Excel: Steps and Safe OptionsTo merge cells in Excel for Microsoft 365 on Windows, select a rectangular range, then choose Home >…
- Excel Remove Duplicates but Keep One Copy in a ListTo remove duplicates in Excel but leave one copy, select your data and choose Data > Remove Duplicates;…
- Excel Power Query Date Format: Types, Changes, and FixesIn Excel Power Query, set a column’s data type to Date to make its values usable as dates;…
- PowerPoint Presentation Notes: How to View and Add ThemTo get notes on a PowerPoint presentation, open the presentation, select a slide, then choose View > Notes…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.