Whether you're formatting a report, resumé, or simply want to tidy up your Excel 365 workbook, adjusting page breaks can be a handy tool. It can save you time and improve the overall presentation. So, let's dive into how to change page breaks in Excel 365.

Before we delve into the details, it's crucial to understand that Excel treats each printed page as a separate sheet. This means you can set page breaks to control how your data wraps and flows between pages. Let's now look at how to do this.

Setting Page Breaks Manually
Manually setting page breaks is useful when you want to control where a page ends and another begins. Here's how to do it:

In your Excel 365 workbook, click anywhere in the cell below where you want to start a new page. Then go to the 'Layout' tab under 'Page Setup'. In the 'Page Setup' group, click on 'Breaks' and select 'Insert Page Break'. The page break will be inserted at the clicked cell.
Inserting Multiple Page Breaks

If you need to insert multiple page breaks, you can follow the same steps. Just click in the cell you want the next page break to appear and repeat the process. Remember, the page break will be inserted below the cell you click.
You can also delete a page break by selecting the cell below the break and clicking 'Remove Page Break' in the 'Breaks' menu. Be careful, as deleted breaks can't be recovered.
Displaying Page Breaks

Sometimes, you might want to see where your page breaks are so you can adjust them as needed. You can make Excel display page breaks like dashed lines. To do this, go to the 'File' tab, click on 'Options' and choose 'Customize Ribbon'. Under 'Customize Ribbon', select 'All Tabs' and then click on 'Display'. Check the box next to 'Sheet tab separators' to show page breaks.
Now, you'll see dashed lines where your page breaks are, making it easier to adjust them if necessary.
Adjusting Print Area

Another way to control page breaks is by adjusting the print area. This can be particularly useful when you want to print only specific data within a large worksheet. Here's how to set a print area:
Select the cells you want to print. Then, go to the 'Page Layout' tab and click on 'Print Area' in the 'Page Setup' group. Select 'Set Print Area'. Now, only the selected cells will print, and page breaks will be adjusted accordingly.

















![1 Minute Excel Magic! [Video] in 2025 _ Microsoft excel tutorial](https://i.pinimg.com/originals/5e/0e/65/5e0e652ed9911c1b7dcfcca11f1a985a.jpg)
Changing Scaled to Fit Options
When you adjust the print area, you might find that your data doesn't fit on the page as expected. This could be because Excel automatically adjusts the scale of your data to fit the printed page. You can change this setting:
Go to the 'Page Layout' tab and click on 'Fit' in the 'Scale to Fit' group. You can choose options like '1 page wide' or '1 page tall', or enter a custom scale. Changing this setting can help control how your data fits on the page and adjusts page breaks.
Additionally, you can preview and adjust your print settings by clicking on 'Print' in the 'File' tab. This can help you ensure your data looks just the way you want it to before you print.
Changing page breaks in Excel 365 is a powerful tool, but like any tool, it's only as useful as how well you understand and use it. Practice and experimentation are key to mastering page breaks. Happy formatting!