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

DigitalOcean provides cloud products for every stage of your journey. Get started with $200 in free credit!

There isn’t an actual page-break property in CSS. It is actually a set of 3 properties: page-break-before, page-break-after and page-break-inside. These properties help define how the document is supposed to behave when printed. For example, to make a printed document more book-like.

Properties

page-break-before

The page-break-before property adds a page-break before the element to which it is applied.

Note: this property is in progress of being replaced by the more generic break-before property. This new property also handles column and region breaks while being syntactically compatible with page-break-before. Thus before using page-break-before, check if you can use break-before instead.

A common use case for this is to apply it to the selector #comments so a user printing a page with comments could easily choose to print the whole document but stop before the comments cleanly.

page-break-after

The page-break-after property adds a page-break after the element to which it is applied.

Note: this property is in progress of being replaced by the more generic break-after property. This new property also handles column and region breaks while being syntactically compatible with page-break-after. Thus before using page-break-after, check if you can use break-after instead.

page-break-inside

The page-break-inside property adds a page-break inside the element to which it is applied.

Syntax

page-break-after : auto | always | avoid | left | right page-break-before : auto | always | avoid | left | right page-break-inside : auto | avoid

The left and right values for page-break-before and page-break-after refer to a spread layout (like a book) where there are distinct left and right pages. They work like this:

• left forces one or two page breaks after the element so that the next page is formatted as a left page.
• right forces one or two page breaks after the element so that the next page is formatted as a right page.

Consider always as a mix of both. The specification says:

A conforming user agent may interpret the values ‘left’ and ‘right’ as ‘always’.

Example

@media print { h2 { page-break-before: always; } h3, h4 { page-break-after: avoid; } pre, blockquote { page-break-inside: avoid; } }

This code snippet does 3 things:

• it forces a page-break before all h2 headings (perhaps h2 tags in your document are chapter titles that deserve a fresh page)
• it prevents page-breaks right after sub-headings because that looks odd
• it prevents page-breaks inside pre tags and block-level quotes

• @page
• break-after
• break-before
• orphans
• widows

Other resources

• page related properties in the CSS specifications
• break-before and page-break-before at MDN
• break-after and page-break-after at MDN
• page-break-inside at MDN

Browser Support

ChromeSafariFirefoxOperaIEAndroidiOS

Any	Any	Any	7+	4+	TBD	TBD

You can print from mobile devices, like AirPrint on iOS, but we haven’t tested this much. If anyone has data on support, let us know.

The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2010 - 2016, where to find the Page Break Preview, hide and show the marking lines.

Page breaks are separators that divide a worksheet into individual pages for printing. In Excel, page break marks are inserted automatically according to the paper size, margin and scale options. If the default settings don't work for you, you can easily insert page breaks in Excel manually. It's really helpful for printing a table with the exact number of pages you want.

In this post, I'll show you how to use the Excel Page Break Preview to easily see the changes you make. Also, you'll see how you can adjust the page breaks in the worksheet before printing, how to remove, hide or show page breaks.

How to insert a page break in Excel manually

If you go to the Print Preview pane and don't like the way your Excel data is laid out for printing across several pages, you can manually insert page breaks where you need them. Below you'll find the steps showing how to do it.

1. Pick your Excel worksheet where you need to insert page breaks.
2. Go to the View tab in Excel and click on the Page Break Preview icon in the Workbook Views group.
   

   Tip. You can also see where page breaks will appear if you click Page Break Preview Button image on the Excel status bar.
   

   Note. If you get the Welcome to Page Break Preview dialog box, click OK. Tick the Do not show this dialog again check box to avoid seeing this message again.

3. Now you can easily view the location of page breaks in your worksheet.
   

   Tip. On more way of inserting page break in Excel is to go to the Page Layout tab, click Breaks in the Page Setup group and select the corresponding option from the drop-down list.
   

Note. If manual page breaks that you add don't work, you may have the Fit To scaling option selected (Page Layout tab -> Page Setup group -> click Dialog Box Launcher Button image -> Page). Change the scaling to Adjust to instead.

On the picture below, you can see 3 horizontal page breaks added. Therefore, if you go to Print Preview, you'll see different parts of data on separate sheets.

Insert a page break in Excel by condition

If you often print your data tables, you may want to learn how to automatically insert page breaks in Excel by condition, for example when a value in certain column changes. Say you have column named Category and you want each category to be printed on a new page.

Below, you'll find several helpful macros and the steps how to add page breaks using the Excel built-in Subtotal functionality.

Use macros to add the marking lines

Below you can find two really useful macros. They will remove all default page breaks in your table and will easily add new marking lines at the appropriate locations.

Just select the range of cells you want to use for splitting and avoid the headers.

• InsertPageBreaksIfValueChanged - inserts page breaks if the value in the column changes.
• InsertPageBreaksByKeyphrase - adds a page break each time it finds a cell that contains "CELL VALUE" (it's the entire cell, not part of it, don't forged to replace "CELL VALUE" in macro with your actual key phrase).

If you are novice in VBA, feel free to read How to insert and run VBA code in Excel 2010, 2013 - tutorial for beginners.

Sub InsertPageBreaksIfValueChanged() Dim rangeSelection As Range Dim cellCurrent As Range Set rangeSelection = Application.Selection.Columns(1).Cells ActiveSheet.ResetAllPageBreaks For Each cellCurrent In rangeSelection If (cellCurrent.Row > 1) Then If (cellCurrent.Value <> cellCurrent.Offset(-1, 0).Value) Then ActiveSheet.Rows(cellCurrent.Row).PageBreak = _ xlPageBreakManual End If End If Next cellCurrent End Sub Sub InsertPageBreaksByKeyphrase() Dim rangeSelection As Range Dim cellCurrent As Range Set rangeSelection = Application.Selection ActiveSheet.ResetAllPageBreaks For Each cellCurrent In rangeSelection If cellCurrent.Value = "CELL VALUE" Then ActiveSheet.Rows(cellCurrent.Row + 1).PageBreak = _ xlPageBreakManual End If Next cellCurrent End Sub

Use subtotals to insert page breaks

Have you ever thought of Subtotal as of an option for inserting page breaks in Excel? This feature actually makes the process rather easy.

1. Make sure your table has headers. For example, if column A contains category names, then cell A1 should have the label "Category." Make sure all columns in your table contain headers.
2. Select the range with your data. Go to Data -> Sort -> Sort by Category. Click OK to see your data parts ordered:
   
3. Select any cell within your table, go to the Data tab and click on the Subtotal icon.
4. You will see the Subtotal dialog box.
   • Select your key column from the At each change in: drop-down list. In my table, it's Category.
   • Pick Count from the Use function list.
   • Select the correct checkbox in the Add subtotal to: group.
   • Make sure the Page break between groups check box is selected.
   • Click on OK.

You can delete the rows and cells with totals if you don't need them and get your table with page breaks automatically inserted according to the selected settings.

How to remove page breaks in Excel

Though it's not possible to remove page breaks that Excel adds automatically, you can easily delete those you inserted manually. You can choose to remove certain marking line or remove all manually inserted page breaks.

Delete a page break

Please follow the steps below to remove a page break in Excel.

1. Select the worksheet where you want to delete the page break mark.
2. Click on the Page Break Preview icon under the View tab or click Page Break Preview Button image on the status bar.
3. Now select the page break you need to remove:
   • To delete a vertical break, select the column to the right of the line. Then right-click on it and select the option Remove Page Break.
   • To remove a horizontal page break, select the row below the line that you want to delete. Right-click on this row and pick the Remove Page Break option from the list.

Tip. You can also delete a page break by dragging it outside the page break preview area.

Remove all inserted page breaks

If you need to delete all page breaks, you can use the Reset All Page Breaks functionality.

1. Open the worksheet that you want to modify.
2. Click on the Page Break Preview icon under the View tab or click Page Break Preview Button image on the status bar.
3. Go to the Page Layout tab in the Page Setup group and click Breaks.
   
4. Pick the Reset All Page Breaks option.

Tip. You can also right-click any cell on the worksheet and select Reset All Page Breaks from the menu list.

Move a page break in Excel

One more option you may find helpful is dragging a page break to another location in a worksheet.

1. Click Page Break Preview on the View tab or click Page Break Preview Button image on the status bar.
2. To move a page break, just drag it to a new location.
   

Note. After you move an automatic page break, it becomes a manual one.

Hide or show page break marks

Below you'll find how to display or hide page breaks in the Normal view

1. Click the File tab.
2. Go to Options -> Advanced.
3. Scroll down to the Display options for this worksheet group and tick or clear the Show page breaks check box.
   

Now you know how to easily turn page breaks on or off in the Normal view.

Reset back to the Normal view

Now that all your page breaks found the correct location, you can return to Normal view. It's as simple as clicking on the Normal icon under the View tab in Excel.

You can also click Normal Button image on the status bar.

That's it. In this article I showed how to use the Excel page break option. I tried to cover all its options and now you know how to insert, remove, show, hide and move page breaks to adjust them before printing. You've also got several helpful macros to add marking lines by condition and learnt to work in the Excel Page Break Preview mode.

Please let me know if you have any questions. Be happy and excel in Excel!

You may also be interested in

What are the 4 types of section breaks?

Why is there a page break in my table in Word?

Which tab is page break and section break in?

What is page break with example?