To paste a hyperlink in Excel, copy a web address, select a cell, and press Ctrl+V; if it does not become clickable, select the cell and press Ctrl+K to add the link. You can also attach a hyperlink to existing words, link to a file, or point to another place in the workbook. These steps are for Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook open in the desktop app, and a cell where you want the link to appear.
- The web address, file location, or workbook destination you want the link to open. For a website, copy its complete address from your browser’s address bar.
- For a link to a file, make sure you know where the file is saved and that the people who will use the workbook can access it.
You do not need a special add-in or formula to create an ordinary clickable hyperlink. A formula is an alternative for some situations, but the built-in Link command is usually simpler.
Step-by-Step
- Copy the destination. To link to a website, open it in a browser, click the address bar, and press Ctrl+C. Check that the copied address includes the correct domain and page. To link to a file, locate it in File Explorer, copy its path if appropriate, or use the file-selection option in Excel’s link dialog. If you are copying a hyperlink from a webpage, use the browser’s Copy link address command when available; copying visible words alone may not copy the destination.
- Select the cell for the link. Return to Excel and click the cell where the hyperlink should sit. If the cell already contains text, you can keep that text as the clickable label. If you want the full web address to show, choose an empty cell. Avoid selecting a range when you intend to create one link in one cell.
- Paste a web address directly if you want the URL displayed. Press Ctrl+V. Excel may recognize the pasted address and make it clickable automatically. If it appears as ordinary text, that is not a problem; continue with the next steps to turn it into a hyperlink. Some sources copy formatted link text rather than only the address, so check the cell after pasting.
- Open the Link dialog if needed. Select the cell and press Ctrl+K. You can also use Insert > Link on the ribbon. In the dialog, choose the option for an existing file or web page when linking outside the workbook. Excel versions can label or arrange dialog controls slightly differently, but the destination field is where you enter or paste the address.
- Enter or confirm the destination. Paste the copied address into the Address field, or type it carefully. For a website, include the full address, such as https://www.example.com/page. For a file, browse to its location if the dialog offers that option. A missing character, extra space, or incomplete address can send the link to the wrong place or make it fail.
- Set the text people will see. In the dialog, use the Text to display field to choose a clear label, such as Open the project brief. If the selected cell already has text, Excel may fill this field automatically. You can use the full address as the label, but descriptive text is often easier to scan in a report or shared workbook.
- Confirm the link. Click OK. The cell should display the chosen label, often with hyperlink formatting such as colored, underlined text. Formatting can be changed, so appearance alone does not prove that the destination is correct. Select the cell and inspect the link or open it to confirm.
- Test the destination. In desktop Excel for Windows, clicking a hyperlink may select the cell first; use Ctrl+click to follow it in the usual configuration. Excel may also show a prompt before opening an external website or file. Check that the address shown in the prompt is the one you intended before proceeding.
For a link to another sheet or cell in the same workbook, select the destination option for a place in this document in the Link dialog. Choose the sheet and, where available, enter the cell reference, such as A1. Give the link a label that explains where it goes. This is useful for contents pages, navigation buttons, or a summary that points to detailed worksheets.
On a Mac, the Link command is also available from the Insert menu, and Command+K is the common keyboard shortcut for opening it. Mac keyboards use Command rather than Ctrl for many shortcuts, but the dialog fields and basic process are similar. In Excel for the web, use Insert > Link or Ctrl+K on Windows; on Mac use Command+K. Web behavior and available destination choices may vary, and browser security or sharing permissions can affect whether a file link opens.
Common Mistakes
- Pasting text instead of a destination. A title copied from a webpage is not necessarily a hyperlink. Copy the link address itself, then add it through Ctrl+K if a direct paste does not create a working link.
- Assuming every pasted URL is clickable. Excel’s handling of pasted addresses can depend on where the text came from and its AutoCorrect settings. If the link remains plain text, use the Link dialog rather than repeatedly pasting it.
- Editing the label and losing track of the link. Replacing a cell’s contents can remove its hyperlink. If you need to change only the visible wording, edit the link’s Text to display field in the dialog and preserve the destination.
- Using a local file path for a shared workbook. A path such as one inside your own user folder may work only on your computer. Other people may not have permission or may store the file elsewhere. Use a shared location and make sure recipients have access.
- Confusing Paste Link with a hyperlink. Excel’s Paste Special > Paste Link creates a link to copied cell data, often by inserting a formula that reflects the source cell. It is not the same as making a cell open a website or document.
- Expecting a single click to open the link. Excel may require Ctrl+click in the desktop app, or show a security prompt. That behavior does not necessarily mean the hyperlink is broken.
Tips
- Use descriptive labels. In a shared workbook, labels such as View current price list or Open meeting notes explain the destination better than a long URL. Keep the label short enough that it does not make the column difficult to read.
- Check links before sharing. Test a sample of links, especially those to files, cloud folders, or pages behind a sign-in. A link can be correctly entered but still be inaccessible to someone without permission.
- Keep URLs complete. Web links should include the protocol, usually https://. If you paste only a partial address or misspell the domain, Excel cannot correct the destination for you.
- Use the dialog to update a destination. Right-click the linked cell and choose Edit Hyperlink, or select it and press Ctrl+K, then change the address and confirm. The right-click wording may vary slightly between Excel versions.
- Use consistent formatting. Hyperlink colors help readers recognize links, but do not rely on color alone. A clear label and a brief instruction can make a workbook easier to use, including for readers who have difficulty distinguishing colors.
- Understand link security. Excel can warn before opening links to websites or files. Do not dismiss a warning automatically; verify that the destination is expected and comes from a trusted source.
Troubleshooting
The pasted address stays as plain text. Select the cell, press Ctrl+K, and paste the address into the destination field. Enter a display label if prompted and click OK. You can also check Excel’s AutoCorrect settings if you want addresses typed into cells to become hyperlinks automatically: go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type, then look for Internet and network paths with hyperlinks. This setting concerns automatic formatting as you type; it does not guarantee that every kind of pasted content will be converted.
The link opens the wrong page. Right-click the cell and choose Edit Hyperlink, then inspect the full destination. Check for a missing character, a space at the end, an old page address, or a link copied from an unexpected part of the browser. Replace the destination and test it again.
The link does not open when clicked. Try Ctrl+click in Excel for Windows. If Excel displays a security prompt, verify the address and choose whether to proceed. If nothing happens, edit the hyperlink to confirm it has a destination; a cell can look like a link because of its formatting even when no hyperlink is attached.
A file link works for you but not a coworker. The file may be saved on a local drive, or the coworker may lack access to the folder or cloud location. Move or copy the file to a location both people can access, create a link to that shared location, and confirm that the recipient has permission. Avoid assuming that sending the workbook also sends the linked file.
The link text is too long or displays the wrong words. Open Edit Hyperlink, change Text to display, and leave the destination unchanged. If the address is visible as text but no link is attached, create a hyperlink with Ctrl+K instead of just changing the cell formatting.
The Link command or dialog looks different. Ribbon layouts can vary by Excel update, window size, or platform. Use Ctrl+K on Windows or Command+K on Mac as a practical way to find the link dialog, or look under the Insert tab for Link. In Excel for the web, some file and workbook destinations may behave differently from the desktop app.
Frequently Asked Questions
How do I paste a hyperlink into Excel without showing the full URL?
Select the cell, press Ctrl+K, enter the destination in the address field, and type the preferred wording in Text to display. Click OK. The cell shows your label while opening the URL when followed.
Can I paste a hyperlink from a website and keep its link text?
Sometimes. What Excel receives depends on how the webpage and browser copy the selection. If only words appear, select a cell, press Ctrl+K, and enter the copied link address as the destination. You can then set the visible label yourself.
How do I hyperlink to another sheet in the same workbook?
Select a cell, press Ctrl+K, and choose the option for a place in this document. Select the target worksheet and specify a cell reference if the dialog asks for one. Confirm with OK, then test the link.
Can a hyperlink open a file on my computer?
Yes. Use the Link dialog to select or enter the file location. A local path may work only on your computer, so for a workbook shared with others, link to a shared folder or cloud location that recipients can access.
How do I remove a hyperlink but keep the text?
Right-click the linked cell and choose Remove Hyperlink if that option appears. The displayed text usually remains in the cell. If you only want to change the destination, choose Edit Hyperlink instead.
Why does Excel ask me to hold Ctrl when opening a link?
In desktop Excel for Windows, Ctrl+click is commonly used to follow a hyperlink without opening it accidentally while selecting cells. The exact interaction can depend on the app and settings; in Excel for the web, links may open through the browser instead.
Related
- How to Insert a Separation Line in Word: 3 Easy Ways
- How to Insert a Signature Block in Word for Reuse Later
- Paragraph Break in Word: How to Start a New Paragraph
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Blank Symbol: What <> MeansIn Excel, the not-blank test usually uses the not-equal operator <> with an empty string: =A2<>"". If A2…
- Open in Excel in Protected View: Safe File Access GuideTo open a workbook in Protected View in Excel for Microsoft 365 on Windows, use File > Open…
- How to Make One Page Landscape in Word for MacTo make just one page landscape in Word for Mac, isolate it in its own section with a…
- Excel Data Modeling: How It Works and When to Use ItExcel data modeling means organizing related information into structured tables and connecting them so you can analyze the…
- Paste a Photo Into an Excel Cell: Step by StepTo paste a photo into an Excel cell, copy the image, select a cell, and press Ctrl+V. If…
- Google Sheets COUNTIFS: Count Nonblank Cells CorrectlyTo count nonblank cells in Google Sheets, use =COUNTIFS(A2:A100,"<>"), replacing A2:A100 with your range. The criterion “<>” means…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.