Hyperlink data in a cell
Choose the desired cell or data.
Go to the
icon
Under the Insert menu, choose Link.
Choose the type of link to insert, and enter the URL, cell range, or email address respectively.
To display a different text on the cell, enter the desired text in the Display field, and tap Add.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
HYPERLINK
Creates a hyperlink inside a cell that, when clicked, opens the address specified. Syntax HYPERLINK(link_address; [cell_text]) link_address: The URL or address to open. In case of a cell reference, use "#cell_reference". E.g. " www.zoho.com" ...Hyperlink data in a cell
To insert hyperlinks: Choose the desired cell/data. Go to icon Under the Insert menu, choose Link. Choose the type of link to insert, and enter the URL/cell range/Email ID, respectively. To display a different text on the cell, enter the desired ...CELL
Returns information about the address, format, or content of a given cell. Syntax CELL(info_type; cell_ref ) info_type: Text string that determines which information to return. E.g. "WIDTH" cell_ref: The reference of the cell whose information ...Enter data into cells
To edit cells in a spreadsheet: Double tap on the cell you wish to edit or single tap on the desired cell, and use the Edit option in the context menu or the formula bar. This will open the keypad for you to start typing. You can switch between the ...Sort data in a cell range
Select the cell range to sort, keeping the column to sort by as the first column. Go to the icon. Under the Data menu, choose Sort. Tap Ascending or Descending based on how you wish to sort the data.