Insert/Delete Table Rows macro
Anyone know how to write macros to insert or delete table rows? I use these buttons in Excel all the time for expanding/shrinking BOM tables. I tried recording a macro. But, it is empty after performing the insert table rows command. Looked into writingHow to add url to macro
have an idea how to add the weblink: https://onedrive.live.com/?authkey=%21AHc4H6gbexVr9f0&id=6B86D5C26B3B694B%21156&cid=6B86D5C26B3B694B&parId=root&parQt=sharedby&parCid=BB6DC96E46411881&o=OneUp to the macro?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 #7: Four things you didn't know you can do with Conditional Formatting
Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which areBitcoin
How can I get the current price of Bitcoin using a function similiar to the "stock" function?How can I insert a row into one sheet automatically when a row is crated in another sheet?
I use a sheet to keep track of service requests that are entered via a public form. One of my customers wants to use an API from their system instead of filling out my public form. They want to directly create rows in my sheet from their system, and weBuild readable, reusable custom functions with LAMBDA()
LAMBDA, the new addition to Zoho Sheet's function gallery, has the potential to change the way you work with formulas in your spreadsheet. The function helps make your formulas more readable and reusable. You can create custom functions that fit yourZoho sheets into a tab in teams?
Hi I was wondering if anyone knew a way I could display a zoho sheet into a tab in microsoft teams?Introducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient textRequest for access
Hi everyone. Please help me. When I try to access a spreadsheet that a friend sent me by link it doesn't open, it says I'm not authorized to access the spreadsheet. Please help me. Thank youWill Zoho sheet continue after March 15, 2023?
Hi Team Zoho. I heard that zoho docs will be discontinued after March 15, 2023. I just want to make sure that it is zoho docs but not zoho spreadsheet. Please clarify. Thanks.Can Zoho be accessed/used in China?
I'm looking for an alternative to Google Docs (Spreadsheet specifically) that can be used in China. Can Zoho be accessed by users in China?#CIRCULARREF!
How come im encountering #circularref! error. i double checked the formula but they are correct. It seems that the synchonization to the server has an error. Thank youPerform customized calculations with the new LAMBDA functions!
We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performsDate Format - YYYY-MM-DD
Why in the work would Zoho Sheets not support the date format YYYY-MM-DD - pretty universal - no confusion - and especially for data in a spreadsheet - can be sorted properly Blows my mind that this setting does not exist, or I can't find how to turnSheets date format dd-mm-yyyy - time, it seems, is at war with me.
Hi, I'm trying to set the format of a column to the date format we use here: dd-mm-yyyy. Unfortunately, this format does not show up in the options. There's no specification in Settings to specify it either, I can't seem to set a custom format, and whileCustom fonts are not exported in PDF
Hi! When I download my spreadsheet, the custom fonts I uploaded and set are all replaced by the fallback fonts. Why is this happening? I hope this can be fixed.Issue with API worksheet.records.add
Hello I am having an issue with using the method "worksheet.records.add" I am currently getting a 400 error. As a note, I have successfully gotten an access token (and get a new one every time I start a new session) and have successfully been able toNamed ranges will disappear from the sheet
I encounter this when attempting to delete one or more named ranged from the defined names in the management box. It's hit or miss; some range names that I deleted several times, keep reappearing and others that I wanted to keep will be deleted. WhenThe opposite of QUOTIENT or a non-destructive alternative?
I hope I'm not asking a too dumb of a question, but I'm trying to use the equivalent of DIVIDE, which according to the Knowledge Base is QUOTIENT. However, QUOTIENT seems to round the numbers down, as if it had ROUNDDOWN applied natively to the result.Unable to share a sheet.
Hi, i was trying a sheet with some of my collogues, they are registered on Zoho sheets with their email still when I try to share the sheet I get the following error. Share with non-Zoho user? You are about to share this file with @gmail.com who doesData Entry Form?
https://help.zoho.com/portal/en/kb/sheet/working-with-forms/articles/create-a-form-in-zoho-sheet Is it still possible to create a data entry form using ZOHO Sheet? I referenced the link above and I d o not see this option? ThanksCan I share my Zoho spreadsheet with others
As a data entry professional, I utilize Zoho for my work and I'm interested in knowing if I can share my Zoho spreadsheet and database with basketballist company. If so, I would like to know the steps involved in accomplishing this task. Any guidanceRestrict access to one spreadsheet
I have a file with three sheets . Each sheet is for a particular individual to enter data. how we restrict the user to view the other individual sheet except the ownerwhat is the zoho sheet formula equivalent to this google sheet formula?
In the google spreadsheet this is what I have I have forumula in column K: =unique(B2:C) Then I have formula in Column M: =map( filter(K2:K, len(K2:K)), filter(L2:L, len(K2:K)), lambda( model, trim, torow(filter(C2:G, B2:B = model, C2:C = trim)) ) ) WhenCustomize 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 macroDisable download, Save As and copy option in sheets
Hi I am a free tier user. I was just testing out Zoho sheets for my use case. I wish to move my data from Google sheets to Zoho sheets. The problem is when I share a sheet with view access only to other user who has a private email like gmail, hotmailOffline Editing and Access
I can't seem to find how saving your sheets offline works. I don't see a button for it anywhere.Sum through multiple sheets
Don't believe this command works in Sheets sum(sheet1:sheet6!A4) Would be nice to add. Every time I click on sheet3 it moves to that sheet instead of treating it as a formula inputzoho sheet - How do I create a list of values to choose from in zoho sheet
I want users to choose only a value on a list of items (as you can do in Excel). Can I do this in zoho sheet?Putting Watermark on Zoho Sheet
Can this be done?Scatter graph when x-axis is time becomes a line graph/chart
The difference between a scatter graph and a line graph is that the x-axis should be mathematical. Ie if the X data points are 1,2,4 , the '4' should be 2 intervals away from the '2'. On a line graph, they would be next to each other and equidistant toIs it possible to share my Zoho spreadsheet?"
Hello everyone, I am a data entry professional and I use Zoho for my work. I would like to know if I can share my Zoho spreadsheet and database with a wordparadox company. If so, how can I go about doing this? I appreciate any insights and advice. ThankTip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.Editable sheet but can not distribute, save or email or etc...
Is this possible? I want the file to save in its existing location. But not for the user to be able to save a copy etc... this is disastrous. Is this possible? I can see that this has been asked in various forms up to 9 years ago and as far as I can tellImages Stored in Zoho Workdrive not displaying in Sheet after putting the image URL
I have generated a form from which images are uploaded onto zoho workdrive & the image URL is stored in a ZOHO Sheet. Now when i try to Display the image it shows a broken image link. When I try to go insert Image from the insert from URL, in the dialogHow to add a Trendline to a chart inside sheet?
Hello Zohos I am very please with the improvement of Zoho Sheet since I used it last time Im still missing one thing that I easily have access to in MS excel : Add trend trend line I found a way to calculate the regression line by: =FORECAST =SLOPE =RSQ But I'm pretty confused how to get the line on the chart with the data. Are there any solution to this?Introducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youZoho Sheet - No filter() function
Hi! There is no filter() function in Zoho Sheet. I attached a few print screen where you can see there isn't a function named 'filter'. I really need this function because right now i need to transfer all of my data into Google Spreadsheet to use fiWe'll be right back - URGENT
Hi, It has been like this for hours. Some sheets load and some don't. Sometimes the sheet opens, but it's empty. Thank you!Next Page
Announcements
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 #7: Four things you didn't know you can do with Conditional Formatting
Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which areBuild readable, reusable custom functions with LAMBDA()
LAMBDA, the new addition to Zoho Sheet's function gallery, has the potential to change the way you work with formulas in your spreadsheet. The function helps make your formulas more readable and reusable. You can create custom functions that fit yourIntroducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient textPerform customized calculations with the new LAMBDA functions!
We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performs
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM 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
Zoho Desk 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.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Most Discussed Topics
Introducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient textInsert/Delete Table Rows macro
Anyone know how to write macros to insert or delete table rows? I use these buttons in Excel all the time for expanding/shrinking BOM tables. I tried recording a macro. But, it is empty after performing the insert table rows command. Looked into writingHow to add url to macro
have an idea how to add the weblink: https://onedrive.live.com/?authkey=%21AHc4H6gbexVr9f0&id=6B86D5C26B3B694B%21156&cid=6B86D5C26B3B694B&parId=root&parQt=sharedby&parCid=BB6DC96E46411881&o=OneUp to the macro?Date Format - YYYY-MM-DD
Why in the work would Zoho Sheets not support the date format YYYY-MM-DD - pretty universal - no confusion - and especially for data in a spreadsheet - can be sorted properly Blows my mind that this setting does not exist, or I can't find how to turnWill Zoho sheet continue after March 15, 2023?
Hi Team Zoho. I heard that zoho docs will be discontinued after March 15, 2023. I just want to make sure that it is zoho docs but not zoho spreadsheet. Please clarify. Thanks.
Sticky Posts
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 #7: Four things you didn't know you can do with Conditional Formatting
Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets. If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats: Customize rules with formulas Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which areIntroducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient textTip #15: Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired output value when the input values are not known. In other words, Goal Seek does back-solving to find input values once you've provided an output value.Introducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
Top Contributors
Narendra Eswar G
Samuel Ponraj P
Vinoth Kumar K
Robert Tupa
Rohith V K