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 youPDF 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 protectedPublished 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? thanksformula 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 thanksRemove 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 allRemove 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.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 methodZia 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 experienceUpdated 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 canZoho Sheet for iPad: Improved UI, external keyboard support, and more!
The portability and capabilities of the iPad have made it an essential device in the business world. With this in mind, we had launched an exclusive Zoho Sheet app for iPad, with device-specific improvements and enhanced usability. Now, we're improvingOnline Calculator
Created a public shipping volume calculator for my website visitors to use. its pretty cool when you combine the power of zoho sheets and the web experience. I chose zoho because our users dont need to login or created acct like google doc users. this is great because ppl will accept the technology more without resistance. you can see the online calculator here: hxxp://www.dblusa.com/dbl_calculator.php peace! RSAHow 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 ?Does Zoho Sheet Supports https://n8n.io ?
Does Zoho Sheet Supports https://n8n.io ? If not, can we take this as an idea and deploy in future please? ThanksLets 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?Content Management System
Is there any plan to develop a CMS application that allows us to manage all of the ZOHO services such as Writer, Sheet, and Planner? Besides that, it would be nice to manage the files and logs of WebNMS using SOA. Otherwise i'll try to make it. Thanks, Takash FSorry! 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 workNext Page
Zoho Campaigns Resources
Announcements
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfCopy across spreadsheets in Zoho Sheet
Now, you can copy your sheets to other spreadsheets or create a new spreadsheet with them. Not just sheets, copy a cell/range and paste it on any spreadsheet with formats and formulas unchanged. Copy cells/ranges Copy cells/ranges to same/different spreadsheets using Copy & Paste options, or Ctrl+C and Ctrl+V shortcuts. Copy sheet To the same spreadsheet The feature for creating a copy of a sheet in the same spreadsheet is now available as 'Duplicate'. Into a new spreadsheet Want to start a new spreadsheetRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #19 - Create checkbox tracker in your spreadsheet
Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sampleTip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
Most Discussed Topics
Does Zoho Sheet "Save as PDF" support Thai font?
Hi I want to download Zoho sheet as PDF Document. In the preview it looking good but when I dowload it the font is look different. I use "Cordia New" but the result look like it swtich to "calibri". I try to use "Print" then select printing destination
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus 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.
Zoho Creator Resources
Zoho CRM Resources
Sticky Posts
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatSlicers 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,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format