How to Move Excel Page Breaks on Mac
Question details
The user needs to adjust the print layout by moving page breaks in Excel for Mac, and requires troubleshooting steps if the page break lines cannot be dragged.

- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Adjusting spreadsheet layouts before printing to ensure data fits correctly on physical pages.
- Observed behavior
- The user wants to manually move blue page-break lines, but may occasionally encounter a bug where the lines cannot be dragged.
Ensure your spreadsheet is saved and make sure you have standard print margins set before manually adjusting the page breaks.
Adjust Page Breaks in Page Break Preview
The most direct way to adjust where your pages break is by dragging the blue boundaries in the Page Break Preview mode.
Open your workbook in Excel for Mac. Navigate to the View tab on the top ribbon and click on Page Break Preview.
You will see blue lines indicating where the pages will break when printed. Solid blue lines are manual page breaks, and dashed blue lines are automatic page breaks.
Move your mouse pointer over the blue page-break line until the cursor changes to a double-headed move pointer. Click and drag the line to your desired location and release.

Update Microsoft Office for Mac
If the blue page-break lines cannot be moved when you drag them, it is likely due to a known glitch in older versions of Excel for Mac that requires an update.
Manage Spreadsheets and Print Layouts with WPS Office
If you are experiencing glitches with dragging page breaks in your current software, consider switching to WPS Office for Mac. It provides a lightweight, highly compatible spreadsheet environment where print formatting and page break adjustments work flawlessly.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office on your Mac and open your existing Excel (.xlsx) file.
- 2. Enter Page Break Preview: Go to the View tab in the top menu and select Page Break Preview.
- 3. Adjust the boundaries: Hover over any blue page-break line, click when the cursor changes to the move arrow, and drag it to your preferred print boundary.

Frequently Asked Questions
Why can't I drag the page break lines even after updating?
If updates did not fix the issue, check your Excel preferences. Go to Excel > Preferences > Edit, and ensure that 'Enable fill handle and cell drag-and-drop' is checked. If this is disabled, you will not be able to drag page break lines.
How do I insert a new manual page break on a Mac?
Select the row below or the column to the right of where you want the break. Go to the Page Layout tab, click on Breaks, and then select Insert Page Break.
How do I remove a manual page break?
In Page Break Preview, simply click and drag the solid blue manual page break line completely outside of the print area. Alternatively, select a cell adjacent to the break, go to Page Layout > Breaks, and choose Remove Page Break.
How do I exit Page Break Preview and return to the normal view?
To return to your standard workspace, go to the View tab on the ribbon and click on Normal.




