What is Hyperlink? Describe the use of hyperlink in Excel.
Answers
Hope this image is helpful to you .
Answer ⤵
Hyperlink :
A hyperlink, or simply a link, is a reference to data that the user can follow by clicking or tapping. A hyperlink points to a whole document or to a specific element within a document. Hypertext is text with hyperlinks. The text that is linked from is called anchor text.
Use the HYPERLINK function to create links to workbook locations, pages on the internet, or to files on network servers.
When a user clicks a cell that contains the HYPERLINK function, Excel will open the file or page specified by link_location. Link_location can be a cell reference or named range, a path to a file stored on a local drive, a path a file on a server using Universal Naming Convention (UNC), or an internet path in Uniform Resource Locator (URL) format.
- Link_location should be supplied as a text string in quotation marks or a cell reference that contains the link path as text.
- If friendly_name is not supplied, the HYPERLINK will display link_location as the friendly_name.
- To select a cell that contains HYPERLINK without jumping to the destination, use arrow keys to select the cell. Alternatively, click on the cell and hold the mouse button down until the cursor changes.