sheetについて
オートフィルタの機能を付けてください。
セルの結合について
セルの結合、現在は横にしか出来ません。これではGoogleスプレッドシートと変わりありません。 セルの縦結合が出来る様にして下さい。 バージョンアップしたら使います。
Upload and Replace existing file?
Hello, I am working on my Excell sheet on my desktop and I upload it then here on Zoho but every time I upload I get a different file. How can I upload and replace the existing file on my Zoho? Thanks in advance.
uploading complete folder
how can i upload complete folder. if i edit it online, do it leaves any traces to the hard disc on my computer or any other place
Auto-Sorting
I love the webdata auto updating feature, but there is 1 part that I still have to manually do -- sorting. I have the webdata set to get me a list of numbers that change continually. It is a scoresheet so I like to have it sorted so the highest numbers are on top. It's not a huge deal to manually update it, I have been doing it that way for many months now. Just figured I might as well suggest it here and see what happens.
Creating an audio alert in Sheet
Is there a way to create an audio alert in Sheet?
Copy a zoho spreadsheet
Hi, I created a zoho spreadseet and i want to make a duplicate of that file. But zoho doesn't allow me to make a copy of that file. How can I make a copy of the file so the new file contains all the formatting and formulae of the original file?
auto save each field imediatly when is eneter in Survey
i have a survey with 8 pages and a lot of questione i need a solution to save each field when is enter by the operator
Is it possible to track what exactly was changed in a spreadsheet?
I am looking for a solution that provides me with general project management tools as well as an online spreadsheet that allows us to create and edit different information customised for our project. We've previously had problems with different people changing different cells in "normal" Excel with-out other people realising what was changed and who changed it. Hence we need to see when and who has changed the spreadsheet as well as who exacly changed it. In Zoho sheets I discovered the functionality
Monthly Exp Report
Monthly Exp Report June + July 2011
New in Zoho Sheet: Image support in Export and in Remote API
We have been supporting images in spreadsheets since Sep 2007. However, when you export the spreadsheet from Zoho, the images were not retained in the exported spreadsheets. We are glad to announce that we now retain the images when you export your Zoho spreadsheets. Remote API users will also be able to view and insert images to the spreadsheets opened using our Remote API. Images are also now supported in the spreadsheets uploaded directly to Zoho Docs. The 'View in Zoho Sheet' functionality available
Linking external data -- Please provide valid dataurl.
I do have a valid data url. It was linking external fine using this url until I decided to make a change. It lets you go through the entire wizard. Provide data (HTML with URL) select data (the tables appear fine with the correct data and let you select the ones you want) select location (no issue) schedule (now or schedule both have issues) When you select DONE I get the error 'Please provide a valid dataurl.' I never use to receive this error for this same URL. Here is the URL. Again,
Zoho Sheet Crashing Too Often Today
Dear zSheet Team, Today I am seeing to much of the message as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Broken Grammar in Zoho Sheet
Dear zSheet Team, One of the recent error messages that I encountered with Zoho Sheet was: The server has encountered a problem. We are sorry! We recommend that you copy the data that you entered till now, paste it elsewhere and then create a new document and try again The second line seems to be too much fragmented and/or using the 'and' in a way bit not-so-desirable way. Can you rephrase and correct the same please? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Unable to copy the error message
Dear zSheet Team, This is a related issue to http://help.zoho.com/portal/en/community/topic/zoho-sheet-crashing-too-often-today. The error message "The server has encountered a problem. We are sorry. We recommend that you copy the data that you entered till now, paste it elsewhere and then create a new document and try again". does not seem to be copy-able. It looked like you have overriden clipboard functionality for the sheet. But can you also provide a diagnostic copy for the user to copy and
Can buttons be cloned or copied to another sheet within the same workbook?
Can buttons be cloned or copied to another sheet within the same workbook?
Use REPT() to draw in-cell bar charts / sparklines
The REPT() function is used to repeat a text, 'n' number of times. This can be used in interesting ways. For example, you can use this function to draw a bar chart within a cell. Here is a sample spreadsheet which uses the REPT() function for in-cell charts. This spreadsheet holds the statistics of previous Wimbledon championship winners by Country. The range B3:B16 is named 'gentscount' and the range F3:F13 is named 'ladiescount'. Cell D2 is named 'maxbars' and it refers to the maximum width of
How can I create macros to shift cells in each direction?
I am using the code below: Public Sub ShiftCellsToDown() Selection.Insert shift:=xlDown End Sub Public Sub ShiftCellsToUp() Selection.Insert shift:=xlUp End Sub Public Sub ShiftCellsToRight() Selection.Insert shift:=xlShiftToRight End Sub Public Sub ShiftCellsToLeft() Selection.Insert shift:=xlShiftToLeft End Sub However, when I run these macros, only the shift to right works.
How can I display the cell contents from another sheet using sheet index rather than sheet name?
I have a workbook that it is every expanding and the name of the worksheets change. However I always want to display information on the first worksheet that is pulled from the 4th worksheet, despite the 4th sheet name changes.
Excel formula to Zoho formula
Hmmf - just finished writing this - tried to add a Google doc and it crashed the page and now I'm having to start again. Anyway, I'm new to Zoho, and I'm trying to use Zoho to create an HTML or iframe version of an excel spreadsheet I've made which I then plan to paste in a Wiki page in Moodle. It's so my students can add their own grades to their own grade sheet - and automatically get the correct overall grade shown. Once up and running I'd like students to be able to add predicted grades and also
Bookmark your spreadsheet
Here is how you can bookmark your spreadsheet. This could be useful when you want to open a spreadsheet by default as soon as you sign in or to create bookmarks for several of your spreadsheets. Open the sidebar using File -> Open (Ctrl+O) or the sidebar handle on the left Right click on your file listed under My Sheets. You will be presented with the browser's contextual menu. To bookmark a file: On IE, select 'Add to Favorites...' On Firefox, select 'Bookmark This Link' To copy the link to the
Default file in Zoho Sheet
Is there some way to set one file as the default sheet in Zoho Sheet, rather than it opening on a new workbook everytime?
Cells not updating unless I close sheet and reopen.
I haven't had this problem until today. For some reason, I type =(5*P35)*.01 in a cell and it doesn't convert to the value, unless I close the sheet and reopen. I then set the format to %, and have to again close and reopen sheet. It was working fine yesterday, :(
Insert multiple rows and columns
To insert a row or column, you will normally select a cell/row/column where you want to insert the row / column and use the 'Insert' menu icon available on the toolbar (refer the picture on the right). You can also right click on the cell and then choose the corresponding Insert menu items. Now if you want to insert multiple rows/columns, here is what you have to do. Select as many rows as you want to insert and then do a right click on the selected row headers and click on the Insert Row Above /
Time Format
It should display the whole length of time even when it is bigger than 24 hours or 48 hours. For example, if the time is 50 hours, it should show 50:00 instead of 2:00.
copy/paste
How do you copy/paste between sheets?
#1 goto another sheet #2 find the next empty row
My development is going well and I appreciate the answers I have gotten form the Zoho staff..... #1 I would like my macro to be able to leave sheet1 and go to sheet2 . #2 I would like my macro to be able to search down the sheet for the first occurrence of an empty row.... discovering that the first cell in the row is empty would be sufficient. Best 99guspuppet PS I feel that I am missing the obvious... where do I find code examples and tutorials ?
evolution
First of all congratulations for this achievement, which may in some cases to dispense with php / mysql Question 1 do you integrate validation to create dropdown lists limit of 1 GB it will be even larger pay
Detailed Employee TimeSheet
Ive noticed that when I clicked the button to generate a detailed timesheet on the employees timesheet page the report was generated fine. Then I made changes... Now when I click the Detailed Timesheet button it gives me the old data that was generated before i made the changes. I went down to the bottom and recalculated the employee timesheet then tried again. Still no luck. I then went to the reports on the top and generated a detailed timsheet report. This generated the correct updated report...
removing people from shared sheets
is there a way to remove someone from all shared worksheets without having to do each one individually? thanks Dan
Want to compare a cell from sheet1 to a cell in sheet3
Thanks for your previous help ....... My non-working code is ........ if ( ActiveCell.Value =Sheet3!A2 and Sheet1!B2 =Sheet3!B2 ) then Range("C12").value = " successful logon" Range("C13").value ="David Kimball" end if 99guspuppet
Information is Not Saving in Sheets
Hello, Is there any reason that information is not saving in our spreadsheets despite hitting the save button? Thanks
I have 3 sheets 1 , 2 , 3 I would like to lock sheet three so only I can modify it
I have 3 sheets 1 , 2 , 3 I would like to lock sheet three so only I can modify it or look at it.
Using Macro to copy data from sheet3 to sheet1
I would like to copy data using a macro ..... copy data from cell A2 thru A18 on sheet3 to B12 thru B28 on sheet1 thank you
Zoho dies very slowly ..... development becomes impossible
Update: 2011m06d10 The Zoho staff has been very helpful and now I am well on my way to accomplishing what I wanted to do Hooray 99guspuppet I was building a spreadsheet to monitor inventory. I had some ideas that I liked and everything seemed to be going along well. I asked some questions and I was told that Creator might be a better fit. I tried Creator and it seemed nice. My partner did not like it though.... so I returned to using Sheet. At the time I returned to Sheet .... I was 70%
Pulling certain field data only
Hi, We have a sheet of data with all our website product info including name, SKU, price etc. - this is on sheet 1, and will dynamically change as we add new products to our site (as its a live CSV feed). We want to give one of our suppliers access to sheet 2, whereby they can add in comments such as stock levels and latest purchase prices. So is there a way for us to: 1. Highlight / select rows from sheet 1, and have them only appear in sheet 2? 2. Have only certain columns of those rows appear
Linking external data
Hi, I have a live URL that provides a CSV of all the products on our website (we use it to populate Google Product Search). I've added the URL into my Zoho sheet and scheduled it to get the data each day. It does pull in the data but I can't get it to format correctly in tab delimited. Its just pushing all data into column 1. How can I change this? Thanks
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.
logon questions for spreadsheet
I am very new to Zoho stuff #1 I want limit a spreadsheet to allow one person at a time ..... to logon to the spreadsheet. ( with a password and logon name ) #2 I want to access the logon name in a VBA macro. ( The logon name of the person who is logged on ) Best 99guspuppet
How to set spreadsheet cells to NOT block text flowing from cell to the left?
How can i set cells so that they do NOT block text flowing in from the cell/s to the left?
Next Page