Insert, move, or delete page breaks in a sheet
When you print, page breaks appear automatically where content on a sheetThe primary document you use in Excel to store and work with data. A sheet consists of cells organized into columns and rows, and is always part of a workbook. Also called a spreadsheet. "breaks" or continues to the next page. In normal view, they appear as dashed horizontal and vertical lines; in page layout view, they appear as empty spaces between the pages. You can adjust where automatic page breaks occur and add your own page breaks manually. You can also remove manual page breaks, but you cannot remove automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages.
Do any of the following:
View page breaks
Insert a horizontal or vertical manual page break
Move a page break
Remove a manual page break
Remove all manual page breaks