How to Insert a Page Break in an Excel Sheet

Table of contents:

How to Insert a Page Break in an Excel Sheet
How to Insert a Page Break in an Excel Sheet
Anonim

To print an Excel worksheet and get exactly the number of pages you want, you can manually adjust the page breaks before printing. This tutorial shows how to insert a page break in Excel.

Steps

Insert a Page Break in an Excel Worksheet Step 1
Insert a Page Break in an Excel Worksheet Step 1

Step 1. Select the worksheet you want to print

Insert a Page Break in an Excel Worksheet Step 2
Insert a Page Break in an Excel Worksheet Step 2

Step 2. Go to the 'View' menu tab, then press the 'Preview Page Break' button, located in the 'Workbook Views' group

Insert a Page Break in an Excel Worksheet Step 3
Insert a Page Break in an Excel Worksheet Step 3

Step 3. If the page orientation is vertical, select the next line where you want to insert the page break

Insert a Page Break in an Excel Worksheet Step 4
Insert a Page Break in an Excel Worksheet Step 4

Step 4. If the page orientation is horizontal, insert the page break in the column to the right of the point where you want the page break to take place

Recommended: