Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Example:

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

1 Answer 1

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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.