I'd use data|filter and filter that column to show the nonblanks (not the zeros
that Andy suggested).


How about an alternative?

I'm gonna use column B as a column that always has something in it if that row
should print. You can change that if your formula is in a different column.

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

(Make that 2000 big enough to extend past the last possible row--but don't use
the whole column. In fact, I'd bet you don't need to go to row 65536!)

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

That last 5 represents the last column to print (A:E). Change it to what you
want.

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



nickname wrote:

I have created a new workbook and in cell B1 I have put the formulae
"=IF(ISBLANK(A1),"",44)". I have then used the fill down function to fill it
down to row 65536. When I go to file print preview its going to print 1821
blank pages. How can I stop it from printing cells that show no value but
contain formulae?

--

Dave Peterson