Printing selected area

[Nunya]

When using Excell 2007 I have come across a strange problem when trying to
print the selected area in Excel. I have a large spreadsheet with horizontal
page breaks set throughout the worksheet. When I select an area in the
middle of the worksheet that should print 3 pages or more the pages are not
as expected. It appears that Excel is ignoring the set page breaks to
calculate the number of pages to print. Then using the set page breaks as
well as calculated page breaks to break the pages.

This causes the last page to be incomplete and the middle pages to have
breaks where there should be none.

 

[Nunya]

You can easily duplicate this yourself by doing the following:
In cloumn A autofill the numbers from 1 to 100
Insert a page break every 20 rows (above 21, 41, 61 and 81)
select A21:A71
go to Print and select 'selection'
Click Preview
You will only see numbers 21 to 67 when they should go to 71