Webinar: Learn how to instantly clean your spreadsheet data
Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration. In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid ofAnnouncing 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 sourceTab 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 symbolZoho 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. AuthenticationExpanding 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 optionsLET, 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,Show 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 rightTo 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 isQuick and controlled data entry with new picklists in Zoho Sheet
Picklists are custom drop down lists with predefined values and formats that can be applied on the desired cell range. These customized drop-downs help you control the data entered into your spreadsheet and speeds up the process too! Effortless data entry Entering data manually is tedious and may lead to typos or misplaced values in your spreadsheet. Luckily, Zoho Sheet offers a solution to this problem with picklists. Once you create a picklist on a range, only the values in that specific listXLOOKUP, XMATCH, and six more robust new functions!
XLOOKUP, XMATCH, and six more robust new functions! Hello everybody! Zoho Sheet has introduced eight new functions to help you create more sophisticated, efficient spreadsheets. Let's take a look at these functions and their usage. Let us know in the comments how you plan to use them in your spreadsheets! XLOOKUP (lookup_value; search_table; result_table; [if_not_found]; [match_mode]; [search_mode]) VLOOKUP, one of Zoho Sheet's most used functions, has helped people create reports or instantly lookIntroducing Race Charts: a smart way to visualize historic data
Visualizing data recorded over a long period of time just got more interesting! We're excited to introduce Race Charts to Zoho Sheet's already extensive chart family. With our built-in data visualization feature, you can quickly create a bar chart race that animates continuously where the bars race against each other based on the data—no extra coding or add-ons required! These animated bar charts jazz up your spreadsheets while you sit back and watch your data come to life. But why stop there?Moving all users to the new Zoho Sheet
Hello everyone! We introduced the latest version of Zoho Sheet—Sheet 5—in early 2019. This new version consists of a new user interface, improved performance, and an array of useful features. The old version of Zoho Sheet will be deprecated permanently on February 29, 2020, a year after Sheet 5 was introduced. After February 29, 2020, all users of the old version will be moved to the new version, and you will no longer be able to switch back to the old version. Update: All users will be moved toNine powerful new Zoho Sheet functions, including currency conversion
Zoho Sheet is always looking for ways to make your data analysis simpler. With that in mind, we've introduced nine new functions. We believe they will help make your spreadsheets a bit more sophisticated. CURRENCY (value; from; to) You'll no longer have to look up exchange rates to maintain records in different currencies. The new CURRENCY function will fetch live exchange rates and convert your numbers automatically. FILTER (range; condition; [condition1]; [condition2]...) While the FILTERZoho Sheet with a colorful new UI, 2 million cells and .xlsm excel file support
We have come up with a number of improvements in Zoho Sheet that enhances your overall experience. A colorful new user interface We are excited to present the new, elegant Zoho Sheet UI. The UI features new tabs, more colorful icons, and a look and feel that enriches the user's experience while retaining functionality. The design is in line with other productivity applications from Zoho. Old UI vs New UI You can write to support@zohosheet.com with your feedback. Two million cells Get ready forZoho Sheet 5 - Evolving beyond traditional spreadsheets
Zoho Sheet recently had a major update, making it more powerful. This update adds Zia, an AI assistant, who can help you with data visualization and analysis. Other additions include an automatic Data Cleaning tool, the option to build Custom Functions that bring in data from other applications, and a lot more. Learn more | Watch video " Zia, how are sales doing this year?" Zia, will be your new personal data analyst. She'll help you visualize your data by summarizing rows and rows of informationBringing 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 leftUpgrade 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 ofTemporary glitch in STOCK() function.
Dear users, Due to the unexpected termination of stock data API service from Yahoo! Finance, we are sorry to inform you that the STOCK() function in Zoho Sheet will be temporarily disabled. The STOCK() function will return #ERROR! from our next update. We're working on bringing back the function and will update you once we're done. Please bear with us until then. Thanks, The Zoho Sheet TeamNew forum, closer community, better experience—Zoho Sheet
Hi Everyone! We've been making a lot of changes to Zoho Sheet behind the scenes, and all these enhancements will be out in a few more days. As a first step in moving to a closer community where our team and users stay connected, here's the new Community forum exclusively for Zoho Sheet. Follow the page to see all the announcements, get answers for all your questions, post ideas, and learn some tricks that can help you create powerful spreadsheets quickly, and become a spreadsheet expert! NotLive webinar: An overview of Zoho Sheet
Get a complete overview of Zoho Sheet. Register now to join our live webinar and product demo on November 23, 2017. Attending this session will help you: 1. Create beautiful looking spreadsheets 2. Share your spreadsheet and work in real-time with your team 3. Write formulas to do basic calculations 4. Create charts to visualize your data 5. Use macros to automate repetitive tasks Day: Thursday, 23rd November 2017 Time: 11.00 AM - 12.00 PM PDT Register for the webinar, here.Live webinar: An overview of Zoho Sheet
Hello All, Spreadsheet Day (17th October 2017) is right around the corner. Let's make it a productive one. Join us for a live webinar on the complete overview of Zoho Sheet. Attending this session will help you to: 1. Create beautiful looking spreadsheets 2. Share your spreadsheet and work in real-time with your team 3. Write formulas to do some basic calculations 4. Create charts to visualize your data 5. Use macros to automate repetitive tasks Register for the webinar here. Day: Tuesday, 17th OctoberComment enhancements - more productivity inside the box.
Let's say you're building a sales forecast for your product or developing a marketing budget for your team. You start out with a spreadsheet and soon realize that you need to work with other people: to validate assumptions, get estimates, verify processes etc. Do you find yourself sending emails, making calls—trying to reach people—cutting, pasting, waiting... waiting for the input you need? Built right into Zoho Sheet is the prescription for this headache. It's called Comments. Now we've improvedGet set for Icon Sets.
Conditional Formatting in Zoho Sheet has become more exciting with the addition of Icon Sets. Represent a series of data with certain intervals using colorful icons. They are available in sets of two to five icons making them flexible with your data. How to use it. Icon Sets is placed under the Conditional Formatting menu tab. You can use a set containing two icons for data with TRUE/FALSE or similar conditions, three or more icons to see the change in data with manyAdding more color and category to Charts.
Charts are the most effective way to represent data inside a spreadsheet. Zoho Sheet is constantly working on improving this marvelous tool of data visualization. Let's see what the current Chart update has in store for you. 1. Colors to make charts with elegance. Color Schemes Default colors can make your charts look monotonous. Hand-picking colors for each segment of a pie or funnel can also be tiring. Choose from the four sets of color schemes, or from the various other monochromatic shades. AlreadyFast track to perfect charting.
Charts need the right set of data to look perfect. Wait, what?! If that's your mantra for ideal charts, you're doing your charting wrong. Perfect charts are those that interpret your data, however it might be, in the best possible way. Plenty of time goes into creating them. Well, not anymore, as Zoho Sheet has solutions to bring down the time you spend on charting. Cherry-pick charts, nimbly. Cherry-picking charts at the cost of your time? It's fun to try out different chart types, but not whenOne more reason to move to Zoho Sheet.
Parting with data while moving to a new product is not the case with Zoho Sheet, as the improved 'File Import' lets you bring your files into Zoho Sheet effortlessly. Replace current spreadsheet. Constant updates to your spreadsheet from different sources don't require duplication anymore. Replace your current spreadsheet, while retaining share permissions. Insert as new sheet(s). Use 'Insert as new sheet(s)' to import sheets(worksheets) from various sources into a single spreadsheet. This helpsCustomizable Charts in Zoho Sheet
Now, create charts the way you want. Show your analysis effectively by picking colors of your choice for various elements of the chart. Visually appealing charts Set colorful backgrounds for your charts. Choose from a wide range of colors for plots, series, titles and subtitles. Choose 'Edit' mode to edit charts with just a click. With the new chart enhancements you can change the color, size, format and font of texts in charts by clicking them. Note: Avoid unintended changes to charts, using theAdvanced "Chart" engine with Auto-detection, Auto-expansion and Trendlines
Zoho Sheet has upgraded to a more powerful Chart engine with vibrant features to improve your charting experience. Auto-detect Chart ranges Charts in Zoho Sheet are as intelligent as its users. Just click on a cell anywhere in the range and go ahead and insert a chart, Zoho Sheet automatically detects the range. The feature is extremely useful when the data range is large and saves you from selection hassles. In case of non-contiguous data, it is also possible to manually enter the range in the 'AddNew Pivot Tables in Zoho Sheet
Pivot Tables lets you slice and dice the data in your spreadsheet and helps you gather meaningful insights from your data. Though Pivot Table was already available in Zoho Sheet, we have now completely revamped it, made it more powerful and have integrated it seamlessly into your spreadsheet experience. We provide you with an intuitive user interface where you can drag and drop fields into rows, columns, data and filter boxes to draw your Pivot Table. Here are the capabilities of our new PivotRecreate your old Pivot Tables and Pivot Charts in Zoho Sheet
Recently we launched a new version of Pivot Tables in Zoho Sheet which brings in new capabilities and makes it more powerful. Read the following post to learn more about the new Pivot Tables: https://help.zoho.com/portal/en/community/topic/new-pivot-tables-in-zoho-sheet Please note that if you have been using the old Pivot Tables and Pivot Charts, then you would need to recreate those with our new Pivot Tables feature. The old ones will stop working by end of Oct 15, 2015. Unfortunately, there isAudit Trail and New Version History in Zoho Sheet
Two new features related to collaboration have recently been added to Zoho Sheet. New Version History Audit Trail New Version History: We have revamped our Version History to provide you better insights as to what changes have gone into each version and who has made those changes. This gains importance when you share your spreadsheets with your co-workers and work in a collaborative environment. The new Version History, which is accessible from File menu as well as the Review tab, opens up a paneSharp features to fine-tune your spreadsheet experience
Your needs keep evolving and as does our spreadsheet. We concentrate on providing the best spreadsheet experience to you and in our mission, we bring you more features and enhancements to use and enjoy. These niche features will help you enhance your work experience and ensure your productivity improves. Highlight Invalid Data: Data Validation is a crucial feature that helps you enter data correctly. Highlight Invalid Data is an enhancement to the existing Data Validation feature. This featureExperience The New Chart Engine : Now More Refreshing and Vibrant
In our effort to deliver the best spreadsheet experience to you, we bring out to you our next update. Our chart engine has been updated completely to let you chart, interact and analyze from your data. Data visualization is a crucial part of spreadsheets. Visualization helps you acquire intuitions and frame right conclusions. Our latest update will help you do exactly that. So, what do we have in store for you? Interactivity and Vibrancy: First of all, you can now interact better with the chartsFree Webinar on Advanced Functions of Zoho Sheet
A spreadsheet can be used to run your business efficiently and smoothly. They help you organize, analyze and collaborate on complex business tasks with ease. Join us on our webinar and we'll show you how to unleash the complete power of collaboration in Zoho Sheet. Here's the first look of what's cooking in the webinar exclusively for you!!! In this webinar, you will learn how to: Collaborate on spreadsheets in real-time Automate workflows using formulas and macros Permit varying levels of accessFree Webinar on Advanced Functions of Zoho Sheet
Spreadsheets can be used to run your business end-to-end. They help you organize, analyze and collaborate on complex business tasks, smoothly. Join us on our webinar and we will show you how you can unleash the power of collaboration in Zoho Sheet. Here's the first look of what's cooking in the webinar, exclusively for you!! Register today and reserve your seat! Date: 2nd April, 2015 (Thursday) Time: 11.00 AM - 12.00 AM PDT In this webinar, you will learn how to: Collaborate on spreadsheetsNew Features in Zoho Sheet: Editable Public Spreadsheets, Collaborator Presence Revamp and Formula Reference Toggling
Recently, we have made the following enhancements to Zoho Sheet which will enrich your experience. Editable Public Spreadsheets Collaborator Presence and Panel Revamp Formula Reference Toggling Editable Public Spreadsheets This feature lets you share the spreadsheets you create using Zoho Sheet publicly on the web with password security. You could use this feature even with users who haven't yet signed up with Zoho. You can avail this feature from Share settings. Once you decideNew Release - Gray Theme, Improved Collaboration and more
We are pleased to announce the new release of Zoho Sheet with the following new features, new UI and enhancements. New Gray Theme Where is the Save button? New Sharing Options Improved Realtime Collaboration Spreadsheet Settings (Locale and Time Zone) Paste Special Typeahead / Auto Completion New Gray Theme Zoho Sheet now sports a gray theme in tune with Zoho Writer and Zoho Docs giving you a more standardized user experience. Do you like the new gray theme? Let us know whether you like it or notNew in Zoho Sheet: Text to Columns, Filter by Color, Range Selector and more
Last week, we released an update to Zoho Sheet with the following new features and enhancements: Text to Columns Filter by Color (and other enhancements to Auto Filter) Range Selector Filter by Cell Range in Manage Rules of Conditional Formatting And here are a couple of features released in end of January: Notify Collaborators Save to Folder Lets look at each of them in detail: 1. Text to Columns: The 'Text to Columns' functionality (available under the Data tab) lets you to split data in cellsRevamped VBA Macro Engine
We have been supporting VBA macros for the past three years in Zoho Sheet. Last month we made a significant revamp of our Macro execution engine. With this update, your macros could run faster by up to 75% than before depending on what your macro does. Here is a spreadsheet which generates Vicsek fractal (box fractal) using macros. There are 4 different fractals generated in 4 different worksheets. Click on the 'Generate Fractal' button in each worksheet to generate different fractals. To changeNext Page
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
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
Announcing Zoho Sheet desktop app for macOS and Windows (Beta)
Hello Sheet users, We know you’ve been waiting for this one. It has always been the top priority on our roadmap to provide a single native desktop app for macOS and Windows that works both online and offline. Today, we are excited to announce that theUpdate: [Issue fixed] Temporary access issue on Android and iOS devices
Hello, Zoho Sheet users! We're aware that some of you are currently unable to open spreadsheet files from your Android and iOS devices. We extend our sincere apologies for the inconvenience caused. We're working on fixing the issue with highest priorityIntroducing a smarter, faster, and more flexible charting experience
Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you toUpdated font library: New font styles and custom font options in Zoho Sheet
Zoho Sheet's font library now supports 500+ font styles in 60+ languages! The updated font library is stacked with new font styles, and some of the previously available font styles have been replaced with equivalent options. There are two ways you canWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally
Most Discussed Topics
Graph style changed in Zoho Sheets
I've been working on a profit sheet. The grouped bar chart has changed from the last time I used it to now. It used to show where the bars started at 0. When I put in a negative number, it went negative past the zero (which is what I want) for only thatUpdate: [Issue fixed] Temporary access issue on Android and iOS devices
Hello, Zoho Sheet users! We're aware that some of you are currently unable to open spreadsheet files from your Android and iOS devices. We extend our sincere apologies for the inconvenience caused. We're working on fixing the issue with highest priority
Zoho Developer Community
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
Introducing a smarter, faster, and more flexible charting experience
Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you toWhat's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyNew Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your workIntroducing 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 youSlicers 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,
Top Contributors
Crystal
Anouncia P
Vinoth Kumar K
Subashree Ramamurthy
subashree.rs