Size of imported Excel workbooks
Is there an limit to the size of an excel doc that can be imported. Either in terms of number of sheets in a workbook or phsical size; ie megabytes ?unable to import xls files
hi, can anyone please tell me how to import xls files. i get the error as Unable to import content and some times as extension not supported. Iam able to edit and save txt and doc files.Zoho Sheet Feedback
1. Is there an undo button? I can't find it. 2. Is there a way to enter a new line in the same cell (I think it's ALT-ENTER on Microsoft or CTRL-COMMAND-ENTER on a Mac)? elizabethkkochLosing text when trying to edit a wrapped cell
Hi, I imported a sheet from Microsoft Excel, I have from the original file cells wrapped and they appeared nice at Zoho Sheet, but when I click to edit, I lost almost all text of the cell staying only with the first line before the wrap. I tried to click in all arrows, home, end, page up, page down, keys, and I verified that I lost my text. Thanks for the attention! Keep the great job! danExpanding sorting selection
I have a spreadsheet where I need to sort in ascending alphabetical order, but I want to expand the sorting to include all 3 columns of the spreadsheet (so that when column A is sorted, the corresponding information in the cells in B and C will follow along). Is there a way to do this in Zoho?Opera
please make the program compatible to Opera-Browser! Shouldn't be difficult, - is it? bschreyerTechnical Support
エクセルのように、オートフィルタの機能はないのですか？ これが使えると大変ありがたいです。 sahorikoPrint all columns
I have a spreadsheet with columns A to and including "U". My question is: How do I print all columns? joegahringSheet data sorting
Hi, I can't figure out how to determine the sorting key in a data sheet. zehubertCompatability with Safari
There seem to be a problem with using Safari... any plans to fix this? annewtnewbie to spreadsheets
I hope this is the right place to post, if not, I do apologize. I am trying to teach myself how to do a spreadsheet. As a practice and also to keep track of things, I came up with a simple one that actually works. the columns are DATE CHECK# AMOUNT BALANCE. To calculate the balance each time an amount is entered I have for a formula =SUM(D3-C4) However, each time I enter an amount in the next row, I have to retype the formula in the balance so the next one would be =SUM(D4-C5) My question is, IsProblem opening the document
Hi, I just can't open anymore my sheets (3 files) A message say "problem opening the document" What can I do? Thanks for your help I really need these documents! :?share with a user group
instead of typing in 20 email addresses to share for each document, is it possible to create a user group (e.g. MyTeam) and just type that in to share? The benefit of that is that if you add/remove team members, you just do it once to the user group. And the change will immediately be reflected on all documents shared with MyTeam.Addding edit buttons
I dont see the 'undo' button I am so familiar with on Excel on your Sheet program. Is it available ? If so, how do I add it ? jhellmanIcon disappears
while editing a Wiki embeded Zoho sheet ( by clicking on its name), the "Save" icon disapears... fabricerimlingerErrors with Remote API
Can you help me figure this one out? Error: RESULT=FALSE ERROR_CODE=2841 WARNING=Unable to import content My code: <form method="POST" id="frmZohoEdit" action="http://export.writer.zoho.com/remotedoc.im?apikey=9e7a4165451bcb2f828cf1089e050e04&output=editor" target="_blank"> <input type="hidden" name="id" value="!#[this.instance_id]#!"> <input type="hidden" name="url" value="http://!#[system.domain]#!!#[this.file_link]#!"> <input type="hidden" name="saveurl" value="!#[PAGE_URL_108]#!&action=SaveFromZoho&edit=!#[this.instance_id]#!">iPhone
Is it possible to initiate a control-F, search and find on a ZOHO spreadsheet from the Apple iPhone? If not, do you have any suggestions how to use the iPhone to access a 3600 line spreadsheet of inventory information. I need to be able to lookup product availability for shipping. Thanks rogercolwelsave
save options in zohosheet should be: * save as same version; * save as new version, replace old; * save as new page in this sheet; * save as new page in new sheet; * toss (discard, with confirm) [assuming page is a tabbed page within a sheet [or book]] bahaidaegusheet book page
how to delete a tabbed page? also, just to clarify terminology, does "sheet" = collection of tabbed pages? page "page" = one grid of the spreadsheet "gridblock" = one selected area of spreadsheet vocabulary should be defined and accessible in a glossary via a glossary button bahaidaeguZoho on the Treo
I was wondering how to use Zoho on my Treo, it seems possible since it's working for the Iphone. Does any one know how to do it? Thanksrows with 2 lines of data doesnt show properly
Hi techies, Your sheet s not working properly for me. I was using google account but due to its limitations tried to switch to ZOHO. But your s/w seems to be at nascent stage, here all the rows with texts running in more than one line takes another row. Hope I am clear with my problem and you will come up with a solution soon. Thanks Sangharsh meetsang@gmail.com meetsangZoho Sheets
I was working in Zoho sheets. There is a provision for uploading the spread sheets. When I tried uploading a spreadsheet, I found that I was able to select files of any types like docs, txts, gifs etc., Though uploading such files is restricted, it should not allow me to select such files in the first instance itself. My suggestion is that just allow to select only files of type xls and csvs rather restricting while we upload. sudhakarrathinamOFFICE 2007 Add-Ins Ribbon disappears
I installed the plugin for Office 2007 (I'm running Vista). After it finished installing, it opened up Word & Excel and the Add-Ins Ribbon was there and I signed into Zoho and could use the plugin just fine. The next time I ran Excel, the Add-ins Ribbon was gone. I went into the Excel Options menu and looked at Add-Ins and the Zoho plugin was no longer there. I uninstalled, reinstalled and the same behavior happens everytime. Is there a reason why the plugin won't load each time I open Excel? (SameZOHO Sheet charts
Hi, In Sheet, how can I change the colors of bars and fonts? It's pretty hard to read black on blue, which are the default colors. Also I cannot pick e.g. two different rows, if they are not directly bordering each other. This should be possible. Otherwise a great app! Best regards, Kasper kaspernslost of data
Well, I wanted to remove line. But I remove a column when one line was completely selected. I have lost all the information. I tried Ctrl+Z, but the information did not come back. Sheet has no version recording. I have lost my data. Any possible action? Thanks. kikomzZoho Sheet
Hi there, this looks like a great system. I'd like to use it and would even pay a moderate fee. Sadly there's not a lot of information available. I went through the Zoho sheet entrance which said some things but left obvious question unanswered, eve trawling through the forum didn't help. Simple questions need to have answers upfront E.G. What is the maximium .xls file size? Is it private? (I want ONLY me and my friends to be able to see it) Is there a cost involved? is it per user or MB size? IfAJAX-based Most Powerful-Zoho
Hi, Zoho Sheet is one of the most powerful AJAX-based spreadsheet editors currently available. We can create, edit and access your spreadsheets from anywhere.It is fully integrated with the comprehensive suite of applications offered by Zoho, supports real-time update, remote data embedding, as well as sharing, publishing, and syndication of spreadsheets.we can also copy such public sheets and use them for our individual needs or improve on them and create your own sheets and publish them for theVB in Sheet
Hello all: I am new to Zoho Sheet and was wondering if there is a way I can add some VB macros I have created a few in Excel. I was looking to use those VB macros in my files in Zoho SheetsSorting fails
Hello, I am having trouble sorting columns on my zoho sheet. I highlight the range of cells I want sorted, right click, select sort, adjust settings, and hit ok. Then nothing happens. The sorting dialog disappears and the sheet remains the same. Can anyone help? Thanks!Formatting
I'm finding it impossible to use all of the right click options that I love on excel. I can't use a right click drag to just paste the formats or fill values without deformatting the receiving cell. It's a bit frustrating. casa_azul_llcCopy Sheets?
I can't find a way to make a complete copy of a sheet (aka "copy and paste myfile.xls in windows") - does Zoho seriously not have a way to duplicate entire files? Copy & Pasting the information inside a sheet to a new sheet only copies text, no formatting! covandUndo
Is there an UNDO option in your speadsheets or word processing documents? dklarsenZoho Sheet Remote API Error
Hi there, i am using the remote sheet api with a normal form submit in order to edit sheets in zooh sheet and to save it to the given saveurl. anyway, i am always running into the same error when i'm trying to post the following link with the given form params (without linebreaks of course) http://sheet.zoho.com/remotedoc.im?output=editor &apikey=12345678 &url=http://foobar/test.xls &filename=test.xls &saveurl=http://foobar/extupload &id=123 &format=xls after the call of that link i can see the zohoSheet Will Not Load
I have one (1) spreadsheet on Zoho Sheet. It is about 50 rows and 4 columns...it is just a data list. I have not been able to succesfully load the sheet for the last 4 days. I have tried Internet Explorer in Windows XP, Apple Safari, Apple Firefox. When I click my sheet name I get a box that tells me...SHEETNAME LOADING But it never does. ....help..I really need the data. Thanks.Named Ranges
I'd like to be able to name ranges so that I can reference them in formulas. I'd also like to be able to reference cells on other sheets in my formulas.Plugin not working with Zoho Sheet
I was using the plugin without any problems (once I learned how to sync offline changes) and today I opened Excel and received an error message that the Zoho Sheet add-in could not be opened. I tried reinstalling the plugin and the add-in is still not available in Excel, but it is in Word (I haven't had any problems with that). I uninstalled the plugin, rebooted, and reinstalled it. This also did not work. I uninstalled the plugin, deleted all files and registry items related to Zoho, and reinstalledPDF Export Not Exporting Total Workbook
I've noticed that when I export a workbook to pdf it doesn't export the whole workbook only some of the sheets. It doesn't seem to be consistent. On some workbooks it exports some sheets and on others it exports others.Editing Sheet Names
1.How do I change the names at the bottom of Sheet1, Sheet2, etc? 2. How does one delete empty rows and columns? Thanks GringorPYSaving a spreadsheet adds a new one
Hi, When I try to save a spreadsheet using the Zoho toolbar it says that the spreadsheet doesnt exist and it adds a new one to my account. Is it a bug? Thanks, Nikhilesh GroverFolders !
Now that Google's got folders, I think it a even more of a must have for Zoho, especially in Sheet & Writer. That would make it so much easier to organize my stuff. markvNext Page
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
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 a smarter, faster, and more flexible charting experience
Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you toWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyNew Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your workIntroducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
Most Discussed Topics
Column letter from number
Hello, I am trying to select a cell and i have the column number. How do i do this or is there a way of getting the letter from the number? Thank youMerged cells are unmerging automatically
Hello, I have been using Zoho sheets from last 1 year. But from last week facing a issue in merged cells. While editing all merged cells in a sheet became unmerged. I merged it again, but it again unmerged. In my half an hour work I have to do this 3-4How to drag row(s) or column(s)?
Hi. Selecting a row or column and then dragging it to a new position does not seem to work. Am i missing something or this is just not possible in Zoho Sheet? Cheers, JayPower Pivot and Data Modeling functionality in Zoho Sheet
When will MS Excel functionalities like Power Pivot and Data Modeling functionalities be available in Zoho Sheet?Filter button in the Zoho Sheet Android App doesn't toggle on
I am a new Zoho Sheets user and experiencing a specific issue with the filter functionality in the Android mobile application. Detailed Issue Description: The filter icon appears correctly in the toolbar. Upon tapping the filter icon/button, the toggle
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus 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.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Introducing a smarter, faster, and more flexible charting experience
Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you toWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyNew Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your workIntroducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youSlicers 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,
Top Contributors
Vinoth Kumar K
Narendra Eswar G
MADHUSUDAN SHARMA
Subashree Ramamurthy
jamesmitchell