Remove Duplicate Rows - Any Easy Way?
Hi there, Does Zoho sheet allow us to remove duplicate rows or entire rows based on duplicates in one column? I'm looking for the function that is available in Excel Data tab. Thanks, ChadNon-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 formatThe formula does not respond as expected
imported a workbook from LIbreOffice. In the first sheet there are formulas which all give the expected result except this one The formula in cell B41 is as follows: =IF(B46="";"";IF(COUNTIF(B6:B36;"PP|PM")=B46;"";COUNTIF(B6:B36;"PP|PM) ")-B46)). SearchesZoho Sheet History
hi Does Zoho Sheet have function that we can see change history exactly? I can see which cell have been changed, but I'd like to know original information.How do I delete a Zoho Sheet Template for my organization
I made a template in Zoho Sheet for my organization and want to delete the template for whole organization now. Can not find any way to delete it now. Please helpInsert row in multiple sheets simultaneously?
Is it possible to insert a row or column at the same spot of more than one sheet simultaneously? Example: My document contains five sheets with the same basic structure. I would like to update this structure for all sheets by adding a new row below row 3 without repeating the same Insert > Row Below operation manually in each sheet.Changing a date stored as text into date format
Hi all, I have imported a csv sheet with the dates fromated as text like "05 October 2023 10:40:23" and I wonder how the reformat these into a date format. Any help would be warmly welcomed. Best, ChristianMacro or function to display each unique value in a column and the count of occurrences
Hi I've been tearing my hair out a bit with this one. I've got a set of data, which I'm applying filters to, but I then need to be able to quickly see how many unique values there are in a given column and the count of each. My initial plan was a VBASwitching Tabs Results in Loss of Cell Position
This might be a bug report or a feature request, depending on one's interpretation. Using the following scenario: Create a new Zoho Sheet spreadsheet; On the first tab, enter enough data in the first column to force the sheet to scroll vertically; Switch to the second tab; Switch back to the first tab Instead of maintaining my cell location on the first tab, Zoho Spread returns me to the top row of that tab. If I am switching back and forth between tabs, having to scroll every time to recover myTip #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-relatedPublished and embedded Zoho Sheet not getting updated
Hi. I have used the Publish option in a Zoho Sheet to embed it into Zoho CRM's dashboard. The part I'm embedding is a dynamic table. After adding data, the dynamic table is updated. However, the published page has remained the same as when it was published,Name Ranges Disappeared
Is there a data limit in what Zoho Sheets can handle? I have build several tabs within a sheet, some of the tabs having several thousand rows with formulas pulling different pieces of information. After spending nearly a whole day working on a templateEdit History: Prevent data loss during collaboration
With teams moving to hybrid workplaces, remote collaboration has become routine. Zoho Sheet simplifies collaboration for distributed teams with user-specific access levels for file sharing, contextual commenting, and real-time editing tools. It also providesFormat 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,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.How 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.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 ?Lets 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?Sorry! 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 SHEETAmbiguous 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.sheet - 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 macroNext Page
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Updated 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 canWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyNew Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your workIntroducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youSlicers 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,
Most Discussed Topics
Button to Reapply Filters on Sheet(s)
I wrote a macro that I attached to a button to reapply the filters on all my sheets and it says it works, but it doesn't actually do anything. What is wrong with it? Is there another way? Or even make it work for one sheet? Sub UniversalFilterRefresh()How to drag row(s) or column(s)?
Hi. Selecting a row or column and then dragging it to a new position does not seem to work. Am i missing something or this is just not possible in Zoho Sheet? Cheers, JayPower Pivot and Data Modeling functionality in Zoho Sheet
When will MS Excel functionalities like Power Pivot and Data Modeling functionalities be available in Zoho Sheet?Pull cells from one sheet onto another
Hello all! I have created an ingredients database where i have pricing and information and i want to pull from that database into a recipe calculator. I want it to pull based on what ingredient I choose. The ingredients database has an idea and i wantColumn letter from number
Hello, I am trying to select a cell and i have the column number. How do i do this or is there a way of getting the letter from the number? Thank you
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus 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
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
What's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyNew Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your workIntroducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youSlicers 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,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 method
Top Contributors
Vinoth Kumar K
Subashree Ramamurthy
MADHUSUDAN SHARMA
Murugalakshmi S
jamesmitchell