Is there a way to send a Zoho Sheet signed with Zoho Sign?
I am using Zoho Sheets to create our employee files. We like using Sheets as we can use formulas and add as many lines as needed as the years' updates on salaries and job titles are updated. Is there a way to have the document sent for signature to theCheck 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 FormatWith what formula can I find the last month of the year?
Hello. You did what Google did not do. Firstly, thank you. I turned the Google sheet into a Zoho sheet. With which formula can I find the last month of the year and the last month of the previous year? Now an incorrect result is coming. For example, forBeveled Edges on Zoho sheet charts
Hello, I have a question about charts in Zoho sheet. Could we make beveled edges on the charts? Would really appreciate any response. Best regards, Harroldmissing side bars
Hi there, a member of my team has an issue with the scroll bars going missing on her sheet. is there any reason for this and any solution to the problem? attached is a screen shot of the problem.How to reference cells from another workbook
Hi, I just like to ask for help on how to reference a cell from another workbook. Thank you. HarroldAnnouncing Zoho Sheet's monthly webinar series
Hello there, At Zoho Sheet, we always strive to help you maximize your product experience. Hosting webinars has been one of the key ways for us to communicate product updates, share best practices, and engage the user community. To help you convenientlyConvert text to number
From Zoho CRM, there is a button "Zoho Sheet View" that converts the current view into a spreadsheet. One of my columns in CRM is Amount (a dollar value) but it converts those values to text in the spreadsheet. Is there a simple way to convert text to a number rather than going to each cell and deleting the preceding single quote? the same question applies to the date column. All the dates are now preceded with a single quote - is there a simple way to convert these from text to dates?Anyway 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 toUpdate date & time when a cell is edited
Hi All, I am desiring to have a cell update with the current date and time when another cell is edited. Any ideas? Thank youRed dashed line around cell
I have a red dashed line appearing around a cell. It does not go away when I clear formatting and I'm not sure how to get rid of it. The formula in the cell is quite simple and the cell is displaying the correct result. The outline also persists if IConnect a form with a Spreadsheet
I have a spreadsheet that performs once-off calculations on inputted data. I made the input fields editable and locked the other fields, and that works on a desktop browser (Firefox). However those fields are not editable on a mobile browser (FirefoximportXML function and related use case
Hi, I would like to know is the spreadsheet roadmap plans to implement the importXML function? My use case is as following: - I need to get date from a web page and then to compil them - I would like to publish the result in a blog in a form of the dynamic table. The table value must be updated as per the web value. - Because many people ask the way to do that with an online spredsheet, I prefer zoho then Google spredsheet, because when you share a range, the user can style edit it whithout modifyingIMPORTRANGE with table references?
Can IMPORTRANGE be used to get a table instead of a range? More specifically, can I use column references to only get the columns I want instead of the whole table? I want the imported data to grow as the table grows. I've tried this: Where my table nameHow can I stop a NOW() from update every time I open the sheet?
Hello, I'm trying to use the current function =IF(B1<>"", NOW()). Is it possible to update the NOW() function only when the B1 cell is modified and not when the sheet is opened? Best regardsList Range In Zoho Sheets Data Validation
Hello, I have 2 worksheets "Sheet 1" & "Sheet 2". I want to set data validation in Sheet 1 but using a named range for the drop-down list. I have set a dynamic named range CSID "OFFSET(Sheet2.$A:$A;0;0;19999;0)". I tried typing in CSID in the list or cell range but it didnt work like Excel. Please help, thanks.copy format ?
Is there a way to copy the format from one cell, or group of cells to another cell or group of cells.(like the format paint brush function?) Thanks,Zoho API accessing another drive which is not mine
I used my email to register my organization on zoho, I want to access my sheets with zoho api. But it's giving me the files in the organization workdrive instead of my personal workdrive. Since I used my email to register the organization, there are duplicatePick list
I am finding it difficult creating a picklist from the mobile app. Also, I want to format the date display. How do I do it? The app seem to be slow and crashes sometimesMaj Février 2024
Bonjour Depuis la mise à jour proposée, hier, par Zoho sheet, il m’est impossible d’ouvrir mes fichiers d’emploi du temps! L’application se ferme avant l’ouverture du fichier. que faire?Sheets running slow
Utilizing sheets for a very simple budget record, simple column adds nothing with fancy overclocking cpu utilization arithmetic . Yet just entering a number in a cell, prompts me to experience the very frequent "working" notification. if this isn't badSet table dimensions
New user - I created a new sheet, but can't find any way to set the numbers of columns & rows. When I try deleting rows or columns I don't want (select, right click, select "Delete Rows/Columns"), the selected area remains (or is immediately replacedThe value entered violates data validation rules set in cell E6
Hi, I was trying to shift a data from sheet 1 to auto paste into sheet 2 by press from row and colume at = 'e6' from page 1 and press enter then there have an error pop up said: The value entered violates data validation rules set in cell E6. Please advice what is the solution and what is going on?Embed With Formula Bar and Headers Not Visible
Is there a way to embed the sheet on an external page without the formula bar or headers showing? Love the product and it's an awesome way to present users with tools and calculators but for aesthetics, it would be great to remove these for a cleaner look. Thanks!Apply conditional formatting to a row
I would like to apply conditional formatting to a row. This can be really helpful for project based sheets where each row might be associated with a task/to-do. When the task is complete, a cell within the row is Checked/True, or updated to 100% orDisable copy/cut/export for guests
I need to share a large spreadsheet with lots of formulas so that the guest can edit data to see if the model will work for their needs. However, this is rather sensitive data and I do not want them to be able to copy anything from the spreadsheet and paste it into their own spreadsheets. Is there a way to disable the cut/copy option for guests, but still allow them to edit data?Is there a way to disable Create and Copy Sheet in external share?
Is there a way to disable Create and Copy Sheet in external share? VBA would be fine, but I'm not seeing it. For our business, large table-style data entry is a must for our orders. I've been able to push Sheets a long way, but I still need more excel-likeAuto shapes in Zoho sheet.
Does Zoho sheet supports inserting auto shapes (rectangle, circle...). I did not see any option to do so. If its not supported currently, is there any plans on bring in this features. Any timelines ?Do you know any zoho sheet professional, who I can hire?
I am looking for any zoho professionals, who I could hire when I need to deal with my zoho apps. I think, many of us do not have time to learn everything about sheets, flow etc but we are keen to learn as we go with ours needs for solutions. I need toSort data in Pivot Table
Is it possible to sort by a data field. I can gruop and filter, but I culdn't find how to sort the results. Tank You.Can't share, no response
Hello, I emailed sheet, writer, email & WD over 12 hours ago because other than email, nothing is working & I can't work. NO ONE has responded back to me. What is going on???Zoho Sheets Row Height Issue
I am having issue with adjusting the row height. The row height for my Zoho sheets have to be at least 47px, sometime as high as 61px. If I decrease the height i cannot see any contents in that cell. This happens to few columns like A or B while columnCannot select cells
I am using the Android app and don't seem to be able to do the most basic thing: selecting a group of cells. Whether for the purpose of formatting or generating a chart, for some reason I am not able to select the cells I wish to format or chart. WhenText Boxes
Any plans on being able to add text boxes and cell merging in the near future?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!Quicktime movies
Can I upload quicktime movies from my camera and have other people play them from one of these apps. Vince MIntroducing 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 makingHow 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?Next 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