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.Sheets - Data Validation not working properly
Hi there, I have a document with approx. varias sheets in it. The information input into 3 of these sheets is sent to its respective Pivot Table. Another Sheet has 3 columns set up with Data Validation pulling the information from the pivot tables.Sheets - Return to last cell
I can see in the URL for sheets, that the end of the URL points to the sheet and range in the sheet. Is there a way to have the URL return you to the last cell you were working on after exiting and reopening the sheet?Drop down menu in Zoho Sheets
Hi, I was wondering if (like in Microsoft Office Excel) you can create drop down menus' in Zoho sheets. If so how do I do it? Cheersexporting as pdf not working fine
I did try to export sheet as pdf and not working properly. please fix this. vikybossMore colors
Hello, Help me understand, while working with sheets, I go to "more Colors" select a color I like and use it in my spreadsheet. However, once I close out that sheet then later reopen it, the color I selected from more colors is not there. Why and whatAnnouncing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet
We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant. Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input. Once you allow access to the sourceZoho sheets not loading
When I try to open certain sheets from the list of zoho sheets I have few that will work perfectly whilw others will end up in a blank white screen.New look, improved usability, and more: the exclusive Zoho Sheet app for iOS and iPadOS
We are constantly working on improving the Sheet mobile app and its usability in terms of speed, design, features, and overall performance. With these aspects in mind, we are excited to announce an exclusive Zoho Sheet app for iOS and iPadOS that willTab Colors and New Currency Symbol of Indian Rupee
Zoho Sheet has recently added support for the following 2 new features: Tab Colors: Since last month, you can set a color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. This option is available on the right click context menu of the worksheet tab. Add color to your worksheets! Indian Rupee Currency - New Symbol: The new Indian Rupee Symbol, ₹, is now supported in Zoho Sheet. This replaces the old "Rs." currency symboljava.lang.Object cannot be cast to com.tripi.asp.Node
Good afternoon to everybody. I have some arrays which its type are Variant. They came from another function. I need to pass those arrays to another function or subrutine, but when I try to add them throught a parameter, the program crash and give me theIndent in Zoho Sheet
Has Zoho added Indent to Zoho Sheet? There hasn't been any discussion about this since THIS post.Zoho Sheet API—Deprecation of Authtoken support
Hello all! For the attention of all users who are currently using Zoho Sheet's API with Authtoken for authentication. We will be terminating the support for Authtoken soon. Please migrate to OAuth 2.0 for a more secure and seamless working. Authenticationcan i create folders?
Good Morning. using vba I need to create a PDF copy of the Sheet and save it in a new folder. Is that possible? How can i create it??Formula returning unique values from list
I'm trying to create a formula returning unique values from a list. I found an Excel solution here: https://www.myonlinetraininghub.com/excel-extract-a-unique-list and tried to reuse it in Zoho Sheet, but the results are different (see screenshot below).Expanding and securing ways to share your spreadsheet: email as attachment and password protection
While Zoho Sheet allows you to share and collaborate with your colleagues in real time, you might wish to send your spreadsheets as email attachments or keep an offline version of a confidential file with password protection. Here's how our new optionsPage Break
Is there a way to set page breaks in Zoho Sheet. I couldn't find anything about it on the board.short cut keys
hi i want to short cut keys of spread sheet and formula nanda83_bУравление доступом
Как можно управлять владельцами. А именно удоляль добовлять. Прото иногда нужен полный доступ к изминениям. А потом нет.Hyperlink Formula coming up with #NAME! in Zoho Sheets
Hi, I'm trying to add hyperlinks to my spreadsheet using the formula: =HYPERLINK(https://www.google.com; [Google]) But it's coming up with #NAME rather than in this example, Google. Is the way I've typed it wrong or is this an issue with Zoho Sheets?Delete Rows from Spreadsheet that contain specific Column Text
Hi All, I simply want to delete any row in a spreadsheet that contains an identical column value. My spreadsheet contains >3000 rows so I am not going through each row to manualy delete. Kind Regards ColinFind values in another sheet by column header
I import data from other spreadsheets and then process that data in a new sheet. The data comes in different formats every time, but the column headers are always the same. In other words, the columns are always in a different location, but the firstLET, IMAGE, and two other functions to make things simpler
Zoho Sheet supports more than 400 functions to help you perform mathematical, financial, and other analytical operations. Now, we're adding four new functions to help you build spreadsheets that are more self-explanatory, more reliable, and most importantly,How to use vba to import external data in which the link change everyday in the spreadsheet?
In the introduction of the vba page https://vbmacros.wiki.zoho.com/Welcome.html, there is an example stated: fetching live stock data from an external website -> populate the data to a cell range -> format the data in an aesthetic way -> and, repeat these tasks daily in a scheduled manner). I wonder how to do this. As I want to fetch about 100 stock price from yahoo. I can get the stock price by the add query in Excel then I can also delete the connection to make the spreadsheet faster. However,Maximum # of Rows/Columns
Hello, Can you please let me know the maximum number of rows and columns for one spreadsheet? Thanks!Link to External Data Deleted
I have a Zoho Spreadsheet that I need to periodically (at manual intervals) re-import data from an external source. When I create and "Run Once and Done" the link it keeps it in the link history. I can then go back under "Manage External Links" and "refresh" that link when I need to. However, I have found that what appears to be about 1 month after creating the link, it then disappears from the list of links available in "Manage External Links". I then have to hunt up the URL again and recreate theIs there any way to save a zoho sheet as PDF in Workdrive using VBA?
Dear All, I am trying in a zoho sheet to create a button and with VBA to save this zoho sheet as PDF in a specific Workdrive folder. I have found some examples like the below but first of all the 'ExportAsFixedFormat' returns me unknown function and ofExternal Data Links do not update on Schedule (refresh does not work)
I leave the spreadsheet open so the data refreshes once per day.... but I manually have to do it.... My "Expectation" is that the external link data would update automatically in the cells and "Replace" the old data within the same cell. However, whenHow do you insert image into cell?
Hello, I'm new here. I import my Google spreadsheet and I realize the images were gone came along with it. ( Is there a way to fix this problem? ) So I would like to to know how to insert image into a spreadsheet into cell, like in Google Spreadsheet. ( I know how to insert an image here but when I do, it over the cell, click attachment to view ) is there something like fit- in-cell or when you right click on a cell insert option > add image?scatter line chart x axis range displayed
I have 2 spreadsheets, each with data in the x-axis range of 0 to 400. In one spreadsheet, the chart displays 0 to 500 (400-500 has no data). In the other spreadsheet, the chart displays -100 to 500 (no data for x -100 to 0, and 400 to 500). I don'tRefering cell from other sheet
Hi, If we want to refer any cell in the same sheet its very easy, like suppose if I want to refer cell A2 in P7 I just need to type =A2 in P7, similarly how can I refer a cell present in different sheet ( I mean refer cell A2 from Sheet1 into Sheet2) ThanksShow the bigger picture in small spaces: Add images in cells with Zoho Sheet
When used correctly, images and infographics can add so much value to a spreadsheet. Zoho Sheet previously had an option to insert images into your spreadsheets, but now we're taking it a little further: You can now insert images into a particular cell!Display text the preferred way with text rotation, indent, and wrapping options
Working with long, textual data in spreadsheets just got better! Zoho Sheet now supports text rotation, indentation, and wrapping options, which you can use to display the text and other values in your spreadsheet exactly the way you want. Set the rightWeird bug with API
Good afternoon, I may have found a very strange bug. On a blank sheet named "test", I create 3 columns with headers in the first row : "type", "color" and "check". I input values for 2 rows : "car", "blue" for the first row, "car", "yellow" for the secondHow to reference a cell from another zoho spreadsheet?
Is it possible to reference a cell in another zoho spreadsheet? E.g. suppose I want to have a payroll spreadsheet for each of 5 employees that they fill out. Their info goes onto my master spreadsheet, pulling the info from their spreadsheets. Is this possible in zoho? How would I find out the syntax to refer to a cell in another spreadsheet? Thank you.To err is human: Let Zoho Sheet's Spell Check handle typos for you!
Working together with your team under a tight deadline, without a lot of room for human errors? No matter what field you're in, misspelled words and typos make your otherwise splendid spreadsheet look a little unprofessional. Worry not! Zoho Sheet isExcel Formula is Resulting in a #N/A! Error
Hi! I just converted my current excel work book to Zoho Sheet and I am going through the process of debugging. I have a formula that I currently use in excel that looks up the text in a column and a numeric value in another row. The formula should allowSharing only one sheet from a workbook
Hi, I have a Workbook with various sheets, but I need to share Sheet 1 with one user and Sheet 2 with another user, I dont want the users to see each others information. I want to be able to consolidate the data from different users in one consolidated sheet only for my analisys. Is this possible at all? is there any work aroud this issue? Regards, Kioumars B."Sorting cannot be performed on a range containing checkboxes"
I need to use checkboxes in my data, but also need to be able to sort the data. When will it be possible to do that?Updating cell value using VBA resets cell formatting
There are cells in my sheet that contain dates, which I have formatted using custom formatting to adjust their appearance. I also have a macro that updates the value of the cells with an adjusted date. When the macro is run and the date changes, the customNext 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