Pagination
 

(Excel 2003) I was utilizing Page Break View to go through a multipage
document to ensure secondary lines stayed with their primary entry. Now I
have some solid lines delineating pages and other pages delineated with a
dashed line.

I don't like how it looks and want to start over, but I can't figure out how
to start over with pagination. Right now I have some pages that have reduced
themselves to 80% to get all the data on the page and when I change it to
100%, of course some lines then move to an additional page. Because that
section ends with a solid line, that's all the lines that are on that
additional page. So in some cases I have just five or six lines of data on a
page.

What I want are evenly balanced pages in 100%, keeping secondary lines of
data with their primary data. Short of creating the 18(ish) page document
all over again, what can I do to achieve this goal?