Using the Data Spreadsheet
The Data Spreadsheet displays, as crosstabs, all of the data selected in the filters, columns, and rows dialog boxes. The Data Spreadsheet is an embedded, fully functional, Google Sheet that offers all of the tools for manipulating data at the top of the Data Spreadsheet window. When working in the Data Spreadsheet it may be helpful to toggle the full screen icon located in the lower right corner of the Data Spreadsheet window.
Understanding the Data Spreadsheet
You can view the active filter you created in the filter dialog box, displayed in the upper left hand corner of the Data Spreadsheet. Multiple filters are applied as separate tabs(sheets), located at the bottom of the Data Spreadsheet.
The columns and rows you selected in the columns and rows dialog boxes are displayed along the top and left hand side of the Data Spreadsheet.
By default Projection, Respondent, % Horiz, % Vert, and Index are displayed in the crosstab area of the Data Spreadsheet. For information on changing the types of values displayed, visit the article Editing the Report Options.
Editing the Data Spreadsheet
You can edit the Data Spreadsheet as with any other spreadsheet program and changes are automatically saved.
NOTE: Clicking the calculate button will revert all cells to their original values.