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