how do I suppress printing blank lines in a worksheet?
 

I have rows in my spreadsheet that are blank in terms of conditional formulas
set up to return blanks under specific conditions.
Is there a way to suppress the printing of, or automatically hide completely
blank rows?

how do I suppress printing blank lines in a worksheet?
 

Can you use data|Filter|autofilter to show just the rows that don't appear
empty?

===
If those formulas appear at the end of the data and you don't want to use
autofilter...

If I can pick out a column indicates if that row is used or not, then I like
this technique:

(I used column A in my sample, but you can use any column you want.)

Insert|Name|Define
Names in workbook: Sheet1!LastRow
Use this formula
Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW(Sheet1!$A$1:$A$1000) )

(Make that 1000 big enough to extend past the last possible row.)

Then once mo
Insert|Name|Define
Names in workbook: Sheet1!Print_Area
Use this formula
Refers to: =OFFSET(Sheet1!$A$1,0,0,lastRow,3)

That last 3 represents the last column to print (A:C in my example).

And change the worksheet (sheet1) if necessary (in all the places).

Rob M'Crystal wrote:

I have rows in my spreadsheet that are blank in terms of conditional formulas
set up to return blanks under specific conditions.
Is there a way to suppress the printing of, or automatically hide completely
blank rows?

--

Dave Peterson