How to access the spreadsheet properties | Zoho Sheet help

View spreadsheet properties

The spreadsheet properties panel in Zoho Sheet provides you with the complete details about the spreadsheet and its usage in the form of a summary. You can access the spreadsheet properties using the  icon in the top-right corner of the editor or using File > Properties. In the Zoho Sheet listing page, you can hover over the desired file and use the More Options  menu to access the spreadsheet properties.
 

 
Details listed in the properties panel:
  • File name: The name of the spreadsheet. View and edit the file name directly from the panel.
  • Description: The description for the spreadsheet. Add a short description about the spreadsheet and its data for collaborators' comprehension.
  • Views: Total number of views for the spreadsheet. Views are calculated for every file load and refresh.
  • Downloads: Total number of times the spreadsheet has been downloaded. Includes downloads performed by collaborators and via published view.
  • Permalink: The link that directs to the current spreadsheet. It can be used to share the file with collaborators or to hyperlink it.
  • Location: The location of the spreadsheet in your WorkDrive account. Specifies the folder and subfolders within which the file is placed.
  • Labels: Help you to easily identify and access files or folders across different locations in Zoho WorkDrive. You can add labels based on priority, status, task, and much more. Once you add a label to files and folders, you can view all those items under each label.
  • Current Version: The version number of the spreadsheet. It is the latest number by default, and displays the respective version number on version revert.
  • Time Created: The date and time when the spreadsheet was created.
  • Modified by: Details on who made the last edit in the spreadsheet along with the date and time.
  • Published: Details on the publish status of the spreadsheet. If not published yet, you can do it from the panel directly.
 

Usage Details 

The usage stats provide details on the number of cells, charts, pivot tables, and formulas used, and more. This can be viewed for the whole spreadsheet or for specific sheets.
 

 
  • Sheets: Total number of sheets present in the spreadsheet. Includes hidden sheets as well.
  • Cells with data: Total number of cells containing values (non-empty cells).
  • End of sheet: The last cell containing data in the sheet.
  • Used Cells: The total number of cells in the sheet/spreadsheet that are covered within the used cell matrix. For example, if the end of sheet is D10, the total number of used cells will be 10(row)x4(column)=40(cells). The total used cells in a spreadsheet is the sum of the total used cells in each sheet.
  • Pivot Tables: Total number of pivot tables used in the spreadsheet or the selected sheet.
  • Charts: Total number of charts used in the spreadsheet or the selected sheet.
  • Tables: Total number of predefined tables in the spreadsheet or the selected sheet.
  • Formulas: Total number of cells containing formulas in the spreadsheet or the selected sheet.  
 

Data Templates 

Data Templates can be used to associate similar files or data for seamless navigation. It is a part of the Zoho WorkDrive file management system. Click here to learn more about Data Templates. To create a Data Template from Zoho Sheet, open the properties panel and click on the  icon.

    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Share spreadsheet for collaboration

                                                                                                                To share a spreadsheet with others: Go to ••• > Add People in the listing page or spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access permission, and tap Share. If you are using Zoho ...
                                                                                                              • Locate your spreadsheet's Resource ID

                                                                                                                A Resource ID, or an RID of the spreadsheet is an alphanumeric string that forms part of the spreadsheet's URL. The RID always follows the 'open/' part of the URL. For instance, in this URL,  ...
                                                                                                              • Create a new blank spreadsheet

                                                                                                                To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.
                                                                                                              • Export or download a spreadsheet

                                                                                                                To download or export a spreadsheet: Go to ... > Download As in the editor. Choose the file format in which you want to export the spreadsheet. Select the location to save or send the spreadsheet. Note: To download from the file listing screen, use ...
                                                                                                              • Open a spreadsheet from Dropbox/Box

                                                                                                                To open a spreadsheet from Dropbox, or Box: Go to Places using the option in the bottom bar of the file listing page. Choose the desired place from which you wish to open the file. For Dropbox and Box, you will need to authenticate your account. Pick ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources