1. Select the range that you will insert page breaks after every x rows, and click Printing > Insert Page Break Every Row on the Kutools Plus tab. 2. In the opening Insert Page Break Every Row dialog box, specify the interval of rows that you will insert page breaks at, and click the Ok button.
What is an automatic page break?
When you fill a page with text or graphics, Word inserts an automatic page break and starts a new page. An automatic page break is indicated by a dotted line. A manual page break is a dotted line labeled “Page Break”.
Why can’t I move an automatic page break in Excel?
Cause. This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared. To locate the Enable fill handle and cell drag-and-drop check box, click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.
How do I get rid of the dotted page break in Excel?
How to Remove Dotted Lines in Excel
- Click on the File tab.
- Click on Options.
- In the Excel Options dialog box that opens, click on the Advanced option in the left pane.
- Scroll down to the section – “Display options for this worksheet”
- Uncheck the option – “Show page breaks”
How do I fix page breaks?
Click the Layout or Page Layout tab. Next, click Breaks in the Page Setup section. In the Line and Page Breaks tab, choose the settings you want to apply. Turn these all off to reduce automatic page breaks.
Why Cannot drag in Excel?
Click File > Options. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box. If you do not want Excel to display a message about overwriting non-blank cells, you can clear this check box.
Why is my page break a dotted line?
It sounds like you accidentally changed your view. Please open your document and go to View (in the action bar) > Print layout and click on Print layout to put a check mark there.
