print to last line?

[jiwolf]

is there a way to get excel to print a file but only down to the last row
that has a value in it? I have a file that has 100 lines in it but the
number of populated rows varies. I don't want pages of blank rows.

any ideas?

 

[Guest]

The easiest way to do this is to set the print area to the section of the
sheet that you want to print:

Select the area you want to print, then go File, Print Area, Set Print Area

Otherwise, if there is no print area defined, then Excel will automatically
print the entire rectangular area from A1 to the cell at the intersection of
the highest occupied column and row.

 

[jiwolf]

Yes i do this every day, but i was looking for a way for the process to be
done automatically.