• Excel Video Tutorials

Insert Page Break in Excel 2010


Advertisements

Page Breaks

If you don’t want a row to print on a page by itself or you don't want a table header row to be the last line on a page. MS Excel gives you precise control over page breaks.

MS Excel handles page breaks automatically, but sometimes you may want to force a page break either a vertical or a horizontal one. so that the report prints the way you want.

For example, if your worksheet consists of several distinct sections, you may want to print each section on a separate sheet of paper.

Inserting Page Breaks

Insert Horizontal Page Break − For example, if you want row 14 to be the first row of a new page, select cell A14. Then choose Page Layout » Page Setup Group » Breaks » Insert Page Break.

Insert Horizontal Page Break

Insert vertical Page break − In this case, make sure to place the pointer in row 1. Choose Page Layout » Page Setup » Breaks » Insert Page Break to create the page break.

Insert Vertical Page Break

Removing Page Breaks

  • Remove a page break you’ve added − Move the cell pointer to the first row beneath the manual page break and then choose Page Layout » Page Setup » Breaks » Remove Page Break.

  • Remove all manual page breaks − Choose Page Layout » Page Setup » Breaks » Reset All Page Breaks.

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements