Page Break

[Lou Aiello]

Is there a way (either by macro [least favorite] or conditional formatting
[preferred] or formula [also preferred] to set up page breaks based on data
rather than number of lines on a page or the excel defaults. e.g. Let's
say A:A contains names and I want to force a page break every time the name
changes. I can set up B:B with an indicator that the name changed if
necessary, but cannot seem to find a way to set the page breaks other than
to do it manually. Thanks in advance.

 

[Earl Kiosterud]

Lou,

Data, Subtotals can do that, but you'll have to tolerate the subtotals.
Maybe you can use them. Or a macro can go through and put a page break, but
you don't like macros.