Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Automatic Column and Row Resizing


Overview

Some data values, such as customer names, are of variable length.  So when you load these values into a worksheet cell, you do not know how wide the column should be before you run the report. If the column is not wide enough to hold the data, Excel will either display ######## in the cell, or it will only show the section of data that will fit in the cell.

Jet Reports can automatically format the column width or row height for the widest or tallest piece of data that you want to display.  This operation is very similar to the manual process of using Excel's Autofit feature.  The whole column will resize to fit the widest cell.

Process

To do this with Jet Reports, you can put the keyword FIT in row 1 of the column.  For example, if you have a list of customer names in column C, you can put FIT in cell C1...

autofit1.png

...to automatically resize the column for the longest customer name when the report is run. 

autofit2.png

If you want to resize the height on a row, you can put FIT in Column A of that row.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments