What is a button in Zoho Sheet? (Web)
A button is one of the objects available in Zoho Sheet that allows you to execute an action when clicked. You can assign macros or custom functions to a button and run the macro with the click of the button every time.
How to insert a Button?
Go to Insert > Button. Once you've inserted the button, you can name it.
To rename the button, click (...) on the top-right of the button and select Edit Label.
How to assign an existing macro to a Button?
- Click (...) on the top-right of the button and select Assign Existing Macro.
- Select the preferred macro from the list of existing macros and click Assign.
How to assign a new macro to a Button?
- Click (...) on the top-right of the button and select Assign New Macro
- In the dialog that appears, select Record Macro or Write Macro based on whether you wish to record a macro or write a macro code.
How to assign an existing custom function to a Button?
- Click (...) on the top-right of the button and select Assign Existing Custom Function.
- Select the preferred custom fuction from the list of existing functions and click Assign.
How to assign a new custom function to a Button?
- Click (...) on the top-right of the button and select Assign New Custom Function
- In the dialog that appears, enter the function name that you wish to create and select the Result Type and click Save. In the editor, create your function and assign it to your button.
How to clone a Button?
How to delete a Button?
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:
Zoho FSM Video Tutorials
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
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
Design. Discuss. Deliver.
Related Articles
Using Web Forms in Zoho Sheet
Web Forms in Zoho Sheet allow you to collect data from customers or collaborators through forms easily, with the data automatically saved in your spreadsheet. This simplifies direct data saving, eliminating the need for a third-party form submission ...Using Spell Check in Zoho Sheet (Web)
How to use Spell Check? Zoho Sheet's automatic spell check helps you catch misspelt words and correct them. To use spell check, Select the range you want to check for misspelt words in and click on the Tools menu. Hover over the Spelling option, and ...How to lock cell ranges/sheets in Zoho Sheet (Web)
What is the use of 'lock' in Zoho Sheet? You can lock cells that you don't want the collaborators to accidentally edit. When you publish a spreadsheet, you can always choose to lock formula cells to make your spreadsheet a little more secure. Owners ...Insert a hyperlink in a sheet (Web)
To insert button: Select the cell you want the hyperlink to be in. Click Insert > hyperlink. There are different places you can point to, using a hyperlink. In Zoho Sheet, you can link to a webpage, a place within the document, a telephone number or ...How to connect external apps to Zoho Sheet via data connection
Zoho Sheet allows you to securely connect with Zoho apps, third-party apps, and import data via data connection. Click here to learn how to create a connection to import data from Zoho apps, URLs and Feeds, and manage them. List of external apps ...