The spreadsheet report enables you to view records in a table grid arrangement. The information is distributed into rows and columns, with the fields occupying the column headers and the field values occupying the rows below.
This report behaves like a typical spreadsheet. You can easily perform the following actions in the report:
Using a spreadsheet report is ideal when your requirement is to view the records and update them instantaneously.
In a spreadsheet, you can edit the record directly in the report. Selecting the cell in which you want to change the information enables editing the value. You could copy and paste or cut and paste information within the report. The value available in a field can be dragged over to consecutive fields to duplicate the value across records. To achieve auto-filling, place the cursor at the bottom corner of a cell. Click and drag to consecutive cells until you replicate the value in the required records.
It is possible to delete more than one record in one shot. On selecting the record that needs to be removed, the delete icon appears in the header. Clicking the icon deletes the records after confirmation.
The predefined layout selections become the factors that influence the rows and columns that remain static at the event of scrolling through records that run beyond a single page. Your spreadsheet report can retain the first column and first row in the view of the user while allowing the rest of the rows and columns to be scrolled out of view.
Spreadsheet report equips you with searching, filtering, importing, and exporting capabilities.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
Write to us: email@example.com
Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.
Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.
Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.
Make the most of Zoho CRM with these useful tips.