Excel: Insert manual page break
Even if a page break is rarely used in the Microsoft Excel spreadsheet, it can be inserted and removed quite simply. Here we show you how to do it.
Insert page break in Excel table
- Open the relevant document in Excel and click on the head of the row or column before which you want to insert the break.
- Select the "Page layout" tab at the top. Below you will find the item "Breaks".
- Click on it and choose "Insert Page Break".
- To remove, go the same way and this time select "Remove page breaks" or "Reset all page breaks".
The instructions refer to Microsoft Excel 2010 under Windows 8 Pro. You can find out how to swap columns, fix rows, or even compare rows in Excel in these practical tips.