Page Break

  • Thread starter Thread starter Lou Aiello
  • Start date Start date
L

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.
 
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.
 
Back
Top