Text Boxes
Any plans on being able to add text boxes and cell merging in the near future?
Is Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?
Select multiple options in a dropdown?
Hello! I am trying to create a column in which you can choose from multiple options. In this case, it's venue categories as an example (weddings, social events, concerts, corporate). I may wish to choose both "social events" and "weddings." I used the picklist for other columns, but I can only choose one. Thoughts on how best to incorporate this (or another way I could set up this information)? Thank you!
Download Failed from sheets
If I create a spreadsheet, then select the area, I go to download as PDF and it says Download Failed. This has worked for years, but suddenly today it hasn't. I have tried on different browsers, linux and Windows with same results.
Quicktime movies
Can I upload quicktime movies from my camera and have other people play them from one of these apps. Vince M
Introducing 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
How to change my sheet to landscape format?
Please help me, I can't seem to find how to change the orientation of my spread sheet, I need it to be landscaped not portrait. Thank you!
Insert/Delete Table Rows macro
Anyone know how to write macros to insert or delete table rows? I use these buttons in Excel all the time for expanding/shrinking BOM tables. I tried recording a macro. But, it is empty after performing the insert table rows command. Looked into writing
[Function Zoho Analytics] - Is there a query function in Zoho Analytics?
Hello team zoho, Is there a Google Cheats query function in Zoho Analytics? If not, how can I replacement?
Stock Prices using STOCK function
Hello, I've been using the STOCK function for over a year without any problems. Today, however, the prices are not getting updated. Might anyone know if there is a problem with this feature? Thank you
How 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-Ren
Can we revert templates to previous versions in the version history?
In the help help on version history it says "click Revert in the toolbar." That 'Revert' button is there for spreadsheets, but does not appear for me in templates. Is it missing? Is there a way to revert templates to previous versions?
PDF tables to Sheet tables
Hi, I am looking for a way to convert PDF tables to Sheet tables. I am unable to find a way to do it. Two additional info for background. (a) The PDF (basically a credit card statement I am trying to get the transactions into Sheet) is password protected
Published sheet download error
I have a published sheet embedded into my website, but when I click the download button, it says that download has failed. I have enabled downloads in the sheet publish settings.
How do I print a worksheet with VBA code?
I want to create a print button on an embedded sheet on a website. How do I create a macro that will print the active worksheet?
Print
does zoho macro support print related function? thanks
formula to get current sheet name
What formula can I use to get the current sheet name? In excel I could use - MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) In zoho sheet, there is the "sheet" function but how do I get it to return the sheet name instead of the sheet number. The reference page is not very clear on this thanks
Remove Rows with Duplicate Cells
I need to search a column for duplicates, then remove the entire row of that duplicate. I do not see how to do it easy just like Microsoft Excel (which I no longer have access to). *I'm using the built-in "Data Cleaning" tool. I'm able to highlight all
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, Chad
Non-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 format
The 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)). Searches
Zoho 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 help
Insert 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, Christian
Macro 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 VBA
Switching 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 my
Tip #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-related
Set print area
Is there a way to set the print area like I can with Excel
Recent Maintenance
Dear Zoho Sheet Team The recent 'Improvements' gave me considerable problems. I can't evaluate the extent of these problems, they could range from fixable to disastrous. I can't check more then 300 sheets quickly. A lot of my images have suddenly disappeared, this seems to be the major problem. Where have the gone and how can they be recovered? Another thing I noticed - you have taken away the 'SAVE' button. Clicking on 'FILE' doesn't give a 'SAVE' facility either. I will keep working and report
Published 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 template
Edit 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 provides
Format 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.
Themes 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 notice
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
Zia 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 experience
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 can
Next Page