Introduction To MS Excel tutorial
Chapter 1: MS Excel Basics

Chapter 2: Editing Worksheet In Excel

Chapter 3: Formatting Cells

Chapter 4: Formatting Worksheets

Chapter 5: Working With Formulas

Chapter 6: Advanced Operations

How To Insert Page Breaks In MS Excel 2010

MS Excel offer control over the page breaks that aids in printing. If you wish to force a page break either in a vertical or horizontal manner, then here are steps to do it.

Inserting Page Breaks

If you want row 14 to act as the first row of new page, then select cell A14. Choose Page Layout, followed by Page Setup Group, Breaks, Insert Page Break.

MS Excel Tutorial

Insert vertical page break

Choose Page Layout, followed by Page Setup, Breaks, Insert Page Break and it will create a page break.

MS Excel Tutorial

Removing Page Breaks

Remove a page break you have added – Simply move the cell pointer to the first row just beneath the manual page break added by you. Now choose the Page Layout, followed by Page Setup, Breaks and Remove Page break option.

Remove all manual breaks at once – Choose Page Layout, followed by Page Setup, Breaks and Reset All Page Breaks.

Tags

You may also like...

Sorry - Comments are closed

Australia

Unknown
Humidity: 65
Wind: 9 km/h
71 F
65 93
25 Mar 2016
63 87
26 Mar 2016

Slideshow