How to Insert a Page Break in Excel Manually
If you go to the Print 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.
Step 1: Page Break View
Go to Page Break View, present in the right-most corner of your status bar.
Step 2: Select the Area
As you want to divide your worksheet into four parts. So, keep your active cell at G11. The page breaks are always created from the top left corner of your cell.
Step 3: Page Layout Tab
Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Insert Page Break.
Step 4: Page Break Appeared
Two-page breaks appear i.e. horizontal and vertical page breaks. This divides your sheet into four halves. You can observe that the default dotted line has disappeared automatically.
Step 5: Select the Column
Let’s roll back to the original data set. What if you want only a vertical page break to be inserted in your sheet? Select the entire column G in your worksheet.
Step 6: Insert Page Break
Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Insert Page Break.
Step 7: Page Divided
Your page gets, divided vertically into 2 sections i.e. Page 1 and Page 2.
Step 8: Select the Row
Let’s again roll back to our original data set. What if you want only a horizontal page break to be inserted in your sheet? Select the entire row 11 in your worksheet.
Step 9: Insert Page Break
Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Insert Page Break.
Step 10: Page Divided
Your page gets, divided horizontally into 2 sections i.e. Page 1 and Page 2.
How to Insert or Remove Page Breaks in Excel
Excel has the functionality to print its data directly from the Excel sheet itself. But here comes the problem, if you have data of 300 rows, then you cannot print the entire data on a single sheet of paper, data needs to be divided among different sheets equivalently. Excel can do this automatically. Excel distributes table data into different sheets. But what if we need to distribute our data in a custom user-defined format? Here comes the role of Page Breaks in Excel. Excel provides functionality to design your page breaks, and when or where to start or end your printing. Let’s learn how to Insert, Move, or Delete Page Breaks in Excel.
Contact Us