Printing selected area

N

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.
 
N

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 up to 67

What is the problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top