Not sure if this answers your question, but it's worth a try.

Go to ViewPage Break Preview. You will see each break is a dotted blue
line. Select the rows where you want to put fixed page breaks (at the bottom
of each group of rows you want kept together), right click on the row
numbers and Insert Page Break. Alternatively, drag the existing ones up and
down. These should be represented by solid blue lines, meaning the page
break is 'hard' and will move up and down as you hide the rows.

Paul C,
--

WP wrote:
We are in the process of making a spreadsheet in excel that, depending
on the user's input, will show/hide groups of rows to display only the
relevant information. For example, if user says no to question 1,
hide the rows 2-10. There are approx 20 groups of rows in the
spreadsheet.

The problem with the report as it works now is that the page breaks
are positioned directly in the middle of a logical group of rows(ie:
rows all related to the same question). I want the page breaks to
fall on the boundaries of these groups, not in the middle. We have
tried adding a column of merged cells on the left the height of each
logical group of rows, but the page break still splits the merged
cell. I am thinking now that it will have to be done with VBA
somehow.

Does anyone have any idea how to position page breaks so that they
don't split a group of rows ?

Thank You