Excel Guides

"Cant Use Hyperlinks in Excel"

If you're looking to insert a hyperlink into an Excel spreadsheet, you may be out of luck. While Excel does support hyperlinks in general, there are some limitations when it comes to using them within the program. Here's a look at what you need to know about using hyperlinks in Excel.

Hyperlinks in Excel

Excel supports two types of hyperlinks:

  • Absolute hyperlinks: These links point to a specific web page or file. They will work regardless of where the file is saved or how it is moved around.
  • Relative hyperlinks: These links are relative to the current file or web page. They will only work if the file is saved in the same location as when the link was created.

Both types of links can be created using the Insert Hyperlink dialog box in Excel.

Limitations on Using Hyperlinks in Excel

While Excel does support hyperlinks, there are some limitations to keep in mind when using them within the program:

  • You can't insert a hyperlink into a cell that already contains text or data. If you want to insert a hyperlink, you'll need to first delete any existing text or data in the cell.
  • You can't use a hyperlink to open another program on your computer. For example, you can't use a hyperlink to open Word or PowerPoint. You can only use hyperlinks to open web pages or files.
  • You can't use a hyperlink to open a file that's stored on your computer. Hyperlinks can only be used to open files that are stored on a web server.

Additional Information

  • .htm and .html files (web pages)
  • .xls and .xlsx files (Excel workbooks)
  • .ppt and .pptx files (PowerPoint presentations)
>

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.