Recommended 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.Open 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 writtenSheet doesn't display correctly after macro runs
Hi there, I'm using the following code as part of a macro in one of my sheets, to record information from one worksheet into another: Sub LogTaskComplete(ByVal taskName As String) Dim currentSheet As String currentSheet = ActiveSheet.NameError message trying to open spreadsheets
Hi, I am receiving the attached message with I try to open all but one of my spreadsheets.cut and insert
in most spreadsheet docs (Excel) when you cut the data from one area and try to put it somewhere in the same sheet the rest of the sheet is automatically moved down so that it fits in without overwriting any other information. however in Zoho any cutting moves the intended rows but overwrites other rows unless you specifically create a space of the correct size for it. this would save a lot of time if the sheet acted more like Excel in this regard. thanks.Apply conditional formatting to a row
I would like to apply conditional formatting to a row. This can be really helpful for project based sheets where each row might be associated with a task/to-do. When the task is complete, a cell within the row is Checked/True, or updated to 100% orSheets - Data Validation not working properly
Hi there, I have a document with approx. varias sheets in it. The information input into 3 of these sheets is sent to its respective Pivot Table. Another Sheet has 3 columns set up with Data Validation pulling the information from the pivot tables.Sheets - Return to last cell
I can see in the URL for sheets, that the end of the URL points to the sheet and range in the sheet. Is there a way to have the URL return you to the last cell you were working on after exiting and reopening the sheet?Drop down menu in Zoho Sheets
Hi, I was wondering if (like in Microsoft Office Excel) you can create drop down menus' in Zoho sheets. If so how do I do it? Cheersexporting as pdf not working fine
I did try to export sheet as pdf and not working properly. please fix this. vikybossIntroducing 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 makingMore colors
Hello, Help me understand, while working with sheets, I go to "more Colors" select a color I like and use it in my spreadsheet. However, once I close out that sheet then later reopen it, the color I selected from more colors is not there. Why and whatAnnouncing 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 sourceZoho sheets not loading
When I try to open certain sheets from the list of zoho sheets I have few that will work perfectly whilw others will end up in a blank white screen.How many Sheets can we have?
How many Sheets can we have, is there any limitation?Creating Countdown timer
Hello, I'm trying to create a count down timer using a specific time I have already figured. For instance i have a time of "01:30:00". I'm wanting to incorporate a button into my sheet that starts counting down 1 second at a time. Ive tried using a formulaNew 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 willZoho Sheet - Conditional Formatting - Formatting the entire row
How can I apply formatting to an entire row based on the text value in one cell? I tried it, and it seems to work on that cell itself.Tab 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 symboljava.lang.Object cannot be cast to com.tripi.asp.Node
Good afternoon to everybody. I have some arrays which its type are Variant. They came from another function. I need to pass those arrays to another function or subrutine, but when I try to add them throught a parameter, the program crash and give me theNext Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
Build readable, reusable custom functions with LAMBDA()
LAMBDA, the new addition to Zoho Sheet's function gallery, has the potential to change the way you work with formulas in your spreadsheet. The function helps make your formulas more readable and reusable. You can create custom functions that fit yourImport your Google Docs Spreadsheets into Zoho Sheet
You can now import your Google spreadsheet into Zoho Sheet. This will be useful if you want to switch to Zoho Sheet or if you want to simply try out Zoho Sheet. If you don't have an account with Zoho, you can still try this by signing in with your Google account. Here is a video on how to do this. Note: Existing charts won't appear in spreadsheets you import from Google Docs as the Export functionality of Google Docs doesn't give out the charts. Check out the announcement in our blog: https://blogs.zoho.com/general/import-google-docs-into-zoho-productivity-suiteRefine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,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 making
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl 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
import from url
In google sheets i can import an html table from a URL, if I do the same with Zoho sheets I get 'URL not reacheable'. I can't find any information on this so I'm not quite sure why. Any comments or advice welcome.
Sticky Posts
Refine by Zia: a smart way to improve data quality
Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,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 symbol
Top Contributors
test
Shaun Jude O Brien
admin
Mouriya Sakthivel
Nicholas