Suppressing Empty Cells

[GeoffT]

Does anyone know how to omit cells that are empty? I have 1 cell per line and want to suppress the line if the cell is empty to avoid a lot of white space in the report. I'm reasonably sure this can't be done at cell level, only section, but if anyone out there knows otherwise . . . .

 

[BeckyL]

You could apply a filter to the column data. You will click in the data portion of the column and then choose Insert, Filter and a dialog box pops up and you select the values you want to see and click OK.

Once the filter is applied you should see only the cells containing the values selected.

Be careful as this effects the entire row of data. If you play around with it you should be able to get it to work. We finally went to a year to date column and filtered the column to exclude cells = 0 and then the current quarter column displayed correctly for our desired results.

BeckyL

 

[GeoffT]

I don't think this will work because we still need to see all the other data in the row, but because it's formatted one line per column we want to omit empty columns (lines). Thanks anyway.

 

[bensonpa]

You can't filter out columns. Only rows.