Zoho Sheet 3.0 - New User Interface, Filters, Conditional Formatting and More

Zoho Sheet 3.0 - New User Interface, Filters, Conditional Formatting and More

We are pleased to announce the release of Zoho Sheet 3.0 with a host of new features. 


The first thing you will notice as soon as you login is the user interface revamp. Zoho Sheet has undergone a major facelift and is now consistent with our word processor, Zoho Writer, and our presentation software, Zoho Show. We now have what we call the MenuTab, which is a combination of Tabs, Menus and Toolbars. To open your existing files, you will have to click on File and then choose Open from the File menu. At the bottom of this post are some screenshots of our new interface.

Here are the new features that are available with this release:
  1. Filters: 
    Add filters to your spreadsheet to slice and dice your data.
    Learn more about Filters

  2. Conditional Formatting: 
    Format cells based on the desired criteria. You can even use Formulas to define the rule thereby expanding your possibilities.
    Learn more about Conditional Formatting

  3. Format Cells: 
    Choose from a variety of formats (number, currency, date, etc.) for your cells including your custom formats.

  4. Improved Printing Capability: 
    Set print options and preview it before printing.

  5. Solver: 
    A what-if analysis tool used for optimization.

  6. Find and Replace: 
    Find the string that you are looking for and optionally replace it with the desired string.

  7. Function auto-completion: 
    Suggests matching functions as you type a formula and provides a quick reference.

  8. Instant Sum, Average, Count: 
    Calculates the Sum / Average / Count of the selected cells and the result is readily available on the status bar.
Over the next few days, we will write detailed posts about each new feature. 

Other Enhancements:
  • Zoho Sheet now takes you to the cell you were last on while loading your spreadsheets.

  • New color options - 'No Fill' for cell background color and 'Default Color' for the text color - have been added.

  • Easier copying to clipboard. A single copy button (and shortcut) to copy and paste data within the spreadsheet as well as to copy and paste data outside of the spreadsheet. The 'Copy to Clipboard' menu item on the context menu is now removed as it is redundant.

  • 'Click to Edit' button on public spreadsheets has been removed. One can interact with your public spreadsheets as soon as it loads.

Limitations and Withdrawal of Functionality:
  • Internet Explorer versions 6 and 7 are no longer supported. You can upgrade your browser to the more recent versions of Internet Explorer, Mozilla Firefox, Google Chrome or Apple Safari.

  • We have now removed the Tabular Data setting while importing CSV files as we feel it is no longer needed.

  • You won't be able to share individual worksheets with others even though you will be able to share the whole workbook. If you had already shared individual worksheets, they will continue to work as usual and won't reveal the entire workbook to your collaborators. We will bring this up again in a future update.

  • You can no longer leave a comment on the spreadsheet as a whole. However you do have the option of inserting comments on cells.

Here is the slideshow of screenshots depicting the options and tools available under each tab. The toolbar buttons to access the new features have been highlighted as well. View the presentation below in full screen for better clarity.


Refer our New Features page for more information on this update.

We hope you will find these new features useful for your regular use. Feel free to post your comments and suggestions so that we can keep improving. 


      • Sticky Posts

      • Slicers 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

      • Format 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,

      • Introducing Data Bars: Graphically represent changes in data within the cells

        Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

      • Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

        Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,