To give page break after each 4th row which of the following condition is correct

Insert a page break

1. Click the worksheet that you want to print.

2. On the View tab, in the Workbook Views group, click Page Break Preview.

   You can also click Page Break Preview

   on the status bar.

3. Do one of the following:

   • To insert a vertical page break, select the row below where you want to insert the page break.

   • To insert a horizontal page break, select the column to the right of where you want to insert the page break.

4. On the Page Layout tab, in the Page Setup group, click Breaks.

5. Click Insert Page Break.

You can also right-click the row or column below or to the right of where you want to insert the page break, and then click Insert Page Break.

If manual page breaks that you insert do not take effect, it may be that the Fit To scaling option has been selected on the Page tab of the Page Setup dialog box (Page Layout tab, Page Setup group, Dialog Box Launcher

Move a page break

Important: To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks.

1. To verify that drag-and-drop is enabled, do the following:

   1. Click the File tab > Options. In Excel 2007, click Microsoft Office Button

      , and then click Excel Options.

   2. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.

2. Click the worksheet that you want to modify.

3. On the View tab, in the Workbook Views group, click Page Break Preview.

   You can also click Page Break Preview

   on the status bar.

4. To move a page break, drag the page break to a new location.

   Note: Moving an automatic page break changes it to a manual page break.

Delete a page break

1. Select the worksheet that you want to modify.

2. On the View tab, in the Workbook Views group, click Page Break Preview.

   You can also click Page Break Preview

   on the status bar.

3. Do one of the following:

   • To delete a vertical page break, select the column to the right of the page break that you want to delete.

   • To delete a horizontal page break, select the row below the page break that you want to delete.

     Note: You cannot delete an automatic page break.

4. On the Page Layout tab, in the Page Setup group, click Breaks.

5. Click Remove Page Break.

You can also remove a page break by dragging it outside of the page break preview area (to the left past the row headers, or up past the column headers). If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled. For more information, see Move an existing page break.

Remove all manually-inserted page breaks

Note: This procedure resets the worksheet to display only the automatic page breaks.

1. Click the worksheet that you want to modify.

2. On the View tab, in the Workbook Views group, click Page Break Preview.

   You can also click Page Break Preview

   on the status bar.

3. On the Page Layout tab, in the Page Setup group, click Breaks.

4. Click Reset All Page Breaks.

Tip: You can also right-click any cell on the worksheet, and then click Reset All Page Breaks.

Return to Normal view

• To return to Normal view after you finish working with the page breaks, on the View tab, in the Workbook Views group, click Normal.

  You can also click Normal

  on the status bar.

  • After working with page breaks in Page Break Preview view, you may still see the page breaks in Normal view because page breaks have been turned on automatically. To hide the page breaks, close and reopen the workbook without saving it.

  • Page breaks remain visible when you close and reopen the workbook after saving it. To turn them off, click the File tab, click Options, click the Advanced category, scroll down to the Display options for this worksheet section, and clear the Show page breaks check box. For more information, see Display or hide page breaks in Normal view.

Display or hide page breaks in Normal view

1. Click the File tab > Options. In Excel 2007, click the Microsoft Office Button

   , and then click Excel Options.

2. In the Advanced category, under Display options for this worksheet, select or clear the Show page breaks check box to turn page breaks on or off in Normal view.