A page break is where a file divides when you print it. They exist in spreadsheets too. Let’s learn how to work with page breaks in Microsoft Excel.
How to View Page Breaks in Excel
Often, you may want to print out your Excel spreadsheets. When you do, it’s helpful to know where the rows and columns will split across multiple sheets of paper. These are called page breaks, and they’re easy to see and manipulate in Excel.
Consider a lengthy spreadsheet. It won’t fit on a single sheet of paper, so somewhere, there will be page breaks. To display them, find the View tab on Excel’s ribbon. Views in Excel default to Normal view, which is the standard workspace. To view page breaks, click on the Page Break Preview button.
Excel is now in the Page Break Preview mode. Page breaks are indicated by the blue dashed lines visible as you scroll through the spreadsheet.
If you want to change the location of a page break, click and drag on the dashed lines. Move to a new row, and release. You’ll see that the line is now solid blue. This signifies a page break that you’ve added manually.
How to Add Page Breaks in Excel
Sometimes, you’ll want to add page breaks manually. To do this, go to the Page Layout tab on the ribbon, while still working in the Page Break Preview mode.
Imagine that you want to break at row 30. Highlight the row immediately below by clicking on row 31’s row number. Then, on the menu bar, click the Breaks dropdown and choose Insert Page Break.
Excel will instantly insert a new page break at the selected location.
As you can see, it’s easy to work with page breaks in Microsoft Excel. This is a great way to precisely control the look and feel of your printed spreadsheets.