Anyway to disable autofill?
When in putting In strings of text in multiple cells. The auto complete can cause a lot of problems in make it almost impossible to enter what you want. It almost makes it unusable.Is the beginning of a long string of text is the same it will try toHow can i add up times with format "mm:ss,000"?
Hi! I want to be able to add up times with minutes, seconds and milliseconds. That is easy to get in Excel by formatting cells as mm:ss,000, but Zoho Sheet doesn't recognize it where import the .xsl file. I was looking all different options but I did not find how to format cells like this way. For example: 1:29,002 1:32,010 -------------- 3:01,012 Any workaround? Thank you very much.Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofIs there any option to directly download my spreadsheet in csv or json?
Is there any option to directly download my spreadsheet in csv or json? If yes then, how many requests per second Thank youADR Stock Prices
Hello, It appears as the stock price function for ADRs is one day behind. For example BAYRY, at the close of 7/12/2021, shows $15.15 for the share price. That was the previous day's close (7/9/2021) because the current day's (7/12/2021) close is $15.08.Bitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?Unlocking a shared spreadsheet
I was just testing out the shared spreadsheet feature (one of the things we are most excited about!), and am uncertain how to unlock a spreadsheet after I'm done editing it. For instance: * my husband & I are both logged in to Zoho Sheet. * I have given him read/write access to one of my sheets, which he is currently editing. * He saves the sheet, and then selects another sheet to edit. * At this point, I expect to be able to select our shared sheet, and edit it myself. Instead, I receive a messageHow to make some cells invisible to some users
Hi there, I am collaborating with some colleagues and would like to hide some of the information in our shared spreadsheet (a few cells - not rows or columns). Would love to know if it is possible and how. Thanks, O-RenAuto shapes in Zoho sheet.
Does Zoho sheet supports inserting auto shapes (rectangle, circle...). I did not see any option to do so. If its not supported currently, is there any plans on bring in this features. Any timelines ?Zoho Sheets Not Linking Anymore to other Zoho Sheets with Formula =IMPORTRANGE
I have multiple Sheets using a formula =IMPORTRANGE which were working prior to the recent crash. Every time I either get a Not Link error (so I re-link the sheets) and give me an error #EVAL! I have attempted to create two new sheets and attempted toDeleting shared spreadsheets
Hello I was just wondering what happens to a spreadsheet that I've shared when I delete it. Does it delete it from everyone or just me?Zoho Sheets seem to be down
Zoho sheets keeps saying there is an error or loading a white screen.Docs Sheets very slow?
Are Sheets always this slow? We have been testing ZOHO Sheets as a replacement to Google Docs, but we keep hitting patches of the day where it grinds to a halt. It is either really slow or it will load only a few lines from a sheet and just hang and we have to log out and back in again to get it working,.... We are experiencing it on several computers on various OS and Browsers. We are in Spain, but on 100Mbps Fibre so I don't think it is an issue on our end. Any advice or solutions? Thanks AlexQuestion about the functionality of zoho sheet
Can I add footer to sheet?Use of Unique function in Data Validation for Zoho Sheets
Hi There, Can I use the Unique function to a data validation so that the dropdown only populates the attributes of a column. Or do that with a cell reference. In Microsoft excel, this can be done by adding a # so that the cell reference picks up all theWon't Print - Server Error
In typical Zoho fashion, something doesn't work and an ultra-vague, totally unhelpful error appears. This time, I'm trying to print my spreadsheet. Okay, I did try again. Still doesn't work. Now what? I'm extremely frustrated with this program. I madelink to tab in Zoho Spreadsheet
Is there an easy way to link directly to a tab in a spreadsheet from an external site? For example, I want to link to Tab2, but the zoho sheet only provides a single URL. How do I direct traffic to one particular tab in a spreadsheet, and have another link that directs to another tab? ThanksRecommended Broswer for Zoho Docs
All my Zoho apps work great except for Docs. It simply runs slow buggy compared to all other Zoho apps. This is regardless of using Windows 7 or Ubuntu 12.04. I have tried Chrome, Firefox, IE 9 on Windows and Opera. is there a recommended browser OS combination for Docs? Also, I have not been able to get offline mode to work, all I get is a blank page that has the loading message.Cut -> Paste values and formats in single Spreadsheet
Hello, I am stuck with CUT-PASTE with the following behaviour of spreadsheet: 'Sheet-1'.A:A has [conditional formatting] and [data validation] and 'Sheet-2'.A:A has the same configured rules for [conditional formatting] and [data validation]. When I cutRotating text
It would be very useful to be able to use text vertically and not just horizontally.importXML function and related use case
Hi, I would like to know is the spreadsheet roadmap plans to implement the importXML function? My use case is as following: - I need to get date from a web page and then to compil them - I would like to publish the result in a blog in a form of the dynamic table. The table value must be updated as per the web value. - Because many people ask the way to do that with an online spredsheet, I prefer zoho then Google spredsheet, because when you share a range, the user can style edit it whithout modifyingRemove Total from Pivot Table
Can I remove the Total and Grand Total of my Pivot table?Sheets oauth scopes
Is there a list of OAuth scopes I should use for API access to Zoho sheets?Zoho Sheet Embed options
I would like to be able to embed an active sheet into a web page, i.e visitors to the page can enter data to see changed results but cannot edit the sheet in any other way. Regards PETER J WILLS Business Consultant & Adviser ABN 53 964 553 113 www.bcaservices.com.au pjpw2320How to combine multiple sheets in one IMPORTRANGE?
in Google Sheets and Excel, there is option for this and it is helpful in extracting data. Does Zoho Sheet also support multiple importrange? If so, please help me.Split date and time with space as delimiter
I am trying to separate the date and time in a cell into 2 separate columns. The value in the cell is Mar-25-2021 13:46:49. I want the next column to show Mar-25-2021 and the 2nd column to show 13:46:49. The split function that I normally use in GoogleUsing a Macro as a Function Called From Cell to Populate a Cell Value
I'm trying to populate individual cells with function calls to a macro similar to how one would use a regular function to populate a cell. My function is: Public Function getHours(item As String,high As Number) As Double Sheets("Work Items").SelectDuplicate a Spreadsheet
There are 2 ways to duplicate a spreadsheet in Zoho Sheet . 1. Using 'Duplicate' Option : Click the 'Show Sidebar' arrow or Press Ctrl+O to open the sidebar. Click the Actions icon of the corresponding spreadsheet name and select the 'Duplicate' option from the dropdown menu. A new copy of the spreadsheet will be created with a name in the pattern 'Copy of <original spreadsheet name>'.For example, when you duplicate a spreadsheet named '401K Planner', a new copy of the spreadsheet will be createdZoho Spreadsheet New Line Shortcut?
When I use Google Sheets I can press: CTRL SHIFT and + ..to create a new line. When I try to do the same in Zoho, I get a message: "Column limit exceeded" Is there a shortcut to create a new line?Spreadsheet VBA not working with same VBA code used in Excel
I uploaded my excel file to zoho and wanted to run the same file here. The problem is that it gave me errors regarding the vba file. The error was with "inputbox" function used in the VBA code. Now either zoho vba uses a different function for "inputbox" or i dont understand whats wrong. The reason for the vba code was to get data from a public xml api to that spreadsheet. So please help me out.Is it possible to publish a spreadsheet to a website?
Hi, I'm new to Zoho and investigating if it will allow me to do what I'm intending. I'm creating a solar system generation calculator in spreadsheets that I want to publish to a website. Is it possible to do this? The sharing feature seems to only let you share with other Soho members.group and ungroup
How do I group and ungroup columns and rows jakob_kishonOpen files Very slow
Hi Compare to gDrive, sheet opening seems to be slower I wait a long time and made a little screen to show you (I started and stopped before the endIf (Cell) Than (Text)
Hi how do I use this formula in Zoho sheet? =IF(B4="true";"part1";0). I'ts not giving me the result. Please HelpDouble Quote in the Concatenate function
Hi I am trying to put double quote in the concatenate function (something like -> I prefer something "sour" when it comes to deserts. I tried putting two double quotes, didn't work. I also tried putting \" also didn't work (somehow, it would add one more bracket at the end when I put \" Can someone tell me how to resolve this, thx in advance.How do you enter numbers as text?
I've imported an existing spreadsheet with cells that have numbers as text (they're id's and should NOT be treated or formatted as numbers.) Zoho sheets handled this correctly (yay!) But I can't figure out how to enter new ids. In every other spreadsheetVBA Find and Replace - "Replace" button changes next "Find" result, not the text currently highlighted
I just tried to use the Find and Replace functions in the VBA Editor to change some variable names I had used in my macro code. When I enter text in the find box and search for it using "Find", the text is found correctly in the code and highlighted.Zoho Sheet redirected to "Zoho WorkDrive - Create Team" dialog, now I'm signed up for something I never agreed to
A short while ago I tried to open one of my spreadsheets via the web on a Windows PC, and I couldn't. No matter which of my bookmarks I clicked, the spreadsheet wouldn't load and instead a prompt appeared asking me to choose a team name. I don't mindZoho Sheet - Desktop App or Offline
Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.VBA Script will not stop running
I have a script to clear checkboxes in a range and it works perfectly, except it will not stop. After it runs I want to be able to use the checkboxes again for calculations, then run the macro to clear them, then reuse the boxes as needed. As it is writtenNext Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofIntroducing Dynamic Array Formulas to Zoho Sheet
We're happy to announce that Zoho Sheet has opened up the new dynamic array formulas to all our users! The addition of dynamic array functionality will make your spreadsheets and the formulas you use in them a lot simpler, while at the same time makingAnnouncing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet
We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant. Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input. Once you allow access to the sourceNew look, improved usability, and more: the exclusive Zoho Sheet app for iOS and iPadOS
We are constantly working on improving the Sheet mobile app and its usability in terms of speed, design, features, and overall performance. With these aspects in mind, we are excited to announce an exclusive Zoho Sheet app for iOS and iPadOS that willTab Colors and New Currency Symbol of Indian Rupee
Zoho Sheet has recently added support for the following 2 new features: Tab Colors: Since last month, you can set a color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. This option is available on the right click context menu of the worksheet tab. Add color to your worksheets! Indian Rupee Currency - New Symbol: The new Indian Rupee Symbol, ₹, is now supported in Zoho Sheet. This replaces the old "Rs." currency symbol
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho Desk 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.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Most Discussed Topics
ADR Stock Prices
Hello, It appears as the stock price function for ADRs is one day behind. For example BAYRY, at the close of 7/12/2021, shows $15.15 for the share price. That was the previous day's close (7/9/2021) because the current day's (7/12/2021) close is $15.08.Bitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?Is there any option to directly download my spreadsheet in csv or json?
Is there any option to directly download my spreadsheet in csv or json? If yes then, how many requests per second Thank youZoho Sheets seem to be down
Zoho sheets keeps saying there is an error or loading a white screen.Question about the functionality of zoho sheet
Can I add footer to sheet?
Sticky Posts
Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofAnnouncing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet
We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant. Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input. Once you allow access to the sourceNew look, improved usability, and more: the exclusive Zoho Sheet app for iOS and iPadOS
We are constantly working on improving the Sheet mobile app and its usability in terms of speed, design, features, and overall performance. With these aspects in mind, we are excited to announce an exclusive Zoho Sheet app for iOS and iPadOS that willTab Colors and New Currency Symbol of Indian Rupee
Zoho Sheet has recently added support for the following 2 new features: Tab Colors: Since last month, you can set a color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. This option is available on the right click context menu of the worksheet tab. Add color to your worksheets! Indian Rupee Currency - New Symbol: The new Indian Rupee Symbol, ₹, is now supported in Zoho Sheet. This replaces the old "Rs." currency symbolExpanding and securing ways to share your spreadsheet: email as attachment and password protection
While Zoho Sheet allows you to share and collaborate with your colleagues in real time, you might wish to send your spreadsheets as email attachments or keep an offline version of a confidential file with password protection. Here's how our new options
Top Contributors
Mohammed Ibrahim
David
Rohith V K
ibrahim.mohammed
Speak