Zoho Sheet Edit Cell Format
It seems as though if you want to BOLD something in a cell, it applies to the ALL the text within the cell. How can you just apply to SOME of the text within the cell?How can I set Zoho Sheets to Auto-Complete when entering cell data that was used for other cells in the same column?
How can I set Zoho Sheets to Auto-Complete when entering cell data that was used for other cells in the same column?Number formatting
How do I format numbers in Indian Style like Lakhs and croresI cant edit my own file
Hi There, I can access my file but i cant modify. Appears the follow message "Unable to connect to messaging server"Spreadsheet language setting is broken, causing data loss
Dear Zoho, Some time within the last week, your code relating to the language settings for spreadsheets changed. Since that time, the date formats for all date and time cells in my spreadsheets have been incorrect. This is interfering with macros thatZoho Sheet won't open in iOS
Every time I try to open a Zoho sheet from either the Workdrive or Zoho Sheets app, it says that "There's a problem in opening the spreadsheet. Please reopen the file." Any ideas?Referencing cells from another sheet not working anyhmore. Strange behavior.
I have just noticed that referencing a Cell from another sheet in Zoho docs no longer works. It shows "#NAME!" error. It was very easy to test: 1. open a new Zoho sheet 2. create a second sheet: "Sheet2" 3. In sheet2 in on cell type the value: ='Sheet1'.A1Tip #3: Save your time by replicating formats
Formatting helps to create more visually appealing spreadsheets while keeping data organized. Selectively applying formatting options to your work, such as applying fonts, currency formats, or colors, can be time-consuming and repetitive. Replicating formatting guidelines for your work can help remove the burden of applying these menial tasks, which improve overall productivity in your workflow. Let's say you are collaborating on a spreadsheet with your team and you have to create a combined report.Not show data in sheet
Hi everyone, I am new user on this site and I haven't properly knowledge about this site. So, i have an issue, when i am open file in sheet there are no date shown, even i have been checked whole setting but can't access. All, files are very importantHow can we add formulas in excel sheet
hi everyone, I want to calculate some high amount date about my website, which can't be easy to calculate on caculater. So, i want to add a formula for easily calculation. please let me know about the formulas, how to it properly. ThanksExternal Publishing
I am trying to publish a sheet externally and have selected the "Allow Download" but when viewing there is no way to download. Also the sheets are in a different order. Instead of Sheet1, Sheet2 the published shows Sheet2, Sheet1 order.Maximum limit of rows and columns exceeded
I have entered a date in column and wish to extend it day by day to all columns till the end of sheet. But sheet shows that I have exceeded the number of columns. Zoho Sheet has many bugs and looks half baked product.How to Search Items in a Picklist on Sheets
When using the search feature in sheets, if I'm looking for an item that is in a picklist it cannot find it unless it's the present item in the cell. Is there a way to search items, regardless of their position in a picklist?Edit Legend of Chart
I would like to edit the legend of the chart. Every time I enable the legend, I get a very unhelpful (1), and when I try to type to change to what I would desire, nothing happens, which is very frustrating. I've gone through your online tutorials and nowhere can I find a legend settings button. This seems a simple fix, where can edit the legend? Thanks.integrate nomic or coinmarketcap API on Zoho sheet
how could i integrate an external API from coinmarketcap or Nomics in my Zoho sheetExport to PDF
Hey, I am pretty much brand new to Zoho spreadsheets. I would like to export my spreadsheet as a pdf. When I go to File->Export->PDF, nothing happens. I am using Google Chrome as the browser. Has anybody else had this problem or am I just missing something here?I'm new here and used to used excel back in 200 please help
Im trying to set up were I can input certain data on one sheet or multiple sheets and then on last sheet have it auto pull that information from previous sheets to get a full calculations I.E Sheets1-4 trip number miles loaded and empty and cost Sheethelp text not poping up when i select the cell
Hello, I have been trying to get the help text for the cell for which i have don data validation. When I click on the cell I do not get the help text. Is this a settings issue? can you please help. this function will really help me create a better sheet.Export
I can't get Sheet to export. It says Explorer is protecting me, then gives me the opton of exporting, I click on it and the sheet I'm working on is replaced with a blank sheet. No downloading.How many Sheets can we have?
How many Sheets can we have, is there any limitation?Zoho Sheet Wildcard Match
I am trying to create a sumif function with a wildcard, but I can't figure out what Zoho's version of wildcard is. I want all cells to sum if they have the word food. For example: Sumif(B:B;"Food";C:C) I know Excel uses * , but what do Zoho sheets use?Run a Macro from a Menu or a Button on a Sheet
First I think ZOHO Sheets are GREAT ! Your programmers and designers have done a super job ! I think you could greatly expand your potential users if you had a way for your Macros to be Menu driven from the Sheet itself or if you could insert an object with an OnClick event ... which in turn would run a Macro ... With the addition of that feature complete applications could be built using ZOHO Sheet ... Currently I provide Excel Applications to companies and that is about all I see that would needTags
1. Is there a way to have tags window open all the time? 2. How does one search tags? ThanksZoho Sheets Bugs
I am experiencing Zoho Sheet as a very unstable and fragile app and it has not improved since I firstly tested it several months ago. When I used it recently I experienced the following difficulties: Server Error messages when attempting to hide a column.Zoho Sheets Arrayconstrain
Hi, I'm using functions that output arrays. In Google Sheets I usually wrap them in array_constrain(array,limit) which makes them not take up all available space. Is there a similar function in zoho sheets? Example from Google sheets =array_constrain(ArrayFormula(sumif(B2:B,H2:H,C2:C)),L1,1)Restore deleted spreadsheet
Hi all, I can not find my spreadsheet. It seems that my spreadsheet is deleted. Please, restore the spreadsheet. Thanks in advanceInvalid API key problem
Dear Zoho team, I recently used zohos API in my web site. I used the same API key for ZOho sheet , show and editor. The zoho editor opens up smoothly without any problems. However the sheet and show give me these errors. I am using the remote API method. The errors are listed below: Sheet: RESULT=FALSE ERROR_CODE=2890 WARNING=The api key is invalid. Show: RESULT=FALSE ERROR_CODE=3890 WARNING=API Key is not valid -------------------------------------------------------------------------------------------Hide Unhide Sheet
The ability to Hide and Unhide a sheet is the single feature in EditGrid that keeps me mainly working there instead of Zoho. To allow a sheet to be hidden or unhidden based on a cell content using VBA would greatly enhance your product's utility. Thank you.Scrolling with mouse wheel makes data dissappear
When trying to scroll via mouse wheel, spreadsheet gets blank. Refreshing the tab gets data back.Tip #1: Handy shortcuts to move around your spreadsheet
No matter the application, keyboard shortcuts are always a great way to save time and make you more productive. Here are a few quick key actions you can use in Zoho Sheet to navigate within your spreadsheet. Moving to the next cell (Tab, Enter, Shift+Tab)External Data connections change cell addresses to row zero on their own.
I set up an external data source at a specific cell on a sheet only for external data. If the link is set up on A2, it later moves to cell A0 on its own, ruining other cells that are referencing A2. Also you cannot even remove the bad link. I don't knowIs there a forumula to create calendar in spreadsheet?
I'm looking to create my own 2011 calendar to print but I am looking for a way for Sheet to create the calendar for me so I can then just format, design and print. Is this possible here?import from url
In google sheets i can import an html table from a URL, if I do the same with Zoho sheets I get 'URL not reacheable'. I can't find any information on this so I'm not quite sure why. Any comments or advice welcome.How can I turn off e-mail notifications in ZOHO Sheet?
I have previously uploaded several Excel sheets into ZOHO sheet and had checked the box to let me know when changes were made. I now would like to turn this feature off because it is not helpful to me any more. Can I do this? If so, where do I go to turn it off? Thank you!Use VBA to open an external file
Since I can't use a hyperlink to open a local file from within a spreadsheet, what would be the VBA code to open c:\test.pdfZoho Sheet API problem with parameter json_data
Hi everyone, When I run the following Post request through Zoho Sheet API, I kept getting error. Could someone please help? https://sheet.zoho.com/api/v2/p5gob655bd7aexxxxa446c9a7bfe03109aade3?method=worksheet.jsondata.set&worksheet_name=Sheet2&json_data=[{"Name":"Joe","Region":"South","Units":284,Organizational Charts
Hi, I usually create org charts in excel using shapes. Since Sheets does not have Shapes function, does any one have any suggestions on how to create an org chart in ZoHo family of apps? thanks DavidValue of last populated cell in a column
Hello: I want a formula to return the value of the last populated cell in a column. In Excel and Google Sheets, the following formula works. =LOOKUP(9.99E+307,F:F) However, in Zoho, this formula returns the largest value in column F, not the last value.Why is "Generating Preview" freezing/ go blank when I try to Print?
In Zoho Sheets, when I go to print it freezes when it's trying to generate the preview, and I cannot print or save as PDF. I've tried refreshing the page, restarting my computer, logging out/in, using a different browser... still stuck with a blank screenHow to add a hyperlink to a cell or image? (Not text)
Hi, Is it possible to add a hyperlink to an cell or image? And as a follow up question, upon pivot table creation, will the image/cell with link be taken into the pivot table? Thank you, TiemenNext Page
Access your files securely from anywhere
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
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)Data 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 Developer Community
Zoho DataPrep Resources
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
Zoho Campaigns 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
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
Vinoth Kumar K
Mehnaaz T
kvansensie