Resizing a column does not complete
A basic spreadsheet feature - resizing a column - does not work well in Zoho. Whenever I resize a column in Zoho Sheet, the UI allows me to drag the bar out, but when I release the cells in the respective column do not resize. When I go to move the bar again, I have to go back to the original location. The only way to effect a change is to move the bar, save the sheet, close the sheet, then re-open. Sadly I won't be able to use Zoho much longer if this bug persists. I've attached a screenshot of
Assigning macros to buttons
My button ASSIGN to assign a macro to a button suddenly stopped working! How can I fix this?
user information Look up display
Hi. I am trying to use the script for the look up from the excel file that i have uploaded to zoho as an database and display the additional details to the user upon the submission of user name. Is anyone have an idea how to create it. Thanks
How can I view and edit groups in sheet?
I have created a number of groups to colaborate on a spread sheet. How can I view and edits the people in a group? Tom
Private Spreadsheets
When I import a spreadsheet, is it automatically private or do I have to change the settings to stop the spreadsheet from being viewed by anyone who does we do not give permission? I don't want the sheet to be accessible to the web and to crawlers. If I have to change settings, where and how do I do this? Thanks
I embedded my sheet into a website. I only want people to view it not be able to edit it. Is this possible?
I embedded my sheet into a website. I only want people to view it not be able to edit it. Is this possible?
Locking certain cells
Is there any way to lock some cells in a shared spreadsheet but allow users to edit others?
Excel Problem
I have one Excel problems, First is I have in A1 one date and now i Want to make Macro when i press to the button to find the next same (date) cell and from that cell to hide everything until Column C. Thank you very much
Context menu in Firefox 12 on Mac OSX 10.7.3
I tried using the context menu (right click menu) in Firefox 12 and only get Fx's standard context menu. When I logged into Safari and tried it, it worked like a charm. Anyone have any ideas about what the problem is?
How can I use the Pick from list functionality?
I uploaded an MS Excel sheet which contained several drop-down menus. Unfortunately, the drop-down menus do not work in Zoho. I noticed that there is a feature called "pick from list". HOwever I don't understand how to use it. Can anyone help please? :?:
ROWS
Can I hide and unhide rows and how do I do this please. Does anybody know. Many thanks! Hans
How do I hide cell content in Zoho spreasheet?
Is it possible to hide the contents of a cell. Functions or formula while keeping rows and/or columns visible where these cells are? If possible could you please explain hot to do it and how to toggle between hiding and showing it back. Thank you Note: Which is the latest version of free Zoho Office Suite available for free download Thank you.
customize specific column widths of embedded sheet?
We are presently using Zoho sheet to display some data on our website: http://www.mftransparency.org/endorsements/ As you can see (in its present form) the "Date" column has been pushed off the screen and can only be seen by using the scroll bar at the bottom of the table. If we could simply set the size of the Category, Country, and Endorsement columns to be narrower, then all of the information could be displayed without any need for the horizontal scroll bar. Is there some way to set specific
Goal Seek using VBA
I was wondering if it was possible to run Goal Seek through VBA. I have tried writing it as I do in Excel and it doesn't seem to work. If it is not supported yet, are there plans to support it? Thank you.
Query Regarding Features in Zoho Spreed sheet
Hi Senior , I would like to know about convert days into months and days Formula(DatedIF Used in MS EXCEL ) in zoho spreed sheet & Features like Conditional Formatting we do in MS Excel(can manage new rule or use a formula to format cell ).Expecting a positive Reply . Thanks Ronak
Newbie
I have just registered for a free account so that I can use ZOHO SHEET. I have assumed that this service is free. Am I correct? I am a bit lost with the application. Where are the help sheets? Can we save spreadsheets at ZOHO, or must they be saved to our pc's? What other free apllication are available. Is SHEET similar to MS EXCEL? Thanks for now Best wishes. A
sheet
Can use ipod with zoho sheet?
problem with IE9 - i can only see grid
Hi, I'm having some issues wid sheet that include data on high numbered rows (i.e. row 600) on Internet Explorer 9. I create a new document just fine, with the mentioned data, and when i try to open it again, it opens fine, but i can only see grid on my iframe in which zoho sheet is embedded! There is no way i can get to the menus or the top of the document (see attached screenshot) In firefox and chrome works just fine Thanks for your help Regards
Can I create folders in the left hand side 'My Sheets'?
Dear zSheet Team, Can I create folders in the left hand side 'My Sheets'? That way organizing a lot of spreadsheets would be relatively easier for me. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Named Expressions in Zoho Sheet
We recently added support for 'Named Expressions' in Zoho Sheet . Named Expressions are similar to Named Ranges except that instead of referring to a static cell, they refer to a formula. It can be useful in the following ways: It can simplify your formulas. If you have an oft-repeated expression or a nested formula as part of formulas in many of your cells, then you can give a name to the expression or formula and then use that named expression as part of your formulas. This simplifies your formulas
Clever permission
If there is a Zoho Sheet document made public it now has the option to edit it. That's good! After clicking, this message appears: Note: any changes that you make will not be saved to the original document. However, you can use the "save to my account" option to save the changes to your zoho account. Wouldn't it be useful if one could edit THIS document directly if I he/she has the permission (via invitation or workspace) to edit it?
Pivot Table
I am completely stuck. I don't understand how to create/interpret Pivot tables Is there a help sheet anywhere? Thanks
Not displaying shared users
For the most part all of my users that I have shared the sheet with are displayed when I 'Edit Shared Details', HOWEVER one of my colleagues that I recently shared with is not displayed. Thus, I cannot edit their permissions or which sheets they have access to (for some reason they have access to everything which is a big problem). Please help as soon as possible.
INDIRECT function doesn't work with range reference
This formula returns correct results: =DSUM(Bank.A4:H249;"amt";$K$6:$L$7) This formula =DSUM(INDIRECT(L1);"amt";$K$6:$L$7) with Bank.A4:H249 in Cell L1 returns #VALUE!
Sorting an Embedded Sheet
Hello, I am using Zoho to manage some rosters on my website. You can see them here What I cannot seem to figure out, however, is how to make that sortable by column. I read that this was possible with Zoho and caused me to move everything over from Google. Any help? Thanks. ~Joe
I cant share my sheet on a link: error has occurred
heres a link of the error http://prntscr.com/9104g
is it a way to join sheets into one spreadsheet?
I have separate sheets for each quater and want to join them as one spreadsheet
Zoho Sheet as background calculator
I would like to use Zoho sheet as a "background calculator", this means I would like to set the inputs in a form on a external website, then automatically load the inputs in zoho sheet, retrieve the results and display them on the external website. Is is possible to do it? In such case, is the code of the zoho sheet accessible from external users or is it protected from copy? Thanks for advice, Aymeric
Copying a Zoho Sheet to save on other Sheet or word document
Dear Sir/Madam, Is it possible to copy a Zoho sheet to another EXCEL sheet or word document? If yes, how? I tried copy & paste. It does not work? Thanking you. Best regards, RAKESH
How do you link cells between sheets?
I want to start off by saying these applications are really cool. I would like to start using the spreadsheet. I would like to link a cell from one sheet to another. I would also like to name cell ranges. Are these features available in Zoho sheets? If so, they are not intuitive at all. I also find your Zoho forum search/Blog search to be a poor substitute for help. Are there plans to incorporate some better help in these applications? Thanks. rlieving
How to add color to tabs?
Any way tabs can be colorful?
Need macro - to open multiple hyperlinks
I'm way over my head with this but I'm looking for a macro that would open in new tabs a list of 8 links stored in contiguous cells Something similar to : Public Sub OpenURLList() Dim rowcount As Integer Dim urlToOpen As String Set ff= CreateObject("FireFox.Application") 'Show browser ff.Visible = True rowcount = 1 Do While Sheets("Sheet1").Range("A" & rowcount) <> "" urlToOpen = Sheets("Sheet1").Range("A" & rowcount).Value 'Open the links in the same browser ff.Navigate2 urlToOpen 'Perform your
maximum formula length?
I have succesfully uploaded a very complex XL spreadsheet. Multiple tabs, lots of lookups, etc. However all of my fields have the error "#VALUE". I assume that the formulass are too long for Zoho sheet to evaluate. Is there a spec of how many characters can be in a given formula, or how many nested formulas, tc?
dynamic integration
I'm developing a simple dynamic e-learning website for my school and was wondering if it is possible to integrate Zoho sheet into the website so that the teachers can upload the student grades on our website in the form of a .xsl file and have it dynamically integrated into their class page.
Lost work
Jeez. After an hour's work, I saved. But the work is gone.
VLOOKUP doesn't work properly again
Dear Zoho Sheet Team, I've reported a problem with VLOOUP five days ago. Then commented in the ticket twice. Nodoby's answered. Could you please take a look at the request number 1060024? Thank you. Such strange problems with cells format happens regularly. And that's very big problem. And nobody cares. Thank you.
Zoho sheets not functioning in IE
When I share the sheet. We get " Error Occurred " on the IE. It does work on Google chrom need it urgent
Sync sheets with desktop
Hello! There are various ways where you can sync your docs ( including sheets ) in Google Docs with desktop. What about Zoho? How to have an offline version of docs/sheets in desktop ( and better to sync with docs/sheets in Zoho ) ? How about Android facilities of Zoho sheets and docs?
Online Web Calculator
I would like to create a calculator in as spreadsheet and then publish it in my website. Can Zoho spreadsheet able to do that? Or, do Zoho spreadsheet have the hide and protect cell features? By the way, keep up the good work. Luv Zoho a lot!
Effacer
comment effacer le contenu de toutes les cellules d'un tableau ?
Next Page