Print only rows with data entered in an excel template
 

I have a purchase order template that can be of variable length. How can I
print only lines with data entered in?

Print only rows with data entered in an excel template
 

Set up a dynamic print range.

See Debra Dalgleish's site for creating and naming dynamic ranges.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 04:09:00 -0700, hellaby
wrote:

I have a purchase order template that can be of variable length. How can I
print only lines with data entered in?