View spreadsheet properties

View spreadsheet properties

How to view spreadsheet properties

To view spreadsheet properties, go to File > Spreadsheet Properties.



The following details will be listed in the properties:
  1. File name: The name of the spreadsheet. View and edit the file name directly from the panel.
  2. Location: The location of the spreadsheet in your WorkDrive account. Specifies the folder and subfolders within which the file is placed.
  3. Current Version: The version number of the spreadsheet. It is the latest number by default, and displays the respective version number on version revert.
  4. Time Created: The date and time when the spreadsheet was created.
  5. Modified by: Details on who made the last edit in the spreadsheet along with the date and time.
  6. Permalink: The link that directs to the current spreadsheet. It can be used to share the file with collaborators or to hyperlink it.
  7. Published: Details on the publish status of the spreadsheet. If not published yet, you can do so from the panel directly.
  8. Share access: The users the spreadsheet has been shared. View and edit permissions directly from the panel.


Usage details

The usage stats provide details on the number of cells, charts, formula used and more. This can be viewed for an entire spreadsheet or for sheet tabs.
  1. Sheets: Total number of sheets present in the spreadsheet. Includes hidden sheets as well.
  2. Cells with data: Total number of cells containing values (non-empty cells).
  3. Pivot Tables: Total number of pivot tables used in the spreadsheet or the selected sheet.
  4. Charts: Total number of charts used in the spreadsheet or the selected sheet.
  5. Formulas: Total number of cells containing formulas in the spreadsheet or the selected sheet.  


        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          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







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG

                                    All-in-one knowledge management and training platform for your employees and customers.

                                              Create. Review. Publish.

                                              Write, edit, collaborate on, and publish documents to different content management platforms.

                                              Get Started Now




                                                                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


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        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 Demo

                                                                                                          Get a personalized demo or POC

                                                                                                          REGISTER NOW


                                                                                                            Design. Discuss. Deliver.

                                                                                                            Create visually engaging stories with Zoho Show.

                                                                                                            Get Started Now








                                                                                                                                • Related Articles

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