What is a button in Zoho Sheet?
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:
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
Importing spreadsheets to Zoho Sheet
Import a new spreadsheet From the listing page, click on the Upload button. From the drop down, select the option to Upload Spreadsheet. You can drag and drop files from your computer into the dialog box that pops up, or click on the dialogue box and ...Using Spell Check in Zoho Sheet
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 ...About Zoho Sheet
Zoho Sheet is a cloud-based spreadsheet application. It allows you to create, share, and work together on spreadsheets online, in real time. You can analyze, visualize and publish data using Zoho Sheet across multiple devices and browsers. Zoho Sheet supported browsers
Zoho Sheet supports the following browsers: Mozilla Firefox - Version 55+ Chrome - Version 55+ Safari - Version 9+ Opera - Version 50+ Edge - Version 12+ Incase you're trying to access Zoho Sheet via an unsupported browser or version, you'll face an ...How to lock cell ranges/sheets in Zoho Sheet?
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 ...