Turn Off AutoResize of Rows and Columns

<< Click to Display Table of Contents >>

Navigation:  Professional > Reports > Crosstab Reports >

Turn Off AutoResize of Rows and Columns

EQuIS Professional Crosstab has built in functionality to automatically resize columns and rows to fit data. This functionality is particularly useful when tabbed data contains duplicate values and you want to view all of the values within the cell (row must be resized to display all duplicate values).


In large crosstabs, the automatic resize functionality may require more time for processing the Crosstab Report. In order to improve performance for large crosstabs, Crosstab will no longer automatically resize rows and columns. Rows and columns will now be displayed with default height and width.


Any row can be automatically resized by double-clicking in that specific row. For example, if you see a highlighted cell that contains duplicate values, double-click within that cell and the row will automatically resize to show all of the duplicate values.


If there are many duplicate values, you can automatically resize all rows by holding down the Ctrl key on the keyboard while double-clicking any row. If Ctrl is held down during the double-click, all rows (and columns) will be automatically resized. Automatically resizing all rows and columns may take a minute or two, depending on the size of the Crosstab.


Warning: When the data is exported to Excel, the rows will automatically display all of the duplicate values. It is not necessary to resize rows in EQuIS Professional before exporting to Excel.