Expand / Collapse Rows in Spreadsheet
I'd like to be able to collapse rows of categorized data so that I can more easily see all of the categories, with the ability to expand them to see individual rows. When I search, I find this demo, but with no explanation of how to make it https://docs.zoho.com/sheet/published.do?rid=mr778aae12b194b91414e9c4990cfc03e0bd5 For example, this list Item Style Qty Price Total Apple Green 4 0.49 1.96 Apple Red 9 0.35 3.15 Apple Yellow 7 0.49 3.43 Grape Red 100 0.05 5.00 Grape Green 150 0.04 6.00 Totalreplace existing
When I would upload a file to Excel online it always ask me if I want to replace the existing file. I don't see this feature in Zoho and was wondering if there is a setting for this. BruceLink two Zoho Sheets
Hi I apologise in advance if this has already been asked, however i couldn't find it anywhere. I have data in one Zoho sheet and i was wondering how i get that data into another zoho sheet without losing the data in the original sheet. In excel i would have linked by '='Sheet Name and cell'. If someone could let me know how i do similar in Zoho it would be much appreciated. Thanks in advance. RPrint Preview and Page Breaks in Sheet
Have Page Breaks and Print Preview been developed for Sheet?Error In Cell Function
Hi Guys, I need to store Filename inside cell, I used "=CELL(FILENAME; A1)" formula, but I'm getting error "#NAME!" . I got that formula in the Zoho Sheet Documentation. https://sheet.zoho.com/sheet/functions Please help to resolve this issue. Thanks in advance. Regards, TermconPrint with Gridlines
Is there a way to print the spreadsheet with grid lines automatically instead of having to manually add a border for each cell that is printed?Send workbook draft attachment through email
Hi I love your platform, i saw a code to send the worksheet as an attachment through email like this ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array("xxx@yyy.com","zzz@yyy.com") 'Can send mail to multiple recepients .Subject = "Task completed" .Message = "Mail content" & Target.Row 'Sending cell value in mail '.AttachWorkbook = False ' By default the file will be attached in the mail. If it is not needed then send ' .AttachWorkbookSending email with ThisWorkbook.Route problem
Hi i love your platform, i have this code: Public Sub email() ThisWorkbook.save ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array("gfdsgdsf@dsf.com") .Subject = "l" .Message = "" .AttachWorkbook = True End With ThisWorkbook.Route End Sub The problem is, when i am loggen in it works, but when i am logged out it gives an "unknown error" on the ThisWorkbook.Route line and the email isnt sent can this be fixed? Thank you very much.Indian Mutual fund tracking
Hi Friends, Is there a way we can track Mutual Fund investments in ZOHO sheets automatically?"unknown error" on vba script
Any idea why I get "unknown error" on line 32? Option Explicit Sub updateCSV() Dim wb As Workbook Dim ws As Worksheet Dim newWS As Worksheet Dim i As Long Dim z As Long Dim lr As Long Dim desc As Variant, created As Variant, amt As Variant, fee As Variant 'Set Objects Set wb = ActiveWorkbook Set ws = wb.ActiveSheet Set newWS = Sheets.Add 'Vars -> Assumes headers are in row 1 desc = Application.Match("Customer Description", ws.Rows(1), 0) created = Application.Match("Created (UTC)", ws.Rows(1), 0)Insert Current Date and Time
Here is a quick tip on inserting the current date and/or current time inside a cell. Select a cell where you want to insert the current date/time. Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. To insert both current date and time inside a cell, press Ctrl+; followed by a space and then press Ctrl+Shift+; Note that this is a static date/time and the value will not change as time passes by. However, if you want to have the current date or time to be automaticallyImportrang
Any small business that runs its business with spreadsheets will always use importrange to consolidate data. Why Zoho is not included this at all?CONECT 2 SPREADSHEETS IN ZOHO SHEETS
Hi I have a document called "Insurance", and another called "database". What I want is that the information in some of the colums of the document "database" transfer the information to the document called "insurance" in a way that when I write something in "database" automatically the document "insurance" get updated. How can I do this?Tip #4: Five important statistical functions, and when to use them.
=AVERAGE (number1; number2; ... number30) The sample mean is probably the easiest piece of information one can extract from a data set. To calculate sample mean in Zoho Sheet, all you have to do is key-in =AVERAGE and select the range of cells you'd like to find the statistical mean for. Zoho Sheet supports a few handy variations of the average function as well. =TRIMMEAN (number_list, fraction) Say, for instance, you want the sample mean. However, you want to exclude the maximum and minimum valuesImportrange Essential But not in Zoho
Any small business that runs its business with spreadsheets will always use importrange to consolidate data. Why has Zoho in the 4 years since this request was posted not included this at all? Some of us only need simple spreadsheets to run our businesses. If you are really for businesses, then this is a functionality you would put on your TOP PRIORITY LIST! Being a competitor to Google simply means that you have to work on this. This is one of the reasons why businesses use Google Platform - toImport One Spreadsheet Into Another
Is it possible to import one or more cells from one spreadsheet into another in zoho sheets (like "=IMPORTRANGE" in google sheet)?Import Range
Hello Please I need help. I don't know how to import a range in the zoho sheet. Can somebody help me with the formula. In google it is this {=importrange("tMRE8ynZbZJ-1jrl5fQ6rLA&hl", "price!Q9:Q450")}spreadsheet
On my previous MS spreadsheet I was able to split the screen into 2 parts by dragging a small line located on the top right of the spreadsheet down and creating a fixed data section on top to be used for my reference. My working lines were added below the fixed lines . I am unable to find this useful tool on Zoho Helmut DSheets API - Download workbook
I am calling the Zoho Sheets API from a CRM function. I want to download the workbook as a CSV and attach it to the record. If I use format xlsx, the response is the file. It downloads and attaches perfectly. If I use format csv. the response is a text stream of the CSV itself. As a result, it doesn't download or attach. How can I download the CSV file itself? Kind regards MattRandbetween
Is there a way to assign a random number with the Randbetween formaula but have it lock so it does not change if it is resorted?How to import web data
heyyy on zoho sheets i would like to know how to import data from web a exaple the price from Gold to dollars etc..Link external data does not work, while import from downloaded csv does work.
Trying to link to: https://analytics.usa.gov/data/live/os.csv Gives lots of strange chars. But downloading the os.csv and then importing works fine. Can this be fixed? Thanks. J.Zoho Sheet mobile apps forum—closer community, better experience
Hello everyone! While you may already know we post tips, make product updates, and encourage user interaction in our Zoho Sheet community, we now have an exclusive forum for our Sheet mobile app users too. If you use Zoho Sheet on your smartphone or tablet, follow our Mobile Apps forum to see all the app-related announcements, get quick answers for all your questions, post ideas, and learn a few tricks to create powerful spreadsheetszoho sheet and offline
Hello Do I understand correctly, that zoho sheet does not provide the offline function, write provides oubMacro: 'Application defined error' while using Match.
Using Match, Index/Match gives the following error: Encountered error at line mn : Application defined error I am not sure what is wrong. I have tried many times on different sheets. Also, enclosed a test spreadsheet with code and a screenshot of the error message. Any help to solve this is highly appreciated. Thanks.How do I tell the number of people accessing my published sheet?
Hi: Is there a way to tell the number of people accessing the sheet I have published? Thanks,Published HTML version of sheet is not interactive
Hello, I published one sheet into my website which includes some drop down menus, formulas etc which I want the visitor to make their own calculation. But after adding html code into the website I saw that excel is getting imported in a static view so you can't choose anything from drop down menu. Am I making a mistake?Macro to copy data from 3 sheets into a fourth sheet
Hello, I am trying to copy data from 3 separate sheets (Ranges A to E) into a fourth sheet (Final).May I ask the VBA code for it please. So far to copy values from 1 sheet (Electrical) into a separate sheet (Final). Sor far I have: Sub copy_paste() Dim SourceRange,DestinationRange as Range Set SourceRange1=Range("Electrical!A:E") Set DestinationRange=Range("Final!A:E") SourceRange.copy DestinationRange.select ActiveSheet.paste End SubHow to insert Greek symbols like mu, sigma in Zoho sheets?
I need to insert Greek mathematical symbols like mu, sigma in the Zoho sheets. Is there any way to do this. If so how to do that? Maybe like this in excel.Header/Footer
Hello, Is there a way to create a header in an individual sheet so when I print that one sheet it appears at the top? JaclynnDuration (end time-start time)
In col A I have start time. Col B is end time. In col D I need duration which in Google sheets it is as easy as =B1-A1, but that doesn't work here. How do I go about it? All the best, ThAdd Row Creation Date
Hi guys, I'm looking to automatically add a 'date created' field to rows on a sheet which are being populated from a Flow. Whats the easiest way to accomplish this? Thanks in advance :)Conditional Formatting not Working on Sheets
Hello, I had some Conditional formatting rules set that have been working for the past 2 weeks. The rule is very simple that if a field contains a Date that is Today, the field fill color of the cell changes to Red and the text becomes Bold and underlined. Now this has suddenly stopped working since the start of this week. Can you please check the issue? Best Regards,Ahmed FoudaColumn Filters are not Filtering data accurately
This afternoon ( 28th March 2020 ) column filtering has been unreliable. When I select a filter it will include rows which do not match the filter criteria. This raises two issues. The first is that the extra rows get in the way of my work. The second is that the filters may be excluding rows which do match the criteria and I will be missing them.Published Sheets forces HTML view on mobile
Hello, I have a problem with a published Zoho Sheet file. I have the first collumn of my Sheet Freezed (so it follows me when i scroll). Problem 1 I've noticed that when i publish and use the HTML View the freezed collumn doesn't work anymore, why is that happening? Problem 2 I need to have that collumn freezed on mobile, and i tought i could use the normal view on mobile, but actually when i open the published (Normal view) on mobile it forces to open it on HTML... So, once again, i lose the freezedSince TODAY, impossible to FILTER a table containing PROTECTED/LOCKED cells
Hello, Since today, it is no more possible to filter a table containing protected cells. This shows an error indicating that I can't modify or delete protected cells BUT i am only applying a FILTER on the table. Please can you help us to solve the problem ? Thank you, Best regards, Gauthier COUNETQuick and controlled data entry with new picklists in Zoho Sheet
Picklists are custom drop down lists with predefined values and formats that can be applied on the desired cell range. These customized drop-downs help you control the data entered into your spreadsheet and speeds up the process too! Effortless data entry Entering data manually is tedious and may lead to typos or misplaced values in your spreadsheet. Luckily, Zoho Sheet offers a solution to this problem with picklists. Once you create a picklist on a range, only the values in that specific listDropdown menu blocking Sheets
HELP! I cannot work on my sheets because this drop-down menu that is there on load for all of my sheets is blocking me. Thank you!!Problem loading zoho sheet on Chrome
this is the error message - {"dt":"BANNER","a":199,"DU":true,"mt":"ERROR","mk":"Error.Internal.Server"}Adding phase change lines
Hello, I am need to add phase change lines to my charts that are built into the sheet instead of drawing a vertical line that moves when the chart is resized. Thanks for your knowledge on this topic. BobNext Page
Access your files securely from anywhere
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
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 Developer Community
Zoho DataPrep Resources
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
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