Zoho Sheet - Desktop App or Offline
Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.spreadsheet printing options
I see the way to insert page breaks in a document but is there a way to insert page breaks in a spreadsheet to control the prints of a long spreadsheet? And, is a print preview option? And is there a way to select the area of a spread sheet to print so that part of a spread sheet may be printed?Zoho Sheet for Desktop
Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?protect cells?
when I make a spread sheet how do I protect cell that should not be changed (Calculated cells) ?Drop down menu in Zoho Sheets
Hi, I was wondering if (like in Microsoft Office Excel) you can create drop down menus' in Zoho sheets. If so how do I do it? CheersProblem with wrapping text in sheet
when I wrap text in the spreadsheet, the line height does not adjust to view the entire entry. I have to manually adjust each line for each entry. Should it not automatically adjust as in google docs or MS excel?How do I 'hide' a column or row in Zoho Sheet?
I have a large spreadsheet in which I would like to make certain columns (and sometimes rows) invisible. For data not frequently needed, this is a good way to increase the usability of a given sheet, buy reducing the amount of data displayed at one time. The feature must be in there somewhere, but I can't seem to find it. Can someone point me in the right direction? ThanksZoho Sheet - Split cell diagonally fill half color
is it possible to split a cell diagonally, fill different text in each half and ideally color them differently as well?multi-user views change when one person filters - how to avoid this?
I have 6-7 people that will be looking at shared sheet - but when one of them uses a filter, then everyone's view changes to that now filtered view. I suspect no way of avoiding this - but hope someone may have cheeky way to address this? Perhaps having a sheet per user, but then how to ensure that data is consolidated amongst all sheets? Any other ideas? Thanks.Is Zoho Sheet available for Mac OS ?
Is Zoho Sheet available for Mac OS ?How 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!How to get NSE/BSE Stock Prices in Zoho sheets?
I've been looking for a function that provides me with the NSE/BSE listed stocks price in Zoho Sheets like GOOGLEFINANCE in Google sheets, but I found none. Please help if there is any way to het stock prices?[New Version of Spreadsheets] How to make text overflow into adjacent cells?
I recently changed to new version of spreadsheets, the team has done a excellent job! Now its much more responsive and faster while making changes . But I am having a big issue, all the cells are by default formatted to have no text overflow to adjacent empty cells . This has made my old spreadsheets look very different and not as it was intended at the time of creation. Is there any way to permit text overflow?Zoho Sheets working offline
Hi, I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this. Does someone have any ideas or steps I might have missed? Also does Zoho Sheets have the "Format as Tables" function as is currentlyZoho sheet desktop version
Hi Zoho team Where can I access desktop version of zoho sheets? It is important as web version is slow and requires one to be online all the time to do even basic work. If it is available, please guide me to the same.How do I get my cell height to auto adjust?
I'm evaluating Zoho Sheet as a replacement for Google Spreadsheet. Using latest version of Safari, and experiencing the same issues in Chrome. A few bugs/things I can't figure out: Auto adjusting cell height when importing from Google Docs or creating a new document Turning off the auto date formatting for X.Y.Z where they are all integers.. (This is extremely important, as our requirements are written as outlines.. "X.Y.Z" corresponds to a requirement ID.. which is then turning into a date) TheHow can Filter Row Data (Set on Row Topic)
How can i Filter Rows over Row Head Line Description? Auto-Filter: We support auto-filters when imported as CSV files. Again you would need to select the Tabular Data option while importing. Filters for normal spreadsheets will be supported later. When is later?Formatting
Hi, I know there must be some way of doing this, but we are 4 guys, 3 of which have IT-jobs, and none of us can figure out how to format numbers/decimals. (or any other type, but numbers give us the most problems). When we get to a new row, if we type 5,4 it format is a datetime, if we type 5.4 it thinks it is text, and our auto sum simply won't work, as it changes for every new row... How do we set the data type for a column to number, with 2 decimals ?? And how to we format a column to a shortzoho sheet - conditional formatting - date
Hello. I just started using ZOHO, and it seems very useful. As I did in Excel and in Google Docs, I want to color cell(s) if the value of date is after today using conditional formatting. but when I set 'after' I can only insert a specific date in the following field, not a saved word (as today, tomorrow, next week, etc.) thanks a lot, Lior.Docs Sheets very slow?
Are Sheets always this slow? We have been testing ZOHO Sheets as a replacement to Google Docs, but we keep hitting patches of the day where it grinds to a halt. It is either really slow or it will load only a few lines from a sheet and just hang and we have to log out and back in again to get it working,.... We are experiencing it on several computers on various OS and Browsers. We are in Spain, but on 100Mbps Fibre so I don't think it is an issue on our end. Any advice or solutions? Thanks AlexIs there support for filters in Sheet?
Do filters work in Sheet? I can't seem to find them, many thanksZoho 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. ThanksHow can I hyperlink from one Zoho Sheet to another?
Dear zSheet Team, I would like to hyperlink from one Zoho Sheet to another? Both of them are private ones. For my internal reference I need to have them linked. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/Is 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 itDate Auto-Formating
Hi, i'm new to zoho sheet, ive noticed that when i paste something like 18/06 - 10:00 it auto-formats accordingly to the option selected in date/hour tool. But i'd like not to have any formatting, i want to keep it 18/06 - 10:00 but sheet automatically changes it once pasted. Is there anyway to disable this feature ? If not, can you add a date and time format that is "18/06 - 10:00" ?How do I speed up Zoho in China?
Speed is such a problem that we will have to leave your great product because of it. The speed isn't bad in the USA! We have huge issues in China. I tried using a product to get around the china censors which only helped a little bit. What else can I try? thanks KenHow can I draw histogram with zoho spreadsheet?
I want to draw a histogram for a set of data. How to use zoho to make it come true? The chart existing can not meet this requirement.Conversion 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 tohow to lock the cell in the zoho sheet? Please help!
how to lock the cell in the zoho sheet? Please help!Sharing excel sheet in real-time
I have a large modeling excel sheet where a group of people will need to be working on it simultaneously. Can Zoho allows real-time simulatenous collaboration? ie I could see in real-time the changes of the other user who are accessing the same file as I am. Thank you.CRM Documents
Hello Is there a way to change the left side navigation bar in ZOHO CR Documents? on our page https://crm.zoho.com/crm/ShowDetails.do?module=Documents I have our documents separated in their respective folders But when a users login the document view is confusing for them because they sell all documents by default The top 2 selections do not show the folders. How can I make the defaulft documents view to be the "Document Library" Please see screen shotShare Sheet / Invite non-Zoho Member to join
Hi Zoho - great product(s)! I'm new to Zoho myself and I'm trying to organise some testers to collaborate on a project. I've set up my spreadsheet and now I want to share it with them, but Zoho is telling me I can't because their email addresses are not Zoho accounts. How I'd hoped it woud work would that Zoho would detect that an take that opportunity to grow it's userbase Facebook style by sending them an email: Mr X has created a spreadsheet in Zoho and invites you to collaborate. Please clickExcel with protected cells
Hello, I do not see the option to protect cells in the spreadsheet is this possible? When importing sheets protected cells, these go unprotected, should I do so that when importing an excel book not unprotect the protected cells?Spreadsheet Offline
I read about writer offline but I couldn't find anything about spreadsheet. Right now I'm using google account to have such function. Is there any possible to see something soon ?Filtering without other users seeing / view only mode?
I would like to find a setting that allows me to filter the spreadsheet without other collaborators seeing what I have filtered. I do not need to be able to change anything while in that view, just be able to see various filters without messing up their filters. Is there a way to do this?Sheet and Firefox - Problems loading
Help! Up until recently I was able to launch the application sheet on a seperate tab whist in ZOHO Business, it now says problem loading page - timed out. Please can you help me find out why? I can not access it from ZOhO Business. I have accessed it by going to http://a1.sheet.zoho.com/home.do# as you have recommended to others with problems. Thank you for your help, L.How to create a drop down menu in Zoho Sheets
I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text --> Contains. But that is not working, is there any other way to do it. Thanks in Advance.Always Match Destination Formatting while Pasting
How do I always match destination formatting when pasting in Zoho sheets?Page header and foot note
Hi there, Just started using Zoho sheet after many years of Excel. I cannot find the function of adding a header or foot not in a sheet. I cannot find the Page set up funtion either, e.g. adjust sheet margins etc. Can someone help?? Best regards KODHow do I avoid the rounding of large numbers
I'm currently importing csv values from my Creator app into Sheet which include the Record ID field. This field contains a very large number and when imported Zoho Sheet seems to round off the last 3 digits. Is there a way to get the entire number to import properly?Next Page
New to Zoho Recruit?
Zoho Campaigns Resources
Announcements
Slicers 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,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 canIntroducing 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 methodTip #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 sampleFeature 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
BUG: Can't copy-paste data outside Sheet
Currently I can't paste data copied from inside any of my Zoho Sheet files to any other app. Copy-paste works inside the sheet It does NOT work between two different sheets These sheets are built from automation templates Everything works fine if I create
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
Slicers 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,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 methodTip #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 irregularFeature 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 drawTip #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