Page breaks

[ajaay]

I have a excel sheet that i use to enter data into, however when it goes over 5 pages it won't print those pages e.g.

I start with maybe 250 rows over 5 pages and then if i need more i insert new ones to accommodate the extra data maybe going up to 400 rows and 8 pages. However when i go to print it, the extra 3 pages don't print. I have to go into the page break view and drag it down to get the next few. Is there anyway to set it so it does it automatically. Help please!!!

 

[GlennUK]

What happens if you clear the print area completely? Excel should then automatically print the entire sheet every time.