Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any way to declare a cell/row in Excel as a cell/row that should not be used for page break.


A1: 1. My content title in bold
A2: Empty row
A3: More and more content, description, etc...on many lines.
A4: 2. My other content title in bold
A5: Empty row
A6: More and more content, description, etc...on many lines.

If that goes on for many pages, I would like Excel not to break between A1 and A3, A4 and A6, etc.

Is that feasible?

share|improve this question
up vote 1 down vote accepted

The easiest and most fool-proof way will be to manually assign page breaks. Go to:

View->Page Break Preview

On this view you can drag page breaks (the dotted lines) to where you want, both horizontally and vertically. Excel will automagically adjust the size of the text/cells/etc. to fit into your specified breaks.

share|improve this answer
The problem is that the document is programmatically generated. The size of cells can change every time. – Vincent Sep 8 '10 at 15:31
That's trickier...I don't think there will be a way to do it without a custom VBA script for this. – JNK Sep 8 '10 at 15:40
What would you like to determine the pagebreak? Your example seems to indicate empty intervening rows. Will you want to break following some of those, because you could set pagebreaks programatically if it is known where you want to allow it. – datatoo Sep 8 '10 at 16:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .