Grouping rows and columns: Structure, summarize and simplify your spreadsheets
Sometimes, the bottom line is all that matters. With the Zoho Sheet's new grouping feature, you can create crisp summaries of voluminous data sets with cascading, multi-layered data chunks that are much easier to comprehend than a plain table. How doessharing with a group
I have created a group and added members to it, but I do not see where/how I can share a sheet with that group. I only get the option to share using email addresses and that has limited me to 20 users. I need to share with more than 20 users, so I wasWhere is the specific sheet sharing?
Hi First, my congratulations to Zoho Team for your amazing job. I know it is not possible to hide rows and columns in a sheet (not implemented yet), but at least I would like to know how to hide a page sheet in a shared sheet (by the way, to hide the vba code is also important to me). I searched same thing as "using specific sheet sharing" but I don't find this option in sharing menu. Please, show me as how can I limit the visibility of information in a shared sheet. Sorry my English and thanksMigrate particular row to another workbook
I need help with migrating a particular row, when the particular task is assigned to certain person within department, the task is auto added to the department HOD Ex. Task A is assigned to X, and I want the whole row to be reflected in X workbook.Zoho Sheet - Printing - Page Breaks and Printing Customization
I think the title is descriptive enough in that I cannot find help documentation on a simple task of adding in page brakes for separating pages on print. ThanksKindly need a macro to lock cell after a data entry
Hi, I am not very used to Zoho VBA and actually I am not good enough to write a macro from scratch. I'm wondering if anyone would be so VERY kind as to show me the code needed for this problem : I'm trying to lock the cells automatically when data is entered. The code for Excel VBA should be like this : ActiveSheet.Unprotect ' Password:="secret" For Each cel In Target If cel.Value <> "" Then cel.Locked = True End If Next cel ActiveSheet.Protect ' Password:="secret"conditional formatting not working when applied to range of cells
I am having a problem applying a conditional formatting to a range of cells. I have 3 conditional formats. They are all Classic - Formula. The formula is one of: b3<today() b3=today() b3>today() When I apply these conditional formats to a single cellcountif function with text compare
In a spreadsheet I would like to count the numbers of occurences of a certain text in an area. Both the area and the text are referenced. Example: The area with text cells is B3:K3 The compare text is in cell A2 In Cell A1 I would like to display the number of occurences, so I'd expect to use a formula like this in cell A1: =countif(B3:K3;=A2) Doesn't work as countif compares only values or expressions. Is there any workaround?Conditional Formatting for cells containing duplicate values not working
Hi, I noticed today that the conditional formatting that is supposed to highlight cells containing duplicate values does not work anymore. It now highlights all cells even if there are no duplicates. This behavior changed today as far as I can tell. SeeHow to Collect minutes of various meeting into single thread
I need tips and help on how to automatically add data from various minutes of meetings, to a common single thread having all the department minutes in one place.Offline Work
I see how to work offline with Zoho writer how do I do the same with Zoho Sheet? mark18Tip #10: 3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in yourSheet Default Font
Is is possible to set the default font and font size in Zoho Sheet ?Share a particular sheet with someone with daily changes update
I want to share particular sheet with someone, so that after a change is made, it will be auto-updated in main sheet. Yes I know I can publish it and give the link to update them, but I want that after they do changes in the shared sheet, it should alsowhat's the equivalent of the "format as a table" function from excel in sheet?
I use this all the time in excel is there a quick equivalent function?Regarding Automation
I need to understand, how to automate deadlines in zoho sheets so that the tab color changes as soon as deadline is passed into red, while before time makes it green and on the way keeps it yellow. Please help in this regards.Do we have auto mailer like outlook in Zoho also by using vba ? or any other option.
I want to automate mis by using auto mail from excel, do we have this facility in zoho like outlook?Inconsistent Autocomplete
Throughout my Zoho Sheet document, it seems that most of the cells will not autocomplete. If I enter information in a cell and want to add that same information to information in a cell below it, most times I will have to type the entire string of wordsNeed Deluge access rows and columns in a pivot table
Can you provide some sample code to access the rows and columns of a pivot table? I can rely on using a named range but where does one name / change name of the pivot table? Just need a little sample code to get me going in the correct direction. ThankAnyway 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 toNon-US date format in Zoho Sheet
Hi I'm a Zoho user from New Zealand where the standard date format is DD/MM as oppose to MM/DD as is common in the US. I can set the format for existing dates in Zoho Sheet to DD/MM but still have to enter new dates in the US format. I.e. to enter November 4 I have to put 11/4 even if the cell is set to DD/MM/YYYY and immediately re-displays the input as 04/11/2011. That's pretty confusing and user unfriendly. Two suggestions: - could the spreadsheet parse the date entered according to the formatDocs 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 AlexConvert Hijri to Georgian Dates in Sheets
Hi, Is there a way to convert the Hijri (Islamic) dates into Georgian dates (formula, VBA ..or any)? Thanksdoesn't have shared sheet
Due to System error shared sheet doesn't show me.Retrieving user ID through VBA
Hi, is there a way to retrieve User ID who did entry on a specific cell and put it on other columns using VBA? eg. if cell A1 changed, User ID to be added in cell B1 Thanks,Tip #9: 5 common spreadsheet errors and how to solve them
Functions can help you automate your calculations and pull important insights from your data set. However, if something goes wrong with these functions, errors occur and make your spreadsheet less reliable. These errors usually have a cascading effect,Retrieve Username in VBA
In Excel I can utilize the username of the individual logged into the computer with Environ("Username"), is there any similar function in Zoho sheets so I can retrieve the name of the individual logged into Zoho? Thanks JonUse of Combobox in worksheet.
Combo box is very useful for set cell value from some choice. So, please Give some solution.. and thanks for your replay.Export Pipe Delimited CSV out of Zoho Sheets
Hello Everyone, I have a spreadsheet that I need to export to a txt or csv file. I know how to export it as .csv file that has a delimiter of a comma. However, my data has commas in it. Because of this, we've set up our import code for our program toCant share the Sheets to anyone
Hello everyone I'm the employ of Shashwat Stainless Inc, I cannot share the sheets to anyone.so please suggest me a suggestion, It shows you can't share this fileImport from Microsoft Access Query
Is it possible to connect a Zoho Sheet to an MS Access database query and import the query data to the sheet?group and ungroup
How do I group and ungroup columns and rows jakob_kishonZoho 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.Deprecation of Zoho Sheet's view.do API
Hello all, The Zoho Sheet view.do API (https://sheet.zoho.com/sheet/view.do) accepting URL and file stream parameters (provided in https://sheet.zoho.com/sheet/excelviewer) has been deprecated, and will no longer be available to use from July 31, 2019. Any code written using this API will stop working after this date. The Office Suite APIs are available as an alternative via Office Integrator. Learn more here. If you have any questions about Office Integrator, add them as comments below or dropzoho Sheets - Cannot center align a cell
For some reason on this worksheet I cannot center align the cells. I might be doing something wrong, but I have used a lot of spreadsheets and not encountered this issue. 🤷♂️ This is on an iMac in Chrome. screen capture attachedZoho Sheets Slow Processing
We are trying to use zoho Sheets in our day-to-day, but... We encounter times when Sheets is updating so slowly that it nearly becomes unusable. The dreaded working notification. Very frustrating. Other online spreadsheet applications have set the usabilityConditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns fallsOne cell, multiple formats, unlimited possibilities.
Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formattingBitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?Can vlookup work between workbooks?
Can vlookup work between workbooks?Next Page
Announcements
Grouping rows and columns: Structure, summarize and simplify your spreadsheets
Sometimes, the bottom line is all that matters. With the Zoho Sheet's new grouping feature, you can create crisp summaries of voluminous data sets with cascading, multi-layered data chunks that are much easier to comprehend than a plain table. How doesTip #10: 3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in yourTip #9: 5 common spreadsheet errors and how to solve them
Functions can help you automate your calculations and pull important insights from your data set. However, if something goes wrong with these functions, errors occur and make your spreadsheet less reliable. These errors usually have a cascading effect,Deprecation of Zoho Sheet's view.do API
Hello all, The Zoho Sheet view.do API (https://sheet.zoho.com/sheet/view.do) accepting URL and file stream parameters (provided in https://sheet.zoho.com/sheet/excelviewer) has been deprecated, and will no longer be available to use from July 31, 2019. Any code written using this API will stop working after this date. The Office Suite APIs are available as an alternative via Office Integrator. Learn more here. If you have any questions about Office Integrator, add them as comments below or dropConditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM Resources
Zoho Subscriptions Resources
ご検討中の方
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
Nederlandse Hulpbronnen
Most Discussed Topics
How to Collect minutes of various meeting into single thread
I need tips and help on how to automatically add data from various minutes of meetings, to a common single thread having all the department minutes in one place.Migrate particular row to another workbook
I need help with migrating a particular row, when the particular task is assigned to certain person within department, the task is auto added to the department HOD Ex. Task A is assigned to X, and I want the whole row to be reflected in X workbook.Regarding Automation
I need to understand, how to automate deadlines in zoho sheets so that the tab color changes as soon as deadline is passed into red, while before time makes it green and on the way keeps it yellow. Please help in this regards.Conditional Formatting for cells containing duplicate values not working
Hi, I noticed today that the conditional formatting that is supposed to highlight cells containing duplicate values does not work anymore. It now highlights all cells even if there are no duplicates. This behavior changed today as far as I can tell. Seeconditional formatting not working when applied to range of cells
I am having a problem applying a conditional formatting to a range of cells. I have 3 conditional formats. They are all Classic - Formula. The formula is one of: b3<today() b3=today() b3>today() When I apply these conditional formats to a single cell
Sticky Posts
Tip #10: 3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your data sets. In this article, we'll look at three ways you can use data validations to create useful dropdown lists in yourConditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns fallsOne cell, multiple formats, unlimited possibilities.
Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formattingTip #8: Using RAND and RANDBETWEEN functions to generate random data sets
Have you ever spent hours working on a sample data record for a demonstration? We're here to show you how to do it in less time. If you want to generate a sample data set for a demonstration, or just to learn how a pivot table works, using the RAND andTip #3: Save your time by replicating formats
Formatting helps to create more visually appealing spreadsheets while keeping data organized. Selectively applying formatting options to your work, such as applying fonts, currency formats, or colors, can be time-consuming and repetitive. Replicating formatting guidelines for your work can help remove the burden of applying these menial tasks, which improve overall productivity in your workflow. Let's say you are collaborating on a spreadsheet with your team and you have to create a combined report.
Top Contributors
madhur.mehta
Samuel Ponraj P
Preetha V
Narendra Eswar G
Vignesh Vel