How to Remove Page Break in Excel
Step 1: Select the Cell
Considering you have created a page break as shown above. Now, you need to remove the page break as per your wish. Go back to cell, G11.
Select the cell
Step 2: Go to Page Layout Tab
Go to the Page Layout tab. Under the Page Setup section, click on Breaks. A drop-down appears. Select Remove Page Break.
Page Layout Tab
Step 3: The Page Break gets Removed
Page Break Removed
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