Hiding/Deleting blank rows and columns Zoho Sheet
How do you do this?link to specific tab
Hi I have a zoho spreadsheet with 20 tabs. I am trying to link from an outside site to a zoho spreadsheet's specific tab. Eg. link straight to Tab1. Right now all I can find is a general link to the spreadhsheet, but then the user needs to find the correct tab and click it to get to that tab. Is there a way to link directly? ThanksGoal Seek using VBA
Hello, I noticed from previous posts that Zoho intends to add Goal seek using VBA. Is this possible yet? Please provide an update and if possible the code to get goal seek to work via VBA. Thank you.Sharing sheet without affecting original spreadsheet
I want to share a sheet using a password unique to the end user who will be able to enter data that will help them make a decision. I don't want or need any changes to show up to original file inside my Zoho account. I will be sharing this sheet overcustomize menu icons
This seems like it ought to have a simple solution, but how can I add (unhide) the filter icon so it is visible from the main toolbar?Comments aren't visible in shared spreadsheet
I would like to send a spreadsheet to people who can use it to help solve a problem as a one off use unique to them. They will have to enter data in the sheet. I have comments attached to some of the cells to explain the purpose of the data being collected.Find & select empty cells in a range
Are there any good ways to help me find the empty cells and select all of them in a certain range? In Microsoft Excel, there's a function in the toolbar that allows me to achieve this goal.link to external data split cells
Zoho Sheets - External Data Link - Split Cells Problem I have links to external data... however, when the data updates.... It automatically adds new rows and cells.... I would like the data to regenerate in the same cells.... can someone please help meUsing wild cards in VLOOKUP
In excel this works but not is sheets can anyone confirm or suggest another method. =VLOOKUP("*"&B1&"*",A:A,1,FALSE)Setting default fill color
Using Zoho Sheets, I have an extra color in my "other used color" in the color fill drop down as shown here (blue arrow) and this color is always the default color when filling my cell: 2 questions: 1. How do I remove this other color? 2. How do I set the default color? Right now, it defaults to this color and I'm constantly having to change the color to the one I use most often. Thanks!Sending a set of cells by email
How do i send a selection of specific cells with the code below? Public Sub SendEmail () ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array ("xxxx") 'Digite os ids de e-mail separados por vírgula .Subject = "xxx"' Digite o assunto aqui .Message = "xx" 'Digite sua mensagem aqui .AttachWorkbook = False End With ThisWorkbook.Route End SubWhere is the spell checker in Zoho Sheet?
I cannot find a spell checker in Zoho Sheet. I did find a 4 years old post asking the same thing with a reply stating it will be added in a future release. It's difficult to understand why after 4 years there is still is no spell checker in Sheets.....or am I missing where it's located?How to automatically go to the bottom of a Zoho spreadsheet when opening the file
Is there a way to open a Zoho spreadsheet and have it automatically go to the either the bottom row that contains any sort of text or formula? It would work fine if it simply went to the "lowest" row for Column A that contains information. I do see you can use the URL to go to a specific cell (and probably a named cell as well) but I haven't found a way to do what I'm asking. The spreadsheets are fairly dynamic and information is added to them frequently. Another thing that would work wouldHow to stop scrolling of zoho sheet embedded in a website
I am using zoho sheet as a calculator. I embedded the following html snippet in this website. <iframe width="500" height="400" frameborder="0" scrolling="no" src="https://sheet.zoho.com/publish/rfcircuits.info/pi-match-lp2"> </iframe> The width and height of iframe are adjusted to exactly match the dimensions of the sheet. But even with scrolling="no" option, the sheet is scrolling after embeding in the webpage. Is there a way to avoid scrolling of the sheet inside the web page or atleast hidingIf(AND...) Function - How to Format
Hello, I use the following function in Google Sheets =if(AND($AA18<>"CLOSED",$AA18<>""),GOOGLEFINANCE($B18,"price"),"") Why will it not work in Zoho Sheets? I get this error. =IFERROR(__XLUDF.DUMMYFUNCTION("if(AND($AA18<>\"CLOSED\",$AA18<>\"\"),GOOGLEFINANCE($B18,\"price\"),\"\")");2.65) Thoughts?If(AND...) Function - How to Format
Hello, I use the following function in Google Sheets =if(AND($AA18<>"CLOSED",$AA18<>""),GOOGLEFINANCE($B18,"price"),"") Why will it not work in Zoho Sheets? I get this error. =IFERROR(__XLUDF.DUMMYFUNCTION("if(AND($AA18<>\"CLOSED\",$AA18<>\"\"),GOOGLEFINANCE($B18,\"price\"),\"\")");2.65) Thoughts?Linking Workbooks Together
I have a sheet with 4 workbooks in it. Sheet 1, sheet 2 sheet 3 and sheet 4. What I am needing is to set a patter in workbook 4 that is goes down the rows (sheet 4) as Row 1: =Sheet1.A2 Row 2= Sheet 2.A2 Row3= Sheet 3.A2 Row 4= Sheet1.A3 Row5=Sheet2.A3 Row6= Sheet3:A3 and the pattern on and on. When I keep dragging I will get a few in a row then skip then a few in a row correctly. Is there a way to get this pattern to allow me to just keep dragging down as needed?cursor moves bij re-open file
When I open(phone) a sheet, the cursor stands always at the begin of the file. For example: I close a file while the cursor stands on G278. When I re-open the file, the cursor appears at the beginning of the file instead at G278 where he was closed. Can you help me. Can I change that?When copying a Zoho sheet file within Zoho, the copied file loses its data validation and conditional formatting
Hello, When I copy a Zoho Sheet file (which contains some cell data validations, conditional formatting and simple formula's) within the same Zoho project folder, the copied has lost it's data validation on some fields and in some cases the formula's cell references have been incremented, meaning I have to do redo a lot of the work again. Is this an existing issue or is there another process I should be using within Zoho when copying files? Many thanks!How can I print the notes inserted in the cells in Zoho Sheet?
Is there a way to print the notes inserted in a Zoho Sheet documents?Read/Write access user unable to see data
I have a spreadsheet that has two Read/Write access users. They add data entries to a sheet, which has formulas flowing into summary sheet. Until yesterday, the two users were able to see the data on the data entry sheets, but all the sudden from today, both users wasn't able to see any data above certain row on that sheet. Any suggestion on how to resolve this is welcomed and appreciated. Thank you in advance.Shared user can't see certain records
Hi I have a shared spreadsheet with two other read/write access users. In the spreadsheet, there is a sheet that is data entry sheet that one of the user inputs data (we will call her User A). Few days ago, User A all the sudden could not see any data above a certain row (but can see row 1 which is the header row) that she inputted. The rows were not hidden or filtered. However, when the data is copied over to a later row in the sheet, user A can see it. User B (the other user with Read WriteRead/Write access users can't see data
Hi, I have a spreadsheet that has two read/write users added. They add data entry for me and I review them online. We haven't had any issues on it until today, and all the sudden, the both read/write users can no longer see the data that's in the spreadsheet above certain rows. They were able to see it fine until yesterday. I as an owner can still see all data on the spreadsheet, and the rows are not hidden or filtered or anything. Please let me know if you know how to resolve this issue.Expand / Collapse Rows in Spreadsheet
I'd like to be able to collapse rows of categorized data so that I can more easily see all of the categories, with the ability to expand them to see individual rows. When I search, I find this demo, but with no explanation of how to make it https://docs.zoho.com/sheet/published.do?rid=mr778aae12b194b91414e9c4990cfc03e0bd5 For example, this list Item Style Qty Price Total Apple Green 4 0.49 1.96 Apple Red 9 0.35 3.15 Apple Yellow 7 0.49 3.43 Grape Red 100 0.05 5.00 Grape Green 150 0.04 6.00 Totalreplace existing
When I would upload a file to Excel online it always ask me if I want to replace the existing file. I don't see this feature in Zoho and was wondering if there is a setting for this. BruceLink two Zoho Sheets
Hi I apologise in advance if this has already been asked, however i couldn't find it anywhere. I have data in one Zoho sheet and i was wondering how i get that data into another zoho sheet without losing the data in the original sheet. In excel i would have linked by '='Sheet Name and cell'. If someone could let me know how i do similar in Zoho it would be much appreciated. Thanks in advance. RPrint Preview and Page Breaks in Sheet
Have Page Breaks and Print Preview been developed for Sheet?Error In Cell Function
Hi Guys, I need to store Filename inside cell, I used "=CELL(FILENAME; A1)" formula, but I'm getting error "#NAME!" . I got that formula in the Zoho Sheet Documentation. https://sheet.zoho.com/sheet/functions Please help to resolve this issue. Thanks in advance. Regards, TermconPrint with Gridlines
Is there a way to print the spreadsheet with grid lines automatically instead of having to manually add a border for each cell that is printed?Send workbook draft attachment through email
Hi I love your platform, i saw a code to send the worksheet as an attachment through email like this ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array("xxx@yyy.com","zzz@yyy.com") 'Can send mail to multiple recepients .Subject = "Task completed" .Message = "Mail content" & Target.Row 'Sending cell value in mail '.AttachWorkbook = False ' By default the file will be attached in the mail. If it is not needed then send ' .AttachWorkbookSending email with ThisWorkbook.Route problem
Hi i love your platform, i have this code: Public Sub email() ThisWorkbook.save ThisWorkbook.HasRoutingSlip = True With ThisWorkbook.RoutingSlip .Recipients = Array("gfdsgdsf@dsf.com") .Subject = "l" .Message = "" .AttachWorkbook = True End With ThisWorkbook.Route End Sub The problem is, when i am loggen in it works, but when i am logged out it gives an "unknown error" on the ThisWorkbook.Route line and the email isnt sent can this be fixed? Thank you very much.Indian Mutual fund tracking
Hi Friends, Is there a way we can track Mutual Fund investments in ZOHO sheets automatically?"unknown error" on vba script
Any idea why I get "unknown error" on line 32? Option Explicit Sub updateCSV() Dim wb As Workbook Dim ws As Worksheet Dim newWS As Worksheet Dim i As Long Dim z As Long Dim lr As Long Dim desc As Variant, created As Variant, amt As Variant, fee As Variant 'Set Objects Set wb = ActiveWorkbook Set ws = wb.ActiveSheet Set newWS = Sheets.Add 'Vars -> Assumes headers are in row 1 desc = Application.Match("Customer Description", ws.Rows(1), 0) created = Application.Match("Created (UTC)", ws.Rows(1), 0)Insert Current Date and Time
Here is a quick tip on inserting the current date and/or current time inside a cell. Select a cell where you want to insert the current date/time. Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. To insert both current date and time inside a cell, press Ctrl+; followed by a space and then press Ctrl+Shift+; Note that this is a static date/time and the value will not change as time passes by. However, if you want to have the current date or time to be automaticallyImportrang
Any small business that runs its business with spreadsheets will always use importrange to consolidate data. Why Zoho is not included this at all?CONECT 2 SPREADSHEETS IN ZOHO SHEETS
Hi I have a document called "Insurance", and another called "database". What I want is that the information in some of the colums of the document "database" transfer the information to the document called "insurance" in a way that when I write something in "database" automatically the document "insurance" get updated. How can I do this?Tip #4: Five important statistical functions, and when to use them.
=AVERAGE (number1; number2; ... number30) The sample mean is probably the easiest piece of information one can extract from a data set. To calculate sample mean in Zoho Sheet, all you have to do is key-in =AVERAGE and select the range of cells you'd like to find the statistical mean for. Zoho Sheet supports a few handy variations of the average function as well. =TRIMMEAN (number_list, fraction) Say, for instance, you want the sample mean. However, you want to exclude the maximum and minimum valuesCopy 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 spreadsheetImportrange Essential But not in Zoho
Any small business that runs its business with spreadsheets will always use importrange to consolidate data. Why has Zoho in the 4 years since this request was posted not included this at all? Some of us only need simple spreadsheets to run our businesses. If you are really for businesses, then this is a functionality you would put on your TOP PRIORITY LIST! Being a competitor to Google simply means that you have to work on this. This is one of the reasons why businesses use Google Platform - toImport One Spreadsheet Into Another
Is it possible to import one or more cells from one spreadsheet into another in zoho sheets (like "=IMPORTRANGE" in google sheet)?Next 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