=HYPERLINK(link_location, [friendly_name])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single HYPERLINK formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
link_location:
The path or URL to the file or web page that you want to link to. This can be a cell reference, a text string, or a valid web address.
friendly_name:
The text that you want to display in the cell as the hyperlink. This is optional; if omitted, the link_location will be displayed as the hyperlink text.
The HYPERLINK function in Excel is a useful tool that allows you to create clickable links within your spreadsheet. It enables you to link to external websites, documents, or even other locations within the same workbook. This function is particularly helpful for organizing information and providing quick access to related resources.
In simpler terms, the HYPERLINK function helps you enhance your Excel sheets by adding links that can direct users to additional information or resources, making your data more interactive.
Imagine you are creating a project management dashboard in an Excel spreadsheet, and you have the following data:
| Project Name | Link |
|---|---|
| Project A | www.project-a.com |
| Project B | www.project-b.com |
| Project C | www.project-c.com |
| Project D | www.project-d.com |
You want to create clickable links for each project that will take users directly to the respective project website.
To create a hyperlink for Project A, you would use the HYPERLINK formula as follows:
=HYPERLINK("http://www.project-a.com", "Project A")When you apply the formula, the cell will display "Project A" as a clickable link. Clicking on it will take you directly to the website for Project A.
| Project Name | Link |
|---|---|
| Project A | Project A |
| Project B | Project B |
| Project C | Project C |
| Project D | Project D |
Here, each project name can be linked to its respective website, providing easy access to additional information.
The HYPERLINK function is particularly useful when you want to create a more interactive and user-friendly Excel workbook. It allows you to connect your data with relevant online resources or documents, making it easier for users to navigate and find information quickly.
Understanding how to use the HYPERLINK function can significantly improve the usability of your Excel workbooks, enabling you to provide valuable resources at your users' fingertips.
Happy linking!
You have a project management spreadsheet where Column A contains project names and Column B contains links to project documentation stored in a cloud service. You can use the HYPERLINK function to create clickable links that direct users to the relevant project documents. This enhances collaboration and ensures that team members can easily access important information without having to search through multiple folders or emails, streamlining the workflow and improving efficiency.
Beyond the HYPERLINK function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.