Sheets oauth scopes
Is there a list of OAuth scopes I should use for API access to Zoho sheets?Zoho Sheet Embed options
I would like to be able to embed an active sheet into a web page, i.e visitors to the page can enter data to see changed results but cannot edit the sheet in any other way. Regards PETER J WILLS Business Consultant & Adviser ABN 53 964 553 113 www.bcaservices.com.au pjpw2320How to combine multiple sheets in one IMPORTRANGE?
in Google Sheets and Excel, there is option for this and it is helpful in extracting data. Does Zoho Sheet also support multiple importrange? If so, please help me.Split date and time with space as delimiter
I am trying to separate the date and time in a cell into 2 separate columns. The value in the cell is Mar-25-2021 13:46:49. I want the next column to show Mar-25-2021 and the 2nd column to show 13:46:49. The split function that I normally use in GoogleUsing a Macro as a Function Called From Cell to Populate a Cell Value
I'm trying to populate individual cells with function calls to a macro similar to how one would use a regular function to populate a cell. My function is: Public Function getHours(item As String,high As Number) As Double Sheets("Work Items").SelectDuplicate a Spreadsheet
There are 2 ways to duplicate a spreadsheet in Zoho Sheet . 1. Using 'Duplicate' Option : Click the 'Show Sidebar' arrow or Press Ctrl+O to open the sidebar. Click the Actions icon of the corresponding spreadsheet name and select the 'Duplicate' option from the dropdown menu. A new copy of the spreadsheet will be created with a name in the pattern 'Copy of <original spreadsheet name>'.For example, when you duplicate a spreadsheet named '401K Planner', a new copy of the spreadsheet will be createdZoho Spreadsheet New Line Shortcut?
When I use Google Sheets I can press: CTRL SHIFT and + ..to create a new line. When I try to do the same in Zoho, I get a message: "Column limit exceeded" Is there a shortcut to create a new line?Spreadsheet VBA not working with same VBA code used in Excel
I uploaded my excel file to zoho and wanted to run the same file here. The problem is that it gave me errors regarding the vba file. The error was with "inputbox" function used in the VBA code. Now either zoho vba uses a different function for "inputbox" or i dont understand whats wrong. The reason for the vba code was to get data from a public xml api to that spreadsheet. So please help me out.Is it possible to publish a spreadsheet to a website?
Hi, I'm new to Zoho and investigating if it will allow me to do what I'm intending. I'm creating a solar system generation calculator in spreadsheets that I want to publish to a website. Is it possible to do this? The sharing feature seems to only let you share with other Soho members.Open files Very slow
Hi Compare to gDrive, sheet opening seems to be slower I wait a long time and made a little screen to show you (I started and stopped before the endIf (Cell) Than (Text)
Hi how do I use this formula in Zoho sheet? =IF(B4="true";"part1";0). I'ts not giving me the result. Please HelpDouble Quote in the Concatenate function
Hi I am trying to put double quote in the concatenate function (something like -> I prefer something "sour" when it comes to deserts. I tried putting two double quotes, didn't work. I also tried putting \" also didn't work (somehow, it would add one more bracket at the end when I put \" Can someone tell me how to resolve this, thx in advance.How do you enter numbers as text?
I've imported an existing spreadsheet with cells that have numbers as text (they're id's and should NOT be treated or formatted as numbers.) Zoho sheets handled this correctly (yay!) But I can't figure out how to enter new ids. In every other spreadsheetVBA Find and Replace - "Replace" button changes next "Find" result, not the text currently highlighted
I just tried to use the Find and Replace functions in the VBA Editor to change some variable names I had used in my macro code. When I enter text in the find box and search for it using "Find", the text is found correctly in the code and highlighted.Zoho Sheet redirected to "Zoho WorkDrive - Create Team" dialog, now I'm signed up for something I never agreed to
A short while ago I tried to open one of my spreadsheets via the web on a Windows PC, and I couldn't. No matter which of my bookmarks I clicked, the spreadsheet wouldn't load and instead a prompt appeared asking me to choose a team name. I don't mindVBA Script will not stop running
I have a script to clear checkboxes in a range and it works perfectly, except it will not stop. After it runs I want to be able to use the checkboxes again for calculations, then run the macro to clear them, then reuse the boxes as needed. As it is writtenSheet doesn't display correctly after macro runs
Hi there, I'm using the following code as part of a macro in one of my sheets, to record information from one worksheet into another: Sub LogTaskComplete(ByVal taskName As String) Dim currentSheet As String currentSheet = ActiveSheet.NameError message trying to open spreadsheets
Hi, I am receiving the attached message with I try to open all but one of my spreadsheets.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 firstNext 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
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfCopy across spreadsheets in Zoho Sheet
Now, you can copy your sheets to other spreadsheets or create a new spreadsheet with them. Not just sheets, copy a cell/range and paste it on any spreadsheet with formats and formulas unchanged. Copy cells/ranges Copy cells/ranges to same/different spreadsheets using Copy & Paste options, or Ctrl+C and Ctrl+V shortcuts. Copy sheet To the same spreadsheet The feature for creating a copy of a sheet in the same spreadsheet is now available as 'Duplicate'. Into a new spreadsheet Want to start a new spreadsheetRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #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 sampleTip #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
Most Discussed Topics
Does Zoho Sheet "Save as PDF" support Thai font?
Hi I want to download Zoho sheet as PDF Document. In the preview it looking good but when I dowload it the font is look different. I use "Cordia New" but the result look like it swtich to "calibri". I try to use "Print" then select printing destination
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
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
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.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 Format