Search function in Zoho Sheet mobil app on android - not working
Hello, Im new here and registered for Zoho Sheet. Than i installed the android mobile app on my tablet (redmi note pro 5g). But I cant use the search function for my added excel table. When I use the web version for zoho sheet with the same imported tableSyncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is thereIs Zoho Sheet available for Linux ?
Is Zoho Sheet available for Linux ?New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!
Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementallyAn edit in Sheets is not being updated in CRM
An edit in Sheets is not being updated in CRM. Does the Sheet need to be manually re-imported?Pueden ayudarme hacer ua lista por favor
Quiero hacer una lista que se encuentra en una columna de otra paginaZoho Sheet for Desktop
Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?inability to apply filter on zoho sheet
I've been unable to apply filter on zoho sheet for the past two days..please help outAbility to Set Text Direction for Individual Cells in Zoho Sheet
Dear Zoho Sheet Team, We hope you are doing well. We would like to request an enhancement in Zoho Sheet that allows users to set the text direction (right-to-left or left-to-right) for individual cells, similar to what is available in Google Sheets. Usecomment dedicated to specific cell?
We have built a sheet for a customer, in which they can add comments to specific cells. However, when we filter the sheet it seems that the comment does not stick to the content of a cell, but the cell itself. Resulting in us not knowing to what the clientUrgent: Server Error & Broken Files in MS Office
Hi, We have attempted to reach you multiple times via chat, email, and this platform but have not received a response. We are experiencing the following issues: When opening a document for editing, we receive a "server error" message (see attached screenshot).Populate Data from Zoho Creator to Zoho Sheet
Hi People, Any recommendations for the use case below? Use Case: 1. Extract all projects along with their related tasks, timesheets, and issues and create a consolidated file Initial Approach: 2. A scheduled workflow will trigger in Zoho Creator to extractHow Do I Create A Progress Bar
Hello, I'm a new user to Zoho Sheets. So far, I'm liking the software. There is a specific task I have been trying to accomplish, and I can't figure out if it's possible or how I would tackle it. I want to create a progress bar that represents how muchFeature enhancement: Highlight rows based on a cell value
Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to drawZoho Sheet import error
The error "Sorry! Couldn't import the spreadsheet. Please try again later." appears when trying to either of the attached spreadsheets, and I'm not sure what the reason is.Restore deleted spreadsheet
Hi all, I can not find my spreadsheet. It seems that my spreadsheet is deleted. Please, restore the spreadsheet. Thanks in advanceStock function not working for Brazil (Bovespa)
Hi, The STOCK function in not working for the Brazil Exchange "Bovespa". This is the syntax I´m using: =STOCK("Bovespa:BBAS3";"PRICE"). Thanks for any help. AleAnyone Can help me converting Excel VBA to Zoho Macro?
The Macro in general is pretty simple, It just opens a Workbook and copys some of data from that Workbook to the one that was initially open. But when I try to use it on Zoho I get this error "Unknown function: GetOpenFilename". If there is any otherwhen I open my sheet ,it always start at "A1" despite I left it at "N234"
when I open my sheet ,it always start at "A1" despite I left it at "N234" Is it possible to make the sheet open where I left it?Sheet Access
How do you set a spreadsheet to only allow certain people to access certain sheets? Like if I wanted to have someone view one sheet that pertains only to them, they can't see the other sheets on the spreadsheet while allowing someone else to view theirs but not others.How to merge data from Zoho CRM to Zoho Sheet
Hello! A few months ago, I made a Zoho sheet with the ability to bring in data from Zoho CRM. It worked by adding the email of a Contact to the sheet, and then it would fill in the rest of the information in the row with information that was stored indisable auto-save
While testing a new sheet I often want to quit without saving if a new idea does not work out, but with autosave, I keep getting stuck with mods I don't want. Can I disable autosave?Sharing sheet without affecting original spreadsheet
I want to share a sheet using a password unique to the end user who will be able to enter data that will help them make a decision. I don't want or need any changes to show up to original file inside my Zoho account. I will be sharing this sheet overDoes 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 destinationCollaborators are not able to upload images
Good afternoon, We have a sheet with 2 current collaborators and when they try to upload an image , a pop up comes up ' server error, there was a problem saving your last edit. Please try again' Can you kindly assist?. Thanks, AnnricaZoho 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. ThanksCan I give access of my Zoho Spreadsheet?
Hello Everbody! I work with a travel and tourism company, and my job is to record the data of clients of the company. And I use zoho for my work. So my question is can I give access of my sheet to the clients and my company. Kindly guide me. ThankyoCopy 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 spreadsheetInvalid Value Type Error Conditional Formatting
Hello, I'd like to use conditional formatting on a table using Classic conditional formatting for Cell Value, but when I attempt to apply the formatting, I get the error "Invalid Value Type: Value must be of type number". The error is being produced becauseHow do I share a single sheet from ZOHO spreadsheet?
I am sure I saw this option 15 days ago. I just stumbled on it and can't find it any more. I would like to share one sheet of a single document to each collaborator. Was it not possible? Thanks in advance!Allow users to display columns dynamically
I have a table with 50 users in Column A and the dates 1 Jan to 31 Dec along Row 1. I want users to be able to add data to the cells but would like to make it easier by allowing users to select a date and display that. So if the user wants to add dataPDF Import
Hi Guys, Zoho Sheet now supports file formats such as XLSX, XLS, XLSM, ODS, CSV, TSV, SXC, XLTX, and TXT. However, support for PDF files is not available yet. Adding this option would be very helpful. Thank you!Using Zia in Zoho Sheet data to research the internet and return answer to a cell in Zoho Sheet
I'm trying to see if Zia (connected with OpenAI key) can take data parameters stored in a Zoho Sheet to conduct research out on the internet then return an answer into the same Sheet. I'm trying to do the equivalent of using something like the =AI() functionHOW CAN I ADD A PDF OR ANY FILE DOCUMENTO ON A CELL FROM MI C: DRIVE PC WITHOUT A WEB STORAGE LINK
I want to add a PDF file reports on a ZohoSheet Cell but i dont know how. I can add images but not files. Can you help me? Thanks a lot.Transitioning FESCO Bill Project to Zoho Sheets and Integration Options
Hello Zoho Support, I'm considering transitioning my FESCO bill project from Google Sheets to Zoho Sheets and wanted to know if there are integration options to seamlessly migrate our existing work. You can view our platform here, any guidance would beConversion of functions from Google Spreadsheets
Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets toIs Drawing feature supported in zoho Sheets?
Is there any option to draw arrows and some basic shapes such as circle , rectangle etc in zoho sheets? if so, can someone help me find itCollaborative editing of spreadsheets by multiple users simultaneously - Is it really possible?
I work in a SharePoint 2010/SharePoint Server 2010 environment and we use MS Office 2007(Excel 2007) . I have been trying to create a MS Office document which will allow multiple users to work on a spreadsheet simultaneously. For that I have: 1) Created a excel workbook and published as a workspace as suggested by Andrea Kalli in her link: http://www.wonderhowto.com/how-to-collaborate-files-between-sharepoint-and-office-2007-182172/ 2) Set up and saved the Excel Workbook as "Shared" and made it availableRevamped 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 sampleNext Page
New to Zoho Recruit?
Zoho Campaigns Resources
Announcements
Import 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-suiteIntroducing 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 youMeet the latest feature of Zoho Sheet: Lock Cells
We are happy to announce the release of one of the most awaited features in Zoho Sheet. You can now lock the cells that you wish to keep secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!
Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementallyFeature enhancement: Highlight rows based on a cell value
Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw
Most Discussed Topics
filter broke my data
I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize they
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
Tip #20 - Three things you probably didn't know you can do with picklists
Hello Zoho Sheet users! We’re back with another quick tip to help you make your spreadsheets smarter. Picklists are a great tool to maintain consistency in your spreadsheet. Manually entering data is time-consuming and often leaves typos and irregularIntroducing 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 youMeet the latest feature of Zoho Sheet: Lock Cells
We are happy to announce the release of one of the most awaited features in Zoho Sheet. You can now lock the cells that you wish to keep secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,Feature enhancement: Highlight rows based on a cell value
Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to drawRevamped 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.
Top Contributors
Narendra Eswar G
Actify Team
jennifergordon1021
Murugalakshmi S
Noor