THAT WOULD WORK, BUT I PROBLEMS IS THAT I HAVE CREATED THIS FOR USE BY THE
ENTIRE COMPANY AND NOT ALL ARE COMPUTOR SAVY. I'M LOOKING FOR SOMETHING THAT
WILL DO IT AUTOMATIC WITH OUT HAVING TO DO ANYTHING EXCEPT HIT THE PRINT
BHUTTON

"Sarah Jane" wrote:

With 1500 jobs, I don't know how practical my solution is. You can hide the
rows that don't have information on them, and Excel will print only the rows
still showing. To hide rows, select the rows you want hidden, then either
right click and select Hide or use the Format menu to click on Rows and then
select Hide.

Sarah Jane

"NILELATOR" wrote:

I MADE A SPREAD SHEET TO TRACK JOBS THAT WE BID. I SET UP ALL THE FORMULAS SO
ACCOMADATE 1500 JOBS. THE PROBLEM IS THATS 31 PAGES AND I DON'T WANT TO PRINT
ALL OF THEM UNLESS THERE'S INFO ON THE PAGES IS THERE ANY SETTING OTHER THAN
"SET PRINT AREA" SO IT WILL ONLY PRINT WHAT HAS INFORMATION ON IT