VLOOKUP FUNCTION PROBLEM
Hello, i have a problem with the VLOOKUP function in my sheet http://public.sheet.zoho.com/public/tonimoreno/indicemasacorporal2 in cell D2. This function doesn't work correctly and always returns the last content of the range. Can you help me?How to set a fixed width of column/cells
Is there a way to set a 'fixed' width for cells in zoho sheet? I know how to adjust the size of the colums.... but after I past a large block of text into a cell, it expands the cell size again. (yes, I have turned off word wrap) How can I set a fixed width so the cells don't change size each time I add data to a cell? Thanks.I NEED TO NUMBER TO TEXT NO HERE
=NUMBERTEXT NEEEDI NEED TO NUMBER TO TEXT NO HERE
=NUMBERTEXT NEEEDWhat are the benefits of procurement software in a growing business setup?
I’ve been exploring tools that can help automate purchasing and vendor-related tasks. I keep hearing about the benefits of procurement software, especially for businesses that are scaling. I want to understand how it helps in streamlining operations,Putting Watermark on Zoho Sheet
Can this be done?Stock Quotes/Spreadsheet
It would be nice if we could download security and mutual fund prices from Yahoo Finance (or?) in order to maintain an up to date investment portfolio on Zoho. Any chance?Edit Legend of Chart
I would like to edit the legend of the chart. Every time I enable the legend, I get a very unhelpful (1), and when I try to type to change to what I would desire, nothing happens, which is very frustrating. I've gone through your online tutorials and nowhere can I find a legend settings button. This seems a simple fix, where can edit the legend? Thanks.Sort 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.need a formula to return value as shown (zoho sheet)
Hello folks, what should be the formula in B3, to get the value shown based on input sheet ranges. thanks in advance.Online 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! RSAContent 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 FPage Break
Is there a way to set page breaks in Zoho Sheet. I couldn't find anything about it on the board.Can 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. ThankyoCollaborative 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 availableuse of comma as a decimal separator
Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !VBA/Macro, Transpose
Hi everyone! I am trying to transpose the highlighted or any selected row from "Raw Data" to "View". However, whenever I click the button, it will just copy the A1 cell in Raw Data and not the selected Row. Can someone help?Error in Safari
I have embedded my spreadsheet on my web page its shows fine in google chrome and firefox but it gives and error in safari it reads "cookie is disabled in your browser. please enable the cookie [?] and reload this page" but cookies are enabled in my browser.Users having trouble accessing shared Sheet
Hi, Some of my users are having problems accessing our Sheet. When they use the link sent in the original invitation email, they can get to the shared sheet with no problem. When they log into Zoho without using that link, the sheet doesn't appear in their shared folder. Any suggestions would be appreciated!hide zero values
Excel has a feature where you can show or hide zero values for each worksheet. How do I do that in Sheets?Sum through multiple sheets
Don't believe this command works in Sheets sum(sheet1:sheet6!A4) Would be nice to add. Every time I click on sheet3 it moves to that sheet instead of treating it as a formula inputmissing 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.importXML 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 modifyingcopy 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,Disable 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?Text Boxes
Any plans on being able to add text boxes and cell merging in the near future?Quicktime movies
Can I upload quicktime movies from my camera and have other people play them from one of these apps. Vince MPrint
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 thanksNon-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 formatsheet - copy and paste from excel
can't copy data from excel (Vista, Office 2007)or between zoho sheets joseunit11amoving a chart
Hi, I have a bar graph in one of my sheets. It is working fine and changing when I make any edits to the underlying data. I have a problem moving the chart to a different place on the sheet. I need to enter information in the cells which are directly beneath the graph. I tried to select the chart and it just does not happen. I am using the latest 'stable' version of Chrome and I did not have this problem of selecting an existing chart. Please help. Thanks, SeshadriCompare versions
There does not appear to be a way to compare versions of a spreadsheet to see what changes were made. Is this a feature being considered or is it already there and I just missed it?#CIRCULARREF!
How come im encountering #circularref! error. i double checked the formula but they are correct. It seems that the synchonization to the server has an error. Thank youzoho sheet - How do I create a list of values to choose from in zoho sheet
I want users to choose only a value on a list of items (as you can do in Excel). Can I do this in zoho sheet?Borders
Are border patterns supported?Sheet Superscrpt/Subscript
Why is there no superscript and subscript available for Sheet. It is available for Writer; however, this option is quite necessary when work with mathematics--particularly statistics.Problems Accessing Shared Sheet
I have a workbook containing around 30 sheets which are each shared with a different user. On a number of occasions, these users are having a problem connecting to their sheet. The only way we seem to be able to resolve this is to drop the sharing and reinstate. HAs anyone else experienced this issue?page setup
hallo everyone: is there a way to have a print preview on spread sheet and change/set page margins etc.? ...and how does one ge rid of page info on the print?Offline Work
I see how to work offline with Zoho writer how do I do the same with Zoho Sheet? mark18Next 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
Series Label in the Legend
My legend reads 'Series 1' and 'Series 2'. From everything I read online, Zoho is supposed to change the data names if it's formatted correctly. I have the proper labels on the top of the columns and the right range selected. I assume it's something inBUG: 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
Top Contributors
Murugalakshmi S
Vinoth Kumar K
Crystal
Paul Queen Soft
Alfredo Loyola | Alrisha Software