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?

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" wrote:

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?

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


"Vaughan" wrote in message
...
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" wrote:

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?

This would work if you had numeric data in column A and no gaps, and you
wanted to print columns A to H:

Amend the Print_Area name to refer to the following formula (i.e. Select
Insert, Names, Define then select "Print_Area", don't use File, Print Area or
the File Page Setup menus)

=INDIRECT("$A$1:$H$" & COUNT($A:$A))

The COUNT($A:$A) formula is calculating the number of rows containing
numerical data. There are a lot of other ways to skin that particular feline.


"jiwolf" wrote:

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


"Vaughan" wrote in message
...
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" wrote:

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?