Tip #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 irregularZoho Sheet - Option to disable "Embed" button when publishing a sheet
Hi Sheet Team, I've noticed that when I publish a Zoho Sheet publicly, there is an option for the viewer to "embed" the sheet. There is no option to disable this button and my idea/feature request is to include a checkbox in the Publish settings to hidePublished Sheet - Share option to show "Save copy to WorkDrive"
Hi Sheets Team, I'm currently working on a Zoho Sheet which I want to share with other Zoho users outside of my organisation. Normally I would do this with Google Sheets but I'm trying to make better use of my Zoho tools. When I share a Google Sheet publiclyAbility to Set Text Direction for Individual Cells in Zoho Sheet
Dear Zoho Sheet Team, We hope you are doing well. We would like to request an enhancement in Zoho Sheet that allows users to set the text direction (right-to-left or left-to-right) for individual cells, similar to what is available in Google Sheets. UsePDF Import
Hi Guys, Zoho Sheet now supports file formats such as XLSX, XLS, XLSM, ODS, CSV, TSV, SXC, XLTX, and TXT. However, support for PDF files is not available yet. Adding this option would be very helpful. Thank you!How to integrate the zoho sheets with your Application
Hello Zoho Developers, Here are some tricks and ideas for Zoho Sheets. Zoho sheets. Zoho Sheet is an online spreadsheet application that's part of the Zoho Suite. It allows users to create, edit, and share spreadsheets in real-time, similar to other spreadsheetLets increase the 25MB Limit of spreadsheet file size to at least 50MB.
Lets increase the 25MB Limit of spreadsheet file size to at least 50MB.Embed With Formula Bar and Headers Not Visible
Is there a way to embed the sheet on an external page without the formula bar or headers showing? Love the product and it's an awesome way to present users with tools and calculators but for aesthetics, it would be great to remove these for a cleaner look. Thanks!Lets increase Zoho Sheet spreadsheet cell limit to 10 million like Google Sheets
Lets increase Zoho Sheet spreadsheet cell limit to 10 million like Google SheetsCan we have Online Zoho Sheet Supports Offline Use?
Can we have Online Zoho Sheet Supports Offline Use?Customize toolbar
I'm hoping to move to Sheet from Excel. There are a handful of buttons I use constantly and would like on the toolbar rather than hunting for them. Is there a way to customize the toolbar to add commonly used buttons? Also, is there a way to put macroPlease improve the toolbar!
Do you have plans to continue improving the toolbar? I waste A LOT of clicks increasing/decreasing decimal, setting number formats, formatting, adding borders etc. At the very least, can you make the toolbar bigger and have those pull down groups permanentlyWorkDrive Browser Extension That Allows Direct Save to Work Drive
Hi, I enjoy WorkDrive a lot. I believe it could be enhanced if there was a browser extension that allowed pdf files to be saved from the browser directly to workdrive. This could be done as a save as option or print to pdf option that works with theUse of Combobox in worksheet.
Combo box is very useful for set cell value from some choice. So, please Give some solution.. and thanks for your replay.Rotating text
It would be very useful to be able to use text vertically and not just horizontally.cut and insert
in most spreadsheet docs (Excel) when you cut the data from one area and try to put it somewhere in the same sheet the rest of the sheet is automatically moved down so that it fits in without overwriting any other information. however in Zoho any cutting moves the intended rows but overwrites other rows unless you specifically create a space of the correct size for it. this would save a lot of time if the sheet acted more like Excel in this regard. thanks.Idea : Ability to mark certain rows as title rows (heading1, heading2 et al) just like in MS Word
Namaskaram. Sheet remains close to our heart as one of the most popular go-to apps for anything under the sun! ☀️Having said that, it's useful to have the ability to mark certain rows as say 'Heading 1' rows, 'Heading 2' rows and so on, just like we do in Word/Zoho Writer or any document editing tool for that matter. This would help organise Sheet content much better. Also there could be allied features like, say, when I scroll, the heading rows could freeze on the top when the corresponding contentSheet - Selecting multiple individual cells using Ctrl key
Hi, Sheet allows the selection of multiple cells in a Range by using the Shift key. However, it does not seem to allow the selection of multiple individual cells using the Control key, like most other spreadsheets I've experienced. Is it possible to do this, or will this feature be introduced? It is a very common requirement. Thank you, DaveAllow freezing multiple rows and/or columns in Zoho Sheets.
I want to request allowing the ability to freeze multiple rows and/or columns in Zoho Sheets. As of right now, if you highlight a row or a column and right click or go to the "View" tab, you have to options to freeze one row, freeze one column, and freeze panes. The first two options are self-explanatory, but the third option allows you to freeze one section that's a total of five columns and five rows in length (i.e. columns A-E, and rows 1-5), according to a Zoho Docs representative I spoke withCreate a top and double bottom cell border
Is it possible to create a premade top and double bottom cell border like in this screenshot?Alt Keyboard Shortcuts
This is key for me as a financial analyst, and would make things much faster.Request: Option to Export to Google docs
Hello, I see there is an option to import a sheet from Google docs. I see the Export option has quite a few formats where a sheet in Zoho can be exported to however, it does not have the option to export to Google docs. Would it be possible to put this request into your roadmap? -- Thank you, TXTNLRN Dan text or call: 512-850-4898 Web site: http://www.TXTNLRN.com Teaching and learning through text messages. TXTNLRN Introduction Demo presentation - http://goo.gl/z1MJO or Get to know TXTNLRN http://screenr.com/7yS8Data Validation
Problem description: I have a shared sheet with my colleagues and they keep on entering different date format, even in text format. Suggestion: Can we have a data validation function per cell so we can have users entering only specific data types (ie. date) into a cell? This will be great, thank you in advance.I want everyone in my group to be able to make changes on the original sheet, so everyone know what is left in he inventory. Does anyone know how to change "saving" parameters?
Below is the warning I get when I open this sheet!Embed options for Zoho Sheet in webpages?
The embedding method of sheets with iframes is cool, but are there any way to pass some options or parameters when I fetch the sheet? Sometimes it's good to let the viewer see the traditional view of a spreadsheet, but other times I really just need the functions and not the rest... It would be nice to pass options for: Sheetname/link - visible|hidden Column/Row headers - visible|hidden Scrollbars - all|vertical|horizontal|none Singlesheet - Able to select specific tab in sheetImport from Skydrive is required
Dear zSheet Team, Similar to the 'Import from Google Spreadsheet' feature that you have in your menu, it would be great if you could also have a 'Import from Skydrive' feature. Skydrive is just gaining momentum and has glaring bugs including missed out usability testing too.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?Have a button Save As
Hello, I would like to have the button Save As for a sheet edited in Zoho Sheet. I used to have this functionnality in Zoho Docs, but now that I converted my sheets to Zoho Sheet, I am not able to do it anymore. Many thanks! Christophe Mendez | Head of Consulting ServicesCan you specify the sheet name also in the message?
Dear zSheet Team, When I delete a sheet you are responding with a message as below: " The selected sheet will be deleted permanently. To delete the selected sheet, click OK. To cancel the deletion, click Cancel." I would appreciate if you could mention the sheet name also in the sentence and rephrase the message as below: "The selected sheet (Sheet 2) will be deleted permanently. To proceed with the deletion click OK. To cancel the deletion, click Cancel". Wouldn't this be more friendly? ---- DeepakStep thru function in VBA editor
I'd love to have the ability to step through a macrodata filters
Microsoft Excel is currently the name of the game when it comes to spreadsheets. Nothing else seems to come close. But Zoho could go a long way in gaining parity by adding data filter functionality to the mix of capabilities. Even if I could filter just one column at a time, that would be a huge start. Please consider this. Thanks. - Bal@TXTNLRN requests, @Zohosheet, Add ability to add comment in Notification email of what was updated when a sheet is updated
Hello, It is me again. Scenario: I received an email when the sheet I had shared with another member was updated. However, It did not mention what was updated. Request: 1) Either add provide the ability to add a comment where user can enter what was updated (the way when the sheet is shared and an invite is sent). 2) Or Sheet includes which cells were updated. Thank you Staff TXTNLRN #TXTNLRN_Software_test http://www.TXTNLRN.com text: 512-850-4898 @TXTNLRN@TXTNLRN,requests,Add capability to display the number of character in a cell
Hello, Currently, it looks like when typing characters - numbers or letters, there isn't a display of the number of characters in that cell. Requesting to add capability to display the number of character in a cell. Appreciated. Staff TXTNLRN @TXTNLRNPlease support SQL data sources in Zoho Sheet
Please add support for SQL data sources in your "Link External Data" feature. Thank you, Near PrivmanAdd capability to resize the comment box
Hello, Request to add the capability to be able to resize / shrink and expand the comment box. See screen shot attached. Thank you Staff TXTNLRN Call or Text 5128504898 http://www.TXTNLRN.comMerging Cells Down
It would be very useful to be able to merge cells down in adition to sidewaysZoho Public Sheet Suggestions
I just observed from the public sheet https://www.zoho.com/zoho_faq.html that as per one of my previous bug report, this has been changed and corrected. Now I see an explicit button called 'Click to edit', 'Save to Excel' and 'Full Screen'. I have a few suggestions. (1) Once I use 'Click to Edit' it is disabled. Instead of disabling how about toggling it as 'Stop Edits' so that it would be like a on/off binary state switch. (2) Along with 'Save To Excel' can you get me an option like 'Save to ZohoExport to Zoho Sheet
Zoho Team, I was browsing through a webpage and just used the 'Export to Microsoft Excel' option and then imported it into my Zoho Spreadsheet. I was just wondering if you could help us with a quick BHO that could give a context menu in Internet Explorer and FireFox which would export the webpage into a new Zoho spreadsheet. You can perhaps name it as 'Export to Zoho Sheet'. I hope that would be of great use to many Zoho Sheet users. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/When editing a formula, the cell involved should be highlighted with different colours
Hi everybody, IMHO when I edit a cell containing a formula, it would be very useful (and usable ) to have the cell involved highlighted with different colors. Example =C3+C1. C3 should be green as well as the C3 cell borders. Same thing for C1...what do you think??Sort Ascending / Descending Clarification
When sorting columns in sheets I find it a little confusing. Basically I just want to do a straight sort either a-z or z-a. The problems I have are.. 1a. The pop up describing the options when one chooses to sort is confusing to the average user like myself. It says `Do you want to expand the selection? Click OK if you want to expand the selection. Click Cancel if you want to continue with the current selection' Usually in a pop up like this clicking cancel means you no longer want to perform theNext 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 inI NEED TO NUMBER TO TEXT NO HERE
=NUMBERTEXT NEEEDBUG: 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
Paul Queen Soft
Kulveer
Crystal
Vinoth Kumar K