To see where Excel’s printed pages end, choose View > Page Break Preview; the blue lines show page boundaries, and the gray area is outside the printable pages. To see page-break lines while staying in Normal view, use File > Options > Advanced, select the worksheet under Display options for this worksheet, and turn on Show page breaks.
What Excel’s print area lines indicate
People often use “print area lines” to mean either the edges of a defined print area or the lines dividing a worksheet into printed pages. Excel’s most useful on-screen guides are usually page-break lines: they show where one page ends and the next begins when the sheet is printed. They are not cell borders, and they do not print as marks on the paper.
A print area is a range of cells that Excel is instructed to print. You can set one to keep a large worksheet from printing every used cell. Page breaks, by contrast, divide the printable content into pages. A defined print area may cover several pages, so its outer edge and the internal page-break lines are related but not identical. In Page Break Preview, the page outlines and gray surrounding area make the distinction easier to see.
Excel can create automatic breaks based on paper size, margins, scaling, and the amount of content. You can also insert manual breaks to control where a page ends. If a workbook’s page breaks seem unexpected, those settings—not a missing border—are usually the reason.
Show page boundaries in Page Break Preview
For a quick overview of how a worksheet will divide across pages, use Page Break Preview in Excel for Microsoft 365 on Windows:
- Open the worksheet you plan to print.
- Select View > Page Break Preview.
- If Excel asks whether to display page breaks, confirm the prompt.
- Inspect the blue boundaries. The numbered page regions indicate the pages Excel expects to print, while the gray area is outside the current print area or page range.
You can drag some blue page-break lines to change where pages divide. A solid blue line represents a manual page break; a dotted blue line represents an automatic break. The preview can also show a page number watermark, which is only an on-screen aid. To return to the usual grid, select View > Normal.
This view is especially helpful when columns spill onto an extra page or when a long table breaks in the middle of a section. It presents the page layout directly, so you do not have to infer the printed result from the worksheet grid.
Show page-break lines in Normal view
If you prefer to work in the standard grid while keeping page boundaries visible, enable the worksheet’s page-break display. In Excel for Microsoft 365 on Windows:
- Select File > Options.
- Choose Advanced.
- Scroll to Display options for this worksheet.
- In the worksheet list, choose the sheet whose lines you want to show.
- Select Show page breaks, then click OK.
The setting applies to the selected worksheet, so repeat the steps for other sheets if needed. In Normal view, Excel generally draws page breaks as dashed lines. These guides can be useful for editing, but they are less visually clear than the page outlines in Page Break Preview.
If the lines do not appear immediately, first check that the correct worksheet is selected in the options list. Page-break guides may also become visible after opening Print or Print Preview. The setting controls whether Excel displays the guides in the grid; it does not create or change a print area.
Set or change the worksheet’s print area
To define exactly which cells Excel should print, select the range and choose Page Layout > Print Area > Set Print Area. For example, if a worksheet contains a report in A1:F35 and notes in H1:J20, select A1:F35 before setting the print area. The notes will then be excluded from printing unless you change or clear the area.
To remove the defined range, choose Page Layout > Print Area > Clear Print Area. You can then set a different range. Excel stores the print area with the worksheet, so it can remain in place when the workbook is saved and reopened.
A few details matter when selecting ranges:
- To print more than one separate selection, hold Ctrl while selecting the ranges on Windows, then set the print area. Excel prints separate print areas as separate pages rather than treating gaps between them as ordinary content.
- Setting a new print area replaces the existing print area for that worksheet. Clear the old one if you want to start over.
- Hidden rows and columns, scaling, and page setup can affect what appears in the final pages, so setting the range alone does not guarantee a particular number of pages.
Choose the view that answers your question
Excel has several ways to inspect a worksheet’s printed layout, and they serve different purposes:
- Normal view: Best for entering and editing data. Page-break lines can be displayed as guides, but the screen remains a worksheet grid.
- Page Break Preview: Best for seeing page divisions and the area Excel will print. It also lets you adjust many page breaks by dragging their boundaries.
- Page Layout view: Best for checking page margins, headers, footers, and how content sits on individual pages. Choose View > Page Layout. It is a page-oriented editing view rather than simply a set of break lines over the grid.
- Print Preview: Best for checking the final output before sending it to a printer or saving it as a PDF. Press Ctrl+P on Windows, or use File > Print. Press Esc to leave the print screen on Windows.
For instance, use Page Break Preview to find why a six-column report spans two pages wide, then use Print Preview to confirm the actual page appearance. A worksheet can look tidy in Normal view and still print poorly because its paper orientation or scaling is unsuitable.
Adjust breaks when pages split in the wrong place
Excel’s automatic breaks respond to the print settings. A small change to margins, paper size, orientation, or scaling may move a boundary. If you need a table to fit across one page, consider Page Layout > Orientation > Landscape or adjust scaling in the Page Layout options. Fit-to-page scaling can reduce text size, however, so inspect the result in Print Preview rather than assuming that fewer pages always means a better printout.
To insert a manual break, select the row below where a horizontal break should go, or the column to the right of where a vertical break should go. Then choose Page Layout > Breaks > Insert Page Break. A manual break gives you more control, but it can become inconvenient if the content grows or the page setup changes. To remove manual breaks and restore automatic pagination, choose Page Layout > Breaks > Reset All Page Breaks.
For example, a monthly report might have a heading and summary in rows 1–8 and detail rows below. Inserting a break above the detail section can keep the summary together, but a later increase in font size could push more content onto additional pages. Recheck the preview after changing the layout.
Why lines may be missing or confusing
When the expected guides are absent, check the view and worksheet-level display setting first. Page-break lines are not permanent borders, and turning on worksheet gridlines does not turn them on. The View > Show > Gridlines control affects the cell grid; it is separate from the page-break display setting.
Also check whether a print area is set. In Page Break Preview, a defined print area can make cells outside it appear gray, which some users mistake for hidden worksheet data. The cells remain in the workbook; the shading indicates that they are outside the current print range. Use Page Layout > Print Area > Clear Print Area if you intend to print a wider range.
If a line appears in an unexpected location, review orientation, paper size, margins, scaling, and any manual breaks. A dotted break is usually automatic; a solid break is usually one that was manually added. You can drag a break in Page Break Preview, but changing the page setup may later reposition automatic boundaries.
Hide page-break lines without changing printing
To remove the guides from Normal view, return to File > Options > Advanced, choose the relevant worksheet under Display options for this worksheet, and clear Show page breaks. This only hides the on-screen indicators. It does not erase a print area, remove manual breaks, or change what Excel prints.
If you are in Page Break Preview, select View > Normal to leave that view. To change the actual page divisions, use the Breaks commands or adjust the page setup; hiding the lines is not a substitute. That distinction is useful when sharing a workbook: the recipient may see different guides depending on their view settings, while the worksheet’s print setup remains saved with it.
Excel for Mac and Excel for the web
In Excel for Mac, Page Break Preview is available from the View tab, and the Normal and Page Layout views serve the same general purposes. The location of the preference for displaying page breaks in Normal view can vary by Mac release; look in Excel’s settings or preferences under the View options. The Windows path through File > Options > Advanced does not apply to Mac.
Excel for the web has more limited page-layout controls than the desktop application. If you need to drag page breaks, manage manual breaks, or inspect the full desktop Page Break Preview, open the workbook in the desktop version of Excel. You can still use the web app’s print command to review its available print output, but the printed pagination should be checked in the version you will use to print.
Frequently Asked Questions
How do I show print lines in Excel?
Choose View > Page Break Preview to see page boundaries. To show page-break guides in Normal view on Windows, enable Show page breaks under File > Options > Advanced for the selected worksheet.
Do page-break lines print on the paper?
No. They are layout guides on screen, not cell borders or printed marks. To create visible lines in the printed document, apply actual cell borders or use another formatting method.
Why are some cells gray in Page Break Preview?
Gray cells are outside the current printable page area or defined print area in that view. They are still part of the worksheet. Clear or reset the print area if those cells should be included.
How do I remove a dotted page-break line?
A dotted line usually marks an automatic break. You can hide page-break guides in the worksheet’s Advanced display options, or change page setup to move the break. To clear manual breaks, choose Page Layout > Breaks > Reset All Page Breaks.
Why does Excel show a page break after I print?
Excel may display page-break guides in Normal view after you inspect print output. If you do not want to see them, turn off Show page breaks for that worksheet; this does not alter the printed pages.
Related
- Excel: Protect a Sheet but Keep Slicers Usable for Users
- Excel Protect Sheet but Allow Data Refresh?
- Excel Protect Sheet but Allow Filtering: How to Set It Up
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Present PowerPoint and See Your Speaker NotesTo present PowerPoint while keeping your notes visible, connect your computer to a second screen, set the displays…
- Google Sheets Duplicate: Copy a File, Tab, or DataYes—Google Sheets can duplicate an entire spreadsheet, a single sheet tab, or a selected range of cells. Choose…
- How to Split a Cell in Google Sheets Into Two CellsTo split text in Google Sheets, select the cell or range, choose Data > Split text to columns,…
- How to Freeze the First Row in Excel While ScrollingTo keep the first row visible while you scroll in Excel for Microsoft 365 on Windows, select View…
- Schedule Recurring Emails in Outlook: Your OptionsOutlook can schedule a single email, but it does not have a built-in option to send the same…
- How to Create Inbox Rules in New Outlook Step by StepTo create an inbox rule in New Outlook, open Settings > Mail > Rules, select Add new rule,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.