New Features in Zoho Sheet: Editable Public Spreadsheets, Collaborator Presence Revamp and Formula Reference Toggling

New 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.

  1. Editable Public Spreadsheets

  2. Collaborator Presence and Panel Revamp

  3. 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 decide to share the spreadsheet with your collaborators, set a secure password. Share the link with your collaborators and notify them of the password.  The name that they choose will be displayed as their  username to the other collaborators of the spreadsheet.

                                         

                             

                                     

                               

             


Collaborator Presence and Panel Revamp

The Collaborator Panel has been revamped to let you work more efficiently . You can now view if a cell is being edited as a collaborator edits it. You can wish to turn on and off the presence of collaborators.  This feature comes in handy when there are many collaborators and you find their presence distracting.  You can also  view the range of cells that has been selected by your collaborator.

The Collaborator Panel displays the actions and the locations of your collaborators now. When you click on the name of the collaborator, the cell or the range in which he is currently present will be highlighted.


                     

                   

                   

                                 

Formula Reference Toggling

Function references can now be toggled using the function key F4. You can  toggle between relative and absolute references as you use your formulas and functions. This feature can be used in cases where you need to keep referring to the same cell again. For more help with absolute and relative formula references, refer our  help documents .

The toggle functionality will be especially effective when you use  a large number of input arguments in the formula or function  and would like to keep switching cell references.

You can also choose to navigate  along ranges  as you toggle between references. As you choose a range, the range is highlighted for easy reference. You can also navigate between ranges back and forth using Option+Tab and Option+Shift+Tab in Mac.


                 

                

                  

          

                  

          

                  


Do write to us at support@zohosheet.com after trying out these features and tell us how you liked them.




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