Allow freezing multiple rows and/or columns in Zoho Sheets.
I want to request allowing the ability to freeze multiple rows and/or columns in Zoho Sheets. As of right now, if you highlight a row or a column and right click or go to the "View" tab, you have to options to freeze one row, freeze one column, and freeze panes. The first two options are self-explanatory, but the third option allows you to freeze one section that's a total of five columns and five rows in length (i.e. columns A-E, and rows 1-5), according to a Zoho Docs representative I spoke with
How do I 'hide' a column or row in Zoho Sheet?
I have a large spreadsheet in which I would like to make certain columns (and sometimes rows) invisible. For data not frequently needed, this is a good way to increase the usability of a given sheet, buy reducing the amount of data displayed at one time. The feature must be in there somewhere, but I can't seem to find it. Can someone point me in the right direction? Thanks
Data Validation Help - Search.
Hello, I went with Google Spreasheets on Zoho Spreadsheets when I found the problem. Data Validation - here I will set everything up. Unfortunately, if I enter text into a cell, I have to enter the text exactly and I have no help as to which data is available. I have to write exactly the letter after the letter. In Google, it was enough to write a word and all the free options were offered. It's a problem when you have more than 100 options.
COUNTIF (DATE1 >=, DATE2 <= ) ??? CANT MAKE IT WORK
HI, I FOUND THIS COUNTIFSCounts the number of times each cells in all the ranges that meet the specific conditions. COUNTIFS(test_range1; condition1;[test_range2;condition2];...)test_range1 is the range to be tested. condition may be: A number, such as 34.5 An expression, such as 2/3 or SQRT(B5) A text string test_range2,condition2,… Optional. Up to 127 range/criteria pairs are allowed. COUNTIFS counts those cells in test_range's that are equal to the corresponding conditions, unless conditions are
Font Limitations
How can I add fonts that aren't on the dropdown list?
References x other Sheets
Hello , I need to create a reference in 2 diferents files ... for example: The file A contain the targets. The file B contains the sales. I need to create a reference in file A with the sales to compare with the target. or it´s necessary to create a way to import the informations to files. Other question, if the File A and File B if they were the same file but in diferents sheets, Would it be possible to create this references ? tks
Orientation
Hi, is it possible to change the orientation of a cell on Zoho Sheets? Please see screenshot (from MS Excel)
No "Hide" and "Move" column or row available?!
I just wonder if there is any "move" column/row OR "hide" is available in Zoho sheet?
Tip #2: 10 simple functions that will save you time
Functions are an integral part of a spreadsheet. With more than 350 functions available in Zoho Sheet, you might find it difficult to find ones that are useful to you. That's why we're here with a small list of simple functions that everybody can use in their day-to-day work. 1. SUM SUM is used to find the total of the given numerical values. You can save more time with the Autosum shortcut Alt+= after selecting the desired cells. 2. AVERAGE AVERAGE is used to find the mean of the given values. That
Bringing RTL to Zoho Sheet
Taking into account the request from various Arabic and Hebrew users we have now introduced RTL in Zoho Sheet where you can work from right to left on your spreadsheets. Not sure what RTL is all about? Read on to know more. Work Right to Left If you are a user of the Arabic/Hebrew locale settings, this update is sure to make your day. Working with Zoho Sheet is now a lot easier for you as the grid, column and row headers, menu tab, sheet tabs, and even the cursor will function from right to left
ZohO Download.
kinldy sort ,i cant download excel from spreed sheet.
Create a top and double bottom cell border
Is it possible to create a premade top and double bottom cell border like in this screenshot?
Upgrade to TLS 1.2 for a secured Zoho Sheet usage.
Hello everyone! Keeping your data secure has always been our top priority, and with this update Zoho Sheet takes securing your data even further. Complying with updated PCI standards, we're terminating support for TLS versions 1.0 and 1.1 starting on October 31, 2018. After this date, users must update their processing solutions to TLS 1.2 to continue using Zoho Sheet without any interruption. What is TLS? Transport Layer Security (TLS) is a security protocol that ensures a safe transfer of
Cell references change when sorting
Let's say I have a range of data A1:K20, and the formula for cell D5 is "=10+B30". If I sort that data so that row 5 becomes row 3, the formula for D3 should remain "=10+B30". It should remain this way because B30 is outside of the sorted range. This is how Excel and Google Sheets behave. In Zoho sheets, the formula for D3 changes to "=10+B28". It's acting as if I deleted two rows. This breaks the entire spreadsheet unless absolute references (such as "=10+$B$30") are used.
Data Validation for a column goes away after inserting or deleting a row
If I have a data validation applied from C1 to C100, and if I insert/ delete a row at C50. The data validation is only till C1 to C49. Inserting and deleting a row removes the data validation
How do I hide lines and columns?
How do I hide lines and columns? I cannot find instructions. Thanks for your help. Pierre
sheet gone
Hello, nearly 10 years ago I used to have a simple sheet on zoho. Now I'm looking for it and it's gone. What happened? Are there any 'backups'? BR Michael
Disable people from downloading or duplicate even they can ready only on the sheet
Is it possible? This is to prevent people from circulating the sheet around?
Sheets: Conditional formatting not working in Firefox + console log filled with errors
Where: New Zoho Sheets in Firefox 64 When opening the "Conditional Formatting" dialog in Zoho Sheets and clicking on "ok", nothing happens. Instead, two errors appear in the console: error { target: Window, isTrusted: true, message: "Script error.", filename: "https://js.zohostatic.com/sheet/Dec_28_2018_3_1979055/appsheet/Views/OWNER/initmin.js", lineno: 0, colno: 0, srcElement: Window, currentTarget: Window, eventPhase: 2, bubbles: true, … } initmin.js:15:995 TypeError: t is undefined initmin.js:6:2933
How do I speed up Zoho in China?
Speed is such a problem that we will have to leave your great product because of it. The speed isn't bad in the USA! We have huge issues in China. I tried using a product to get around the china censors which only helped a little bit. What else can I try? thanks Ken
New Zoho Sheet: Publish This Range not working and an error-filled console
When clicking on "Publish This Range" in the latest Firefox, nothing happens after pressing "Continue". THis only happens in the new Zoho Sheet version. Additionally, my developer tools console is filled with errors, primarily TypeErrors and internal errors (I assume there's some connection). Full error log (high-level): https://pastebin.com/yn0zfBa9 Relevant error (pops up when clicking on "publish this range"): https://pastebin.com/Khi09MTE (Not the full error, only expanded one level as copy()
Embed a range
Can you please tell me how I embed a range of cells rather than they whole sheet. If you cant then the service doesnt make sense Thanks Steve
How to highlight duplicate values in a list of columns?
I'm looking for a way to highlight duplicate entries in a list of columns. As an example, A1 to A20 cells - each cell gets values entered manually. If let's say a value entered at A3 is same as a value entered in A17 (as the values are entered over time, not all at one time) I'd like to highlight the cell in red. I've tried with conditional formatting but haven't found a workaround for this problem. Thanks in advance for all help in this issue.
Block users the possibility of going to a version
How can I get my spreadsheet users back to an earlier version of my spreadsheet? I mean: I do not want the users of my spreadsheet to have the option to view the version history, let alone go to an earlier version of the spreadsheet. An unsuspecting user could go to an earlier version of the spreadsheet and cause a loss of valuable information. note: I use google translate.
Search Box Macro Script To Search Using Filters In Sheet
Hi there, There are ways to create a search box in excel using a VBA. The main macro code is pasted below. I was wondering if this could be doable with Zoho sheet. Would this code work? Or, do you guys have a solution to search the sheet and filter the results? Thanks, Chad Sub SearchBox() 'PURPOSE: Filter Data on User-Determined Column & Text/Numerical value 'SOURCE: www.TheSpreadsheetGuru.com Dim myButton As OptionButton Dim SearchString As String Dim ButtonName As String Dim sht As Worksheet Dim
zoho sheet, hide column function added in new version. But what about hide column function in VBA?
Hi guys, I really like the hide column function in the new version, but can i use it also in VBA? Because that would be great, so hopefully you can give me some code to work with or create it :-). Already thanks. Wilco,
Zoho Sheet, button with macro don't work anymore in the new version?
Hi guys, I switched over to the new version of zoho sheet, but now my button with macro don't work anymore. When i switch back to the old version it works again? This is an example of what for code i am using. Sub Docenten() ' ' Docenten Macro ' Gemaakt door wilco02 op maandag 22 oktober 2018 14:18:08 ' Range("F1:K65536").Select Selection.EntireColumn.ColumnWidth = 0 Range("X1:BE65536").Select Selection.EntireColumn.ColumnWidth = 0 Range("A1").Select End Sub The code
Zoho sheet, data validation limited in new version zoho sheet?
Hi guys, I made a search box with data validation for about 600 customers. It works perfectly in the old version, when i switch to the new version it seems to be limited and shows only about 100 people? Do you guys also have this problem? And how can i fix it? Already thanks./
Document is weak
Hi. I want to work only sheet api my problem; I can't get TOKEN... Step 1: req https://accounts.zoho.com/oauth/v2/auth ?response_type=code &client_id=1000.P4Z0WWOLFDGRT23126TYD3B4JWQ5TE &scope=ZohoSheet.dataAPI.UPDATE,ZohoSheet.dataAPI.READ &redirect_uri=http://mydomain.com/zoho_result.php &state=-5466400890088961855 res http://mydomain.com/zoho_return.php?state=-5466400890088961855&code=1000.041b7b5928bbab9f0af9fdce95126e73.1fac756c41995bd37728b2ec5c1f2d1d&location=us&accounts-server=https%3A%2F%2Faccounts.zoho.com&
Bypass the url by a local url
Hey everyone, i'm using the Excel preview api and i wanna know if is it possible to change the url who is the excel file stored in a server by a local file who is stored on my computer ?? This is the Api link : https://sheet.zoho.com/sheet/view.do?url=http://link.to/file.xls&name=newName And i want something like this : https://sheet.zoho.com/sheet/view.do?url=file:///C:/Users/PC/Downloads/myfile.xls&name=newName Thanks you for the help ;)
editing sheet cells in the edit bar
if I overwrite & hit return, the cell remains *un*edited :(
Macro Disappeared.
I have had a sheet with a Demo VBA-Macro since may 2011 that I occasionally start. It is a demo for an interview that I still sometimes use as an example. After this my macro has disappeared from the file and its history. So even if I go back to versions from 2011 the Macros/view reports the sheet as not having any macros. I am wondering if the location where the macros are stored may have become unavailable. I then opened another sheet with a macro, it had disappeared too. Am I the only one?
Can't Create A Piechart in Zoho Sheets
Hi there I'm having problems creating a simple piecharts in sheets. I have a column that tracks 4 different values. I want to create a piechart to show what's the percentage of each value based on the total number of entries in that column. In MS excel, I just have to highlight that column and insert a pie chart. When trying to do the same with zoho, I get 'No chart recommendations for the selected data range'. And when I select piechart, the preview on the right show's nothing. Would appreciate
Zoho Sheets - Sorting cells by Color & Sorting Text By Color. (Not
Filter)
Hi, Is there a way to sort cells by color and by text color, similar to Excel? Cell and Text can be filtered by color. However, this is not helpful because it isolates ("filters") the cells or texts of the selected color/text and hides all others. I'm looking to sort by color, for example, sorting by cells with red text on top etc. Is this possible?
Timesheet with Balance Due / Formula
I'd like to create a timesheet for an employee, to keep track of their hours, total pay, and current balance due. Below is a screenshot with more detail. I'd like total hours to display all of the results B6:Bxxx. Total Pay will sum all of the values from C6 and onward. I'd like the "Pay Due" (C3) to show all of the balance due for those cells that don't have a pay date listed. With the example above, I'd like it to display "5" but then when a date is entered into the "pay date" column for that
Zoho Sheets 503 Error
Zoho sheets have been unavailable since this morning. I can't open any sheet but docs and presentations are working. Any ideas? Thanks.
Issue with a Sheet after yesterday Connectivity Issue
Hello there guys, As of today we're not being able to manipulate an specific Sheet with Pivot Tables (and filters on it) I've attached a .mp4 showing the problem itself Briefly the problem is that when we try to change the filter itself it's not doing anything or randomly showing an Error Message that implies that we cannot modify a Part of a Pivot Table. Please let us know how to fix this as remaking this whole Sheet is not viable for us currently. Thanks in advance for your support Kind Regards
Alt Keyboard Shortcuts
This is key for me as a financial analyst, and would make things much faster.
Can't able to scroll down to excel
I've created/uploaded excel sheet, but now not able to scroll down, is there any setting where its lock.
zoom?
how do you change the zoom on the sheet?
Next Page