Copy Page Breaks

[jwleonard]

Is there a way to copy page breaks so you don't have to set the
manually on every page? I have a workbook with several similar sheet
that I must change the page breaks on as data is added and removed.
would like to set the new breaks on the first page manually and the
copy it to all others. Thank

 

[Dave Peterson]

So you reset all the existing page breaks, then go through and manually adjust
them again.

You could set one page break, then find your next location and
hit F4 (Edit|Repeat insert page break) (or even ctrl-y)

But it might be easier to go into View|page break preview and just slide the
page breaks where you need them. (Well, if the natural breaks were close.)