insert date
I can not insert DATES in any sheet... Any sugestion?
Applying Pre-Defined, Zoho Parameter Driven Formatting to Zoho Sheet View BEFORE generating
I currently have a specifically formatted excel spreadsheet that we use to track our prospects and typically need to print out a hard copy on a bi-weekly basis to present to and utilize during staff meetings. It currently is not using any sophisticated formulas, xrefs, calculations, etc, however font types, sizes, cell text alignment, predefined column widths, text wrapping, etc, cell background colors are all parameters that have been established. Is there a way to define and set all these parameters
importing Google documents (spreadsheet) in Zoho
Hi, Is there a way to import documents (spreadsheets) directly from Google to Zoho with the URL ? The only way I know is to export from Google and import to Zoho. Thank you for you reply Pascal
Add-ins
Hello, I do not see tools > addins like in my offline spreadsheet. Is there a way to add in a function that calls data from external sites? My spreadsheet are not working becuase they can't retrieve information from sites like yahoo.com
Exporting spreadsheet makes some rows bigger
I have a spreadsheet in Zoho which looks fine, but when I export it to a .ods file it makes the height of every 20th row bigger. I thought it might be due to wrapping, but nothing in the cells would account for this. I have also tested exporting it as a .xls file and I get the same results. If I export as .csv I can only get one sheet at a time, but the height is the correct size. Is this a known issue? I tried to attach the file as a .ods but it won't let me here. So, here it is as a .xls file.
Currency
Hello, Every time I make a changement in my zoho sheet the currency sign changes from Euro to Dollar, automaticly. How can I turn this off?
excel spreadsheets
Is there any way to get an individual cell to appear exactly as typed ? It seems to condense and leave spaces out when I want to seperate letters and words for easier viewing.
Decimals please help
I have not been able to get that to work most likely because I have a function to combine with it.. I am taking cell P1 dividing it by cell D1 and then adding cell S1 to it to come up with a number in cell B1 that I want to reduce to just 1 or 2 decimals. Right now I am using =Sum(P1/D1+S1) How would I put that so that it displays a number with only 2 decimals?
Zoho Sheet Lead Id Column Suppression
I am quite new to Zoho CRM and I have been testing the Zoho Sheet View specifically when creating a spreadsheet for the purpose of presenting at weekly meetings and I was wondering if there is a way to suppress by default the first Lead Id column so it does not show up on the spreadsheet whenever a sheet is generated. I am specifically working in the Prospects section. Any help would be greatly appreciated.
Updating Spreadsheets
I have a spreadsheet I want to update, and I don't see how to do this. So, I am simply deleting the current one and replacing it with the new one. In Google docs, I could do this rather easily, but I don't see where the option is on Zoho spreadsheets. I am assuming it's there, I just can't find it. Any help would be appreciated.
Viewing (not editing) on iPhone
I would like to view a spreadsheet on iphone but i can only see some of the rows. Being able to edit would be magnificent!
zoho administrator rights
hello, i'm using zoho sheet for my work. I made a staff roster in a sheet for my employees. The roster changes every week. All the employees ar logging in with the same username en password, so do i. Everyone can make changes in the roster. Is there a possibility that just one person can get admin rights , so that he is the only one that can make changes. The others can only view the roster, but can not make changes. Regards Jack
Cell Protection
Is cell protection possible ?
How long to upload
How long should it take to upload a 6 mb file into Zoho? Is it even capable of handling that? There's about 20 worksheets in the file I'm trying to upload. So far it's taking 1 1/4 hrs and isn't done yet.
Spreadsheet
The Spreadsheet will not let me delete old files or publish a range to the net. I have tried importing a new cop and then publishing bt that doesn't work either. It does everything except give me the html code to embed. Please help ! Zeitguy.
deleting spreadsheets
Nothing happens when I try to delete a spreadsheet, I need to delete this ASAP. What is the problem! I try to move it to the trash and nothing happens, it is as though it does not even recognize I'm selecting and deleting. wtf?
Error 500 - New Sheet
Good Afternoon Went to Documents on the sidebar. Clicked to create a new sheet. Typed in a name and clicked save, and got an Error 500. Not sure why, but it won't let me save ANY sheet, even blank. Any help would be appreciated Chris
Printing
Would be nice to set the print area, so we don't have to do a print preview and select one page. fergetfel1
folderes
any possibility to create folders to organize the files in Zoho Sheet?
BUG: Embedding Zoho Sheets in an external blog
Dear Sirs, Embedding sheets in a blog produces a bug. I have embedded two Zoho Sheets documents in my blog at blog.HireMrSpreadsheet.com. When this page is opened, the page scrolls down to the Sheets component. This should not happen. Am I doing something wrong? Please advise on a better way to embed a Sheets component in a blog, so this issue is not encountered. Respectfully, Bernard
problem with spreadsheet
Hello, I have a spreadsheet that is not working properly it is a sheet for trigonometry calculations that took almost two years working properly and has now also stopped working when performing public access, but works properly after entering my user login. http://public.sheet.zoho.com/public/tonimoreno/triangulos-1 please help me thanks
How to insert image in Spreadsheet?
Thank you sooo much for Zoho... One question, How Do I insert an image in Spreasheet?
MY SPREADSHEET DISAPPEARED
All I did was refresh it and now it is gone.....Has anyone had this problem? Can it be restored through ZOHO? There are a lot of members in my group that depend on the spreadsheet and now it is gone.
Workbook Mysteriously Changes Content
I have four workbooks (e.g. A, B, C, D). Everything has been fine up until now. Today I tried to open "A" and it contained only the worksheets associated with workbook "B". The original worksheets for "A" are GONE! Workbook "B" contains "B" content and "C" and "D" also contain only their normal content. I tried to use the version feature and all the versions are from yesterday. I viewed the first two at the top and they are the same WRONG CONTENT. I then went to the oldest version from yesterday
Calculating time doesn't work anymore
Hi, I'm using the sheet 2010_Arbeitszeit for calculating my working hours. Since a few days all calculations are failing and the most formattings are deleted. 1.: In cols B, C, and D the format was german time format for 24 hours, e.g. "16:45". Now it is re-reformatted as "4:45:00 PM" 2.: Col D should be "00:30" (30 minutes break), but now it's "12:30:00 PM" 3.: Col E is the same as Col D, but as decimals (=24*D15), which doesn't work anymore I've shared the sheet with support@zoho.com, so please
positive numbers turned into negative
I use column J to show my current balance and when I reached row 95 it showed the correct number but there was a minus sign in front of it. Even when I erase the formula and put the number in a minus sign appears from J95 down
セル右クリックでWeb検索を
GoogleDocsにはありました。 顧客名簿などで会社検索をかける際にとってもスムーズでした。 ぜひ実現お願いします★
Support for large spreadsheets up to a million cells
Zoho Sheet now supports large spreadsheets containing up to 1 million cells. Each worksheet can hold data up to 65,536 rows and 256 columns, subject to a maximum of 1 million cells per workbook. You can import spreadsheet files up to 10 MB in size. We have tweaked our interface and improved the performance to support such large spreadsheets. We will be improving the performance even more during the next couple of months. Here is our announcement page which contains some large spreadsheets, which
Background, etc.
I can't find any way to change the background color/image, or remove the grid lines, headers and scroll bars. Can any/all of this be done?
Losing Formatting
Hi - I've recently been losing my Sheet formatting and even when I try to change things back it doesn't always work. This is affecting the formatting of dates, currencies and decimal places. Text formatting seems unaffected. The sheet in question is set up to display dates as 17-Aug-10 but when I load a saved sheet it seems to be in U.S. Date/Time format. Currency pages have either lost the pound sign £ or it changes to $ and numerical data that was set for 2 decimal places won't display trailing
having problems pasting from webpage
http://www.cbssports.com/nfl/stats/teamsort/NFL/OFF-RUSHING/2010/pre?&_1:col_1=1 I used to be able to paste special the team stats in excel & it would created columns for each heading. Any way to do this in ZOHO ?
Setting sheet defaults
I'm new to Zoho so excuse me if I sound ignorant, but I can't work out how to set the defaults for new spreadsheets to my choice of font, styles, etc. I looked for the usual sort of thing, "Tools>Options>Set defaults", but I can't find anything. Many thanks
Unable to save - document exceeds the prescribed limit
Hi there, Am having problems with a Zoho sheet that won't let me make and then save changes. it comes up with the error message "unable to save. the document exceeds the prescribed limit (i.e. 65536 rows and 256 columns per worksheet or 1 million cells per workbook)... etc. however neither the workbook nor the sheet are particularly large. have tried taking it out and putting it back in but no change. any suggestions? thanks Dan Littlehales
Can't access shared sheets using Office Plug-in
I need to edit documents on Excel using the plug-in which is fantastic. However it only shows my documents and not ones that are shared. Is there a way to get or give full access so others can use on their desktop?
Occassional sorting hiccups & the number "40228"
Sorting problems still occasionally occur. I've been sorting strictly by column A (date), making sure that THE ENTIRE SHEET is selected ( I no longer trust the "expand selection?" option! ) I decided to sort by column D (last name). I selected entire sheet, and tried using "custom sort". It sorted that column, but the rows didn't follow along, as they should have. Fortunately, I was able to revert to an earlier version (the back-button wasn't 'active', so it wasn't an option). ALSO-- I noticed something
Is it possible to reference a different sheet?
By way of example, Is it possible to reference Sheet1 cell B3 in Sheet2 cell C9, if so, how? Thanks, Fred
ZOHO SHEETS
I figured out how to manage my excel on zoho...........YEAH! I love ZOHO :)
gridlines
how do i get gridlines to show when i print my spreadsheets?
Upload problem
Can anyone help me upload an excel worksheet to ebay. I copy and paste it but the formula dose not work. Any help would be appreciated. Thanks Peter
关于ZOHO SHEET 请问如何将列隐藏
请问如何将列隐藏
Next Page