Collapsing rows with no data for printing

  • Thread starter Thread starter John Sullivan
  • Start date Start date
J

John Sullivan

I have a spreadsheet that contains 96 rows of
information. I would like a formula that would tell the
spreadsheet to collapse empty rows that do not contain
data in a certain cell of that row and not to print any
row in which data does not appear in that certain cell on
other rows. In addition, the 9th row following each group
of 8 rows contains master totals of the previous 8 rows,
and I would want that row to always print unless there is
no data in the 9th row (which would mean that there is no
data in a certain cell in any of the previous 8 rows).
 
Hi John
Formula in one cell can not change formatting, values or
the viewing state of another cell.

One way is to use a helper column and the Autofilter.
Assuming row 1 contains column headers and your data
starts in A2 and finishes in C96. And also assuming
Column A contains your blank "certain cell/s" in D2 enter
the following formula "=IF(A2=0,"no print","print").
Select A1 to D1 goto Data--Filter--AutoFilter. click on
Column D arrow button and select "print".
Select Column A, B & C goto File--Print Area--Set Print
Area and then print as normal.

Print preview will show only Columns A, B & C are printed.

Hope this helps
Regards Bob C.
 
When doing this, it only shows one row to print, all
other rows are "collapsed" or not shown, even though many
of those rows have data in the A column which I would
want to see. Would like only for rows which do not
contain data in Column A to not show.
 
Back
Top