Please 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 permanentlymoving a chart
Hi, I have a bar graph in one of my sheets. It is working fine and changing when I make any edits to the underlying data. I have a problem moving the chart to a different place on the sheet. I need to enter information in the cells which are directly beneath the graph. I tried to select the chart and it just does not happen. I am using the latest 'stable' version of Chrome and I did not have this problem of selecting an existing chart. Please help. Thanks, SeshadriHow to remove hyperlink when there is additional text inside the cell?
Greetings, I hope find you all well and safe. I have a cell with an email address plus a text between parenthesis, like email@email.com (info) When I type just the email, I am able to remove the hyperlink normally, but when I type the additional texthow to lock the cell in the zoho sheet? Please help!
how to lock the cell in the zoho sheet? Please help!Fetch CRM Deal Name in Zoho Sheet
Hi, I would like a user to fill out the form and have the form data sent to a Zoho Sheet. I've accomplished this task easily. What I would like to do next is based around get.Records or search.Records in the CRM based on 3 columns in the sheet. so theSheet not loading preset validations
My team and I share a zoho sheet and this week all of us are running into delayed issues regarding the preset data validation options. The sheet is not picking up what we are entering and this has been an ongoing issue all day today. I sent in a helpBug fixing
I gave delete column instead of delete row for a selected row which led to the deletion of everything. When i clicked the left arrow,to return to the previous step the data that was lost was left as it is.i Lost all my data and have lost all my efforts.Fixing the Bug and getting the datas back
By choosing a specific row,i clicked on "Delete column" instead of "Delete Row" which ultimately led to the deletion of everything. When i clicked on the left arrow button to get to the previous step,the data that was lost never returned and left as anI need a demo
Please, I am a new user and I need a demo. How do I get one ?I need a demo
Please, I am a new user and I need a demo. How do I get one ?Use button to trigger Flow webhook
Hello, I am wondering if it is possible to have a button on a sheet that when clicked would send a webhook to Flow? I know how I'd imagine it would work, but definitely don't know VBA well enough. My thought was that when a user clicked the button, aZoho Sheet Hot to set Background Image
Is there a way to set a background image on the spread sheet?Compare versions
There does not appear to be a way to compare versions of a spreadsheet to see what changes were made. Is this a feature being considered or is it already there and I just missed it?Send Mail from sheets using a macro attached to a button
Hi, Request your support to help me with the macro. Functionality needed is to allow the button send mail to the selected email address cell. email content is just needed as a message not attachments attached to it. Regards Divya Panchal.Fill series of data
Hello, I have several tables of data where I know the first and last cell value for each column. Is there a way I can populate the blank cells in each column to show values that gradually decrease, with the lowest value being greater than the bottom cellSum If from Picklist
I am seeking assistance on how to capture the sum in one column based on the column of picklist? Also, can date be added as a filter? Example: Column 1 is date Column 2 is sale Column 3 is picklist (item A, Item B) Sum if = Item A Sum if = Item B SumCharts in Embedded Docs Not Visible
Hello- Been experimenting with embedding a Zoho Sheet document within a web page. But I'm finding charts are not published when I publish a worksheet. Did a search and found this from 10 years ago: https://help.zoho.com/portal/en/community/topic/charts-are-not-showing-in-html-viewHow do I consolidate different worksheets into one?
Hello I have a Zoho Sheet which is made up of a number of different tabs of data, each with the same column titles, but each referencing a different source of data. (See screenshot for example). Is there an automated process which would consolidate theseStock function not working
Hello, For the last couple of days the stock function is not providing the latest stock prices. I've used this Sheets feature for quite some time and up until the last couple of days it was working. Today I converted my Sheets file over to the Workdrive,If formula
How do I create a formula, such that if a cell with a checkbox is ticked, the previous cell containing the date of activity is erased and checkbox is empty againError calling macro module from Workbook_NewSheet
For several years I've used a sheet that calls a macro in a macro module from the ThisWorkbook module under Spreadsheet objects. Earlier this week I adjusted an unrelated part of the macro module, and the call from the ThisWorkbook module stopped working.Date Time Format setting according to region wise
Hi i am facing issue of date time format setting in zoho sheet. By default there is american date time setting how can i change my regional settingHow to delete multiple empty rows?
I have a list of data that has been imported, however it now has an empty row in every 1 - 2 rows. Is there a way with the new data cleaner to remove these rows? I have over 1,000 rows.Cannot copy from one spreadsheet file to another with formula
Hi, I am trying to copy a cell range (which has formula) from one spreadsheet file to a another, but only the values get pasted not the formula. How can I copy paste such that the formula gets copied instead of the values? Kalpa Pathum Welivitigoda http://about.me/callkalpaNew in WorkDrive: Share with Anyone on the Internet
If you need to share a document or file online, it's best to do this securely and reliably. While there are multiple methods for transferring files online, it's good to keep in mind the purpose of sending the information and understand who your viewers are. WorkDrive already gives you a customized External Sharing option, where the sender can control the link properties to share data securely. In addition to that, here's a new way of sharing files with external viewers. By using this new feature,I cannot sort in sheets because of a 'merge' in the column
When I select the entire column and select UNMERGE, it still gives the error when I go to sort that column!Import External JSON
Hello, How can i import (and keep it updated) a external web json? For exemple i have this test json: http://www.omdbapi.com/?i=tt3896198&apikey=8502817a How can i import it correctly? and also keep it updated. ThanksTrigger a custom function in a Zoho Sheet on range change
Hello, I have a custom function in Zoho Sheet that updates a Zoho CRM record. That by itself works. I am trying to trigger that function when a new row is added to the sheet. I thought this would be able to happen via the VBA editor, but I can't get itembed zoho sheet to google sites and allow real time update
Is it possible to embed zoho sheet to google sites and also allow real time updating?How to check for duplicate values
Hi, I have a list of values in a column. And I keep adding more values to the column. I want to check and highlight the cells with duplicate values. How can I achieve this? I tried with conditional formatting, but there was no such option for duplicates. Kalpa Pathum Welivitigoda http://about.me/callkalpaZoho Sheets has frequent DNS issues - Zoho Sheets goes offline
At least once a week Zoho Sheets will go offline. I'll be in the midst of working on a spreadsheet and suddenly it's gone. Instead, I see this error message: This site can’t be reached Check if there is a typo in sheet.zoho.com. If spelling is correct,New Toolbar in Zoho Sheet
We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the farHow to do repeat item in pivot table
Hye, I want to do repeat item in pivot table instead of missing value. How i can do repeat item like google sheet and excel. (pivot table)Paste as value, ctrl+shift+v bug
Scenario: Copy one cell Select range of cells Paste as value(s) from right click populates all cells Paste as value(s) from ctrl+shift+v only populates the first cell I work in tables A LOT and I need the keyboard shortcut to work so I don't overwriteTip #17: Easily share spreadsheets with non-Zoho account users
With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do notsheets not working in certain PCs in the network
We are using Zoho sheets in our company. And suddenly for the past two weeks, we have a lot of issues and sheets don't work in many of the PCsWhy can't I scroll down the list of additional fonts?
Greetings, I was trying to add some fonts to my list from the ones available but I am not able to scroll down the list in any of the categories. I am only able to view the first dozen or so that are at the top of the list starting with the "A"s. I've#EVAL! for personal function with "Deluge" in Zoho Sheet
I am trying to use a custom function, in a file that is shared with other users. It doesn't matter how simple the function is, I don't have the value assigned in the "return". Only get "#EVAL!" response. This is one of my functions, the simplest (madeHow do I get my cell height to auto adjust?
I'm evaluating Zoho Sheet as a replacement for Google Spreadsheet. Using latest version of Safari, and experiencing the same issues in Chrome. A few bugs/things I can't figure out: Auto adjusting cell height when importing from Google Docs or creating a new document Turning off the auto date formatting for X.Y.Z where they are all integers.. (This is extremely important, as our requirements are written as outlines.. "X.Y.Z" corresponds to a requirement ID.. which is then turning into a date) TheVertical alignment in sheet cells is incorrect
Vertical alignment of text in sheet cells is inconsistent, specifically, "Align Middle" does not actually put the text in the vertical middle of the cell. Consider these cells aligned bottom, taking note of the amount of padding is between the text andNext Page
Announcements
Tip #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 thatThemes in Zoho Sheet: Keep your spreadsheet's formatting consistent
Formatting a spreadsheet is now even easier with Themes. With Themes, Zoho Sheet empowers you to select, customize, and apply a uniform formatting style throughout the entire spreadsheet. When working on a data set with collaborators, you might noticeSlicers 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,Our pivot tables just had a pivotal update!
A pivot table can help you summarize rows and rows of data in a single table. This means you are readily provided with the insights that you need from your data. Zoho Sheet has now made this process a little more easy with the new pivot table enhancements like auto-refresh, auto-expand and has made it possible to experiment a little as you create your pivot tables. Keep working on the data; we'll keep up with you! Here's a classic issue with the traditional pivot tables. You'll have to keep refreshingCheck out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
Most Discussed Topics
Syncing Sql Query Table to Zoho Sheets
I want to sync Query table to Zoho Sheets. I already used data connection zoho sheets but the issue I am facing is while it gets synced the data I entered in new columns next to synced columns is getting mismatched as new row data is coming. So is thereSUMIF with "=" condition giving #NAME! error
I have =SUMIF(H21:H27;=&B55;I21:I27) which is throwing an error. Have tried =SUMIF(H21:H27;=B55;I21:I27), =SUMIF(H21:H27;"="&"B55";I21:I27) and =SUMIF(H21:H27;"=B55";I21:I27)Suppress "spreadsheet will not be saved" message on published sheet
I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheetData overlapping error - data connection schedule
Hello, I created a spreadsheet and connected it via data connection to zoho analytics, asking to fetch data monthly from a table in analytics. I want the data in the spreadsheet to be replaced each month with the newest data in the analytics' table. Eachzohosheet keep loading and don't know how to fix it
one of my zoho sheet is getting slow. How to fix it.
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 Campaigns 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
Tip #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 thatSlicers 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,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatTip #16: Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end. But what if you could analyze all your data sets with a single AI-powered tool? Meet Zia, our smart virtual assistant who will answer all your data-relatedFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
Top Contributors
Murugalakshmi S
Narendra Eswar G
Mehnaaz T
kvansensie
Vinoth Kumar K