Excel 2007 manual page break problem

In Excel , click Microsoft Office Button, and then click Excel Options. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK. Click the worksheet that you want to modify. On the View tab, . Reset all page breaks first by www.doorway.rullPageBreaks. Then define the automatic part of your page breaks by www.doorway.ruagesWide = 1 www.doorway.ruagesTall = False Do not set the Zoom. It is set to False by above lines. Place a manual horizontal page break at the end of each page, that should contain less rows than automatically set.  · What is the VBA command for that page break? Here is my code: Dim HighlightRange As RangeDim StoreCell As RangeSet HighlightRange = SelectionFor Each StoreCell In HighlightRange www.doorway.ru(www.doorway.ru).PageBreak = xlPageBreakNone If www.doorway.ru www.doorway.ru(-1, 0).Value Then www.doorway.ru(www.doorway.ru).PageBreak = .

1) Got to the row you want to be the first row of a new page. 2) Go to each cell that has data or formatting in it and make sure that "merge cells" is turned off. 3) Click a cell in that row or the select the entire row. 4) Click INSERT | MANUAL BREAK | ROW BREAK. Adjusting Page Breaks in Excel The Page Break Preview feature in Excel enables you to spot page break problems in an instant as well as fix them, such as when the program wants to split onto different pages information that you know should always appear on the same page. Re: Automatic Page Break problem. Originally Posted by shg. Check the print area, paper size, and margins. Thanks shg. I have checked all of these and they seem mostly normal. My bottom margin is very small at", and it won't let me make it bigger. Paper is x Only thing that is weird is it doesn't seem to let me "clear" the print area.

On printing worksheet you might not be satisfied with the current pagination, so you might need to insert or remove manual page break. Dec 2, Inserting a manual page break in Excel spreadsheets can make it easier Excel , Excel , Excel , Excel , and Excel To set a vertical page break, select an entire column. At the Page Layout Ribbon, click the Breaks icon and select Insert Page Break (Figure D).