Αποτελέσματα Αναζήτησης
The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified.
There are many things you can do with hyperlinks in Excel (such as a link to an external website, link to another sheet/workbook, link to a folder, link to an email, etc.). In this article, I will cover all you need to know to work with hyperlinks in Excel (including some useful tips and examples).
The HYPERLINK function can build links to other cells in a workbook, other sheets, named ranges, other workbooks, pages on the internet, or files on network servers. You can also use HYPERLINK to create email links. The HYPERLINK function takes two arguments: link_location and friendly_name.
29 Αυγ 2024 · The HYPERLINK function of Excel is a function from the Reference and Lookup functions library of Excel. It allows you to create a hyperlink that will take users to a specified location when clicked. It makes linking and referencing in Excel so much easier.
29 Αυγ 2024 · Hyperlinks in Excel not only allow you to jump to another location like an existing file or a web page, but also jump to another location in a current worksheet or even another workbook.
HYPERLINK(link_location,friendly_name) Link_location is the path and file name to the document to be opened as text. Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook, or to a bookmark in a Microsoft Word document.
16 Ιαν 2023 · The syntax for the function's formula is. HYPERLINK(location, text) where only the first argument is required and contains the path to the Excel file. You can use the second argument to display specific text as the link. Place text in quotation marks or use a cell reference.
