How to Insert a Page Break in an Excel Worksheet

Inserting and Managing Breaks

1. 
   Click the row below your desired horizontal page break location.^{[2] X Research source} For example, if you want to place a horizontal page break between rows 4 and 5, select row 5.
2. 
   Insert the horizontal page break. Return to the 'Page Layout' tab and click the arrow beneath the 'Breaks' icon. From the options, select 'Insert Page Break.' A thick line will appear where the manual break was inserted.
3. 
   Select the column to the right of your desired vertical line break. If you want to insert a vertical line break between columns C and D, for example, select column D.
4. 
   Insert the vertical page break. On the 'Page Layout' tab, click the arrow beneath the 'Breaks' icon, then select 'Insert Page Break.' A thick vertical line will indicate the location of your new break.
5. 
   Move your page break. If you decide your page break should occur at a different location than where you've originally inserted it, hold your mouse over the break until an arrow appears, then drag the arrow to another location.
6. 
   Delete a page break. If you decide you no longer want a page break you've inserted, it's possible to delete the break.

   1. Delete a vertical break: Select the column directly to the right of your vertical page break. Click the arrow beneath the 'Breaks' icon and select 'Remove Page Break.'
   2. Delete a horizontal line break: Select the column just below the horizontal page break, then click the arrow beneath the 'Breaks' icon. Select 'Remove Page Break.'
7. 
   Return to Normal view. If you don't want to see the page breaks while you work, click the 'View' menu at the top of the screen, then select 'Normal.' You can switch between these two views as needed.