How to Hide Page Breaks in Excel and Keep Print Layout

To hide page-break lines in Excel for Microsoft 365 on Windows, open File > Options > Advanced, find Display options for this worksheet, clear Show page breaks, and select OK. This hides the indicators on the selected worksheet; it does not remove page breaks or change how the worksheet prints. If you are viewing the sheet in Page Break Preview, switch to View > Normal as well.

What You’ll Need

Excel for Microsoft 365 on Windows, or a desktop Excel version with the worksheet display settings.
The workbook and the worksheet where the page-break lines appear. The setting is applied to a worksheet, so identify the correct tab first.
Edit access to the workbook. If it is read-only or protected in a way that prevents changes, you may need permission or an editable copy to save the setting.

Step-by-Step

Open the worksheet you want to clean up. Select its tab at the bottom of the Excel window. If several worksheets have page-break lines, you will need to check the setting for each one. Avoid selecting multiple sheet tabs as a group unless you intend to make any worksheet-level changes to all of them.
Check the current view. Select the View tab on the ribbon. If Page Break Preview is selected, click Normal in the Workbook Views group. Page Break Preview is designed to show page boundaries, so its blue page outlines and labels are not the same as the page-break indicators shown in Normal view. Switching to Normal may be all you need if the lines appeared because the workbook was left in that view.
Open Excel Options. Select File, then Options near the bottom of the left-hand menu. This opens the Excel Options dialog. If the Options command is not visible, widen the Excel window or look at the bottom of the File menu; it is separate from worksheet options on the ribbon.
Go to the advanced display settings. In Excel Options, select Advanced in the left-hand list. Scroll down to the section labeled Display options for this worksheet. It is not the general Display section at the top of the page, so keep scrolling if you do not see the worksheet-specific controls right away.
Choose the correct worksheet in the dropdown. The dropdown under Display options for this worksheet names the sheet whose display settings you are changing. Select the worksheet tab you opened in step 1. This matters in a workbook with multiple sheets: changing the checkbox for one sheet does not necessarily hide the indicators on every other sheet.
Turn off the page-break indicators. Clear the checkbox labeled Show page breaks. Do not change related settings such as Show row and column headers unless you also want those items hidden. Click OK to close Excel Options and return to the worksheet.
Confirm the result and save. In Normal view, the dashed or solid page-break lines should no longer appear on the selected worksheet. Save the workbook if you want to keep the change. If lines remain, confirm that the right worksheet was selected in the Advanced settings and that you are not still in Page Break Preview.

The key distinction is that this procedure changes what Excel displays, not the worksheet’s print setup. Existing automatic and manual page breaks still determine where printed pages end. You can therefore make the grid easier to work with while keeping the existing print layout intact.

Common Mistakes

Looking for the checkbox on the ribbon. The Show page breaks checkbox is in File > Options > Advanced, under Display options for this worksheet. It is not a toggle in the View tab on Windows.
Changing the wrong sheet’s setting. The dropdown in the Advanced section can point to a different worksheet than the one currently in view. Verify its name before clearing the checkbox, particularly if several tabs have similar names.
Expecting the print layout to change. Hiding the lines is not the same as removing or moving page breaks. Do not use this display setting if your goal is to fit the sheet onto fewer printed pages; adjust page setup or the breaks themselves instead.
Expecting Normal view to show no page boundaries in every situation. Page Break Preview deliberately displays boundaries. Return to Normal view and then hide the indicators if you want a clean editing view.
Assuming the setting applies to the whole workbook. The setting is tied to the selected worksheet. Check each relevant sheet rather than assuming one checkbox changes every tab.

Tips

Distinguish the line from the page boundary. In Normal view, Excel may show dashed lines for automatic breaks and solid lines for manual breaks. Their appearance can vary with the workbook’s print setup. Turning off Show page breaks hides these indicators; it does not erase either kind of break.
Use Page Break Preview when you need to inspect printing. If you are preparing a report, this view makes page boundaries and page numbers easier to see. Switch back to Normal for everyday editing, and disable the indicators there if they distract you.
Keep an unchanged print layout when hiding lines. Because the display checkbox does not alter print settings, there is no need to reset breaks just to make the worksheet look less cluttered. You can still use Print Preview or File > Print to review the output.
Hide indicators on only the sheets where they bother you. A data-entry sheet may benefit from a clean grid, while a report sheet may benefit from visible boundaries during page setup. Set each worksheet according to how you use it.
Be cautious with grouped worksheets. If multiple sheet tabs are selected together, Excel treats them as a group for many editing actions. Click a single tab before changing workbook settings, and confirm that only the intended sheet is active.
Know when to reset rather than hide. If you deliberately inserted manual page breaks and want to remove them, use Page Layout > Breaks > Reset All Page Breaks. That changes the page-break setup, unlike clearing Show page breaks. Review the print layout before and after resetting.

Troubleshooting

The lines are still visible after I cleared the box. First check View > Normal. Page Break Preview continues to show page boundaries because displaying them is its purpose. If you are already in Normal view, reopen File > Options > Advanced and make sure the dropdown under Display options for this worksheet names the sheet with the lines. Clear Show page breaks again if it is selected, click OK, and check whether the indicators disappear.

I cannot find Display options for this worksheet. In Excel Options, select Advanced and scroll down; the worksheet-specific section is lower on the page than many general editing options. You can also maximize the Options dialog to make scrolling easier. Make sure you are in the Windows desktop application: the Excel web app does not provide the same Windows Options dialog and worksheet checkbox.

The lines return when I reopen the workbook. Confirm that you saved the workbook after changing the setting. If the file is opened from a shared location, check that you saved your changes to the intended file rather than a temporary or read-only copy. Also verify that the workbook opens on the same worksheet and in Normal view; another sheet or view can make it seem as though the setting was not retained.

I want to change where pages end, not just hide the lines. Keep the indicators visible while you adjust the print setup. Use Page Layout > Breaks to insert or remove manual breaks, or use Page Layout controls such as Orientation, Size, and Scale to Fit to change how the sheet is laid out for printing. The exact result depends on the selected print area, paper size, margins, and scaling. Check File > Print before distributing the worksheet.

I use Excel for Mac or Excel for the web. In Excel for Mac, open Excel > Settings (or Preferences in some releases) > View and look under Window options for the Page breaks checkbox. Turn it off for the relevant sheet and return to Normal view. Names and placement can vary slightly between Mac releases. In Excel for the web, the Windows Advanced setting described above is not available; open the workbook in the desktop app to change that display option.

Frequently Asked Questions

Does hiding page breaks change how my worksheet prints?
No. Clearing Show page breaks hides the on-screen indicators in Normal view. Existing breaks, print areas, scaling, margins, and paper settings continue to control the printed pages.

Why do I still see blue lines after turning off Show page breaks?
You may be in Page Break Preview, where page boundaries are shown as part of the view. Select View > Normal. If the lines remain in Normal view, check that the checkbox was changed for the correct worksheet.

Can I hide page breaks for every worksheet at once?
The Windows checkbox is associated with the worksheet selected in the Advanced section. Repeat the change for each sheet where you want the indicators hidden. Before changing settings, make sure you are not working with grouped sheet tabs.

Will hiding the lines remove manual page breaks?
No. The breaks remain in the print layout. To remove manual breaks, use Page Layout > Breaks > Reset All Page Breaks, understanding that this changes the layout rather than merely hiding its indicators.

Can I hide page breaks in Excel for the web?
The web app does not offer the same worksheet-level Show page breaks option as Excel for Windows. Open the workbook in the desktop app to change this setting. You can still review the web app’s available print options, but they are separate from the Windows display checkbox.

Does this setting hide gridlines too?
No. Page-break indicators and worksheet gridlines are separate display elements. If you also want to hide gridlines, use the View tab’s Show group and clear Gridlines; doing so changes the grid’s appearance, not the page-break setup.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.