Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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.

Published:

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.

For an optimal Community experience, Please view on Desktop