If they're hidden rows, then they won't print.

If you mean that you have formulas that evaluate to "" and don't want those rows
to print until they evaluate to something you can see...

========

Saved from a previous post.

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).

GPIE wrote:

I have a loan spreadsheet where I have hidden extra rows beyond the term of
the loan. I do not want these hidden rows to print.

Excel has a Loan Amortization spreadsheet that is able to do this. Does
anyone know how they did this?

--

Dave Peterson