VBA Macro Code to Open Form
Is there a VBA code to open a form in Zoho Sheets? I want to assign a simple macro to a button to open a form I have created. I've tried the macro recorder but it didn't register any of the actions.Introducing Data Bars: Graphically represent changes in data within the cells
Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient methodZia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes
Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,The new Zoho Sheet for Android: Seamless UI and advanced features
At Zoho Sheet, we know mobile apps have become the go-to platforms for creating, sharing, and storing information. And we understand the importance of an efficient and seamless app experience. We've been working hard on improving the overall user experienceUpdated font library: New font styles and custom font options in Zoho Sheet
Zoho Sheet's font library now supports 500+ font styles in 60+ languages! The updated font library is stacked with new font styles, and some of the previously available font styles have been replaced with equivalent options. There are two ways you canZoho Sheet for iPad: Improved UI, external keyboard support, and more!
The portability and capabilities of the iPad have made it an essential device in the business world. With this in mind, we had launched an exclusive Zoho Sheet app for iPad, with device-specific improvements and enhanced usability. Now, we're improvingOnline Calculator
Created a public shipping volume calculator for my website visitors to use. its pretty cool when you combine the power of zoho sheets and the web experience. I chose zoho because our users dont need to login or created acct like google doc users. this is great because ppl will accept the technology more without resistance. you can see the online calculator here: hxxp://www.dblusa.com/dbl_calculator.php peace! RSAHow to create Quarterly, Yearly report in zoho sheets?
Hi, I have a list of invoices in a Zoho sheet, and I want to link it to other sheets showing quarterly, and yearly report. Please help me in how to do that.Revamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Conditional formatting in Zoho Sheet doesn't work for a range of cells
Please see the attached video.Is Zoho Sheet available for Ubuntu ?
Is Zoho Sheet available for Ubuntu ?Does Zoho Sheet Supports https://n8n.io ?
Does Zoho Sheet Supports https://n8n.io ? If not, can we take this as an idea and deploy in future please? ThanksLets increase Zoho Sheet spreadsheet cell limit to 10 million like Google Sheets
Lets increase Zoho Sheet spreadsheet cell limit to 10 million like Google SheetsDoes Zoho Sheet Supports ifttt.com ?
Does Zoho Sheet Supports ifttt.com ? If not, can we take this as an idea and deploy in future please ? ThanksDoes Zoho Sheet supports API integration ?
Does Zoho Sheet supports API integration ?Does Zoho Sheet Supports zapier.com ?
Does Zoho Sheet Supports zapier.com ? If not, can we take this as an idea and deploy in future please? ThanksCan we have Online Zoho Sheet Supports Offline Use?
Can we have Online Zoho Sheet Supports Offline Use?Content Management System
Is there any plan to develop a CMS application that allows us to manage all of the ZOHO services such as Writer, Sheet, and Planner? Besides that, it would be nice to manage the files and logs of WebNMS using SOA. Otherwise i'll try to make it. Thanks, Takash FSorry! There was a problem saving this spreadsheet. Please Try Again (Error Message)
Hi, I'm using PHP laravel framework for this Zoho Sheet intergration. My problem is I can't save my sheet after edit it. I've already ensured the saveurl is accessible. The saveurl also using HTTPS. Error message when save in Zoho Sheet My Code ThankDark mode in Zoho Sheet—Work with comfort, night or day
With working from home becoming more and more common this last year, we at Zoho Sheet understand that conventional working hours for many people across the globe have changed. That's why we're pleased to say we're making it easier for our users to workZoho Sheet - No filter() function
Hi! There is no filter() function in Zoho Sheet. I attached a few print screen where you can see there isn't a function named 'filter'. I really need this function because right now i need to transfer all of my data into Google Spreadsheet to use fiFont size on button
How do I( alter the font size of a label on a button? Adding the button is easy. But if I right click, and select Edit Label, I can only edit the text, nothing else. So I get Arial 10pt, black text, no other options. Like Henry Ford reincarnated: "YouServer Issue for Zoho Sheets
Unable to access zoho sheets (constant loading status)Zoho Sheet is "temporarily unavailable"
My system is showing that Zoho Sheet is temporarily unavailable. Is there a time frame for when it will be restored?Is there a way to access the data of a cell from a different spreadsheet?
Let's say we have two spreadsheets that are both accessible from the same zoho documents account: docA and docB Can we write a formula in cell in docA that references a cell from docB? What is the syntax to do so?AMPLIAR ACCESO A ZOHO SHEET
POR FAVOR AMPLIAR MI ACCESO A ZOHO SHEETPueden ayudarme hacer ua lista por favor
Quiero hacer una lista que se encuentra en una columna de otra paginaAmbiguous Limit Exceeded
I imported an excel file. When I filter a specific column it pops up an error saying : Limit Exceed for maximum characters in cell. List has thousands of rows. How do I know which cell caused the limit violation ??force close
it is force close when i start editing on mobile phoneNumber Format
How's to format numbers in Indian Style, like Lakhs and crores? Can anyone help. ThanksTODAY() function does not work for me as part of the MINIFS function (Help?)
Hello, need help, please... I want to extract the next date, either today's date or the next day. Tried actually several hours with various combinations, ended up by using the MINIFS function combined with the TODAY() function. Finally had to give up.Work seamlessly with Sheet's shortcuts without affecting the browser
Navigating your worksheets and performing specific actions should be a quick and easy process. That's where keyboard shortcuts come in. Shortcut keys help you accomplish tasks more efficiently, eliminating the need to move away from the keyboard. Whatsheet - copy and paste from excel
can't copy data from excel (Vista, Office 2007)or between zoho sheets joseunit11asoucis
Je n'arrive plus a créé une nouvelle feuilleManual edit of Conditional Formatting Range does not save
See screen recording. https://workdrive.zohoexternal.com/external/0e3e940caff0e33e2d0b7f559a4dad92a0cb0a78e23aed149baeec4eb3671289ZOHO CRM AND ZOHO SHEET INTEGRATED
Hello Everyone, When I prepare an offer, I have an excel table and I use it to find the price but I want to transfer this table to Zoho Sheet. My excel table helps to calculate final price. I want zoho sheet to put final price into offer page on the ZohoCustomize toolbar
I'm hoping to move to Sheet from Excel. There are a handful of buttons I use constantly and would like on the toolbar rather than hunting for them. Is there a way to customize the toolbar to add commonly used buttons? Also, is there a way to put macroSheet - Sum by cell color ?
Hi Looked everywhere for this and can not work it out. Can do in Excel, but not in sheets. In a separate cell, I want to add a sum of values based on a cell colour from a column. Like if it is green it is this value, then in a separate cell if it is redProblem with wrapping text in sheet
when I wrap text in the spreadsheet, the line height does not adjust to view the entire entry. I have to manually adjust each line for each entry. Should it not automatically adjust as in google docs or MS excel?SHEET - Send email when a cell changes
I would like to create a custom function for Zoho Sheet that triggers when a paticular cell changes to a specific value. This would result in sending an email to a recipient (this would be an address that remains the same and included in the script). Example: = IF(N4= "Drafted", <>EmailFunction) 1) Cell N4 changes to "Drafted" 2) Email is sent to recipient or alternatively 3) Post to chat channel I have found the Custom function editor in Sheet. I am not bad at scripting, butNext Page
Announcements
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatThemes in Zoho Sheet: Keep your spreadsheet's formatting consistent
Formatting a spreadsheet is now even easier with Themes. With Themes, Zoho Sheet empowers you to select, customize, and apply a uniform formatting style throughout the entire spreadsheet. When working on a data set with collaborators, you might noticeSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Our pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingCheck out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
Most Discussed Topics
Syncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is thereSUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)Suppress "spreadsheet will not be saved" message on published sheet
I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheetData overlapping error - data connection schedule
Hello, I created a spreadsheet and connected it via data connection to zoho analytics, asking to fetch data monthly from a table in analytics. I want the data in the spreadsheet to be replaced each month with the newest data in the analytics' table. Eachzohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho Creator Resources
Zoho CRM Resources
Sticky Posts
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
Top Contributors
Murugalakshmi S
Narendra Eswar G
Mehnaaz T
kvansensie
Vinoth Kumar K