Excel Blue Line Print Area: What It Means

How-to basics · Updated November 18, 2026

In Excel, blue lines in Page Break Preview mark page breaks—the boundaries between printed pages—not necessarily the edge of your print area. To choose what prints, select the cells and use Page Layout > Print Area > Set Print Area; then use the blue lines to check or adjust how that content is divided across pages.

What the blue lines mean

Excel’s blue lines are easiest to interpret in Page Break Preview. They show where Excel will divide the worksheet into pages when printing. A solid blue line generally indicates a manually inserted page break, while a dashed blue line indicates an automatic break calculated from the paper size, margins, scaling, and the content’s dimensions. The gray page numbers shown in this view are visual guides, not worksheet data.

A print area and a page break answer different questions. The print area defines which cells Excel should include in the print job. Page breaks define how that included material is split into sheets of paper. A worksheet can have a correctly set print area and still have blue lines running through awkward places, such as the middle of a table. Conversely, a page break can be positioned neatly even when the print area includes too many blank rows or columns.

In Page Break Preview, the area outside the printable pages is shaded gray. That shading is a useful clue when you are checking what belongs in the printout, but do not treat every blue line as the print-area outline. The exact appearance of page-break indicators can vary with the view and workbook state.

How to display the lines

To inspect page divisions in Excel for Microsoft 365 on Windows, open the worksheet and choose View > Page Break Preview. The worksheet changes to a page-oriented view, with blue boundaries and page-number labels. Return to the ordinary grid with View > Normal. Page Layout view is another option when you want to see pages with margins and headers or footers, although Page Break Preview is the clearest view for moving page breaks.

If you are in Normal view and the blue lines are not visible, that does not mean Excel has no page breaks. The indicators may simply be hidden in that view, or the worksheet may not yet have displayed its pagination. Open Print or Print Preview to make Excel calculate how the sheet fits the selected paper and orientation, then check Page Break Preview again.

In Excel for Mac, use the View tab and choose Page Break Preview, then return with Normal. Ribbon names and general page-layout controls are similar, though their exact positions can vary by release. Excel for the web has a more limited set of page-layout and break-adjustment controls; if you need to drag breaks or manage a complex print area, open the workbook in the desktop app.

Set, change, or clear a print area

A print area is a saved range or set of ranges that tells Excel what worksheet content to print. On Windows, select the cells you want, then choose Page Layout > Print Area > Set Print Area. For example, if a report occupies A1:F32, select that range before setting the area. Printing the sheet will then focus on that range rather than the entire used portion of the worksheet.

To replace the existing print area, select the new range and choose Set Print Area again. To remove the restriction and let Excel print the worksheet’s content according to the print settings, choose Page Layout > Print Area > Clear Print Area. Clearing the area does not delete cells or data; it only removes the print-range instruction. On Mac, look for the same Print Area commands on the Page Layout tab.

You can also define more than one nonadjacent range by selecting the first range and then adding other selections before setting the print area. Excel treats separate print areas as separate print sections; they may print on separate pages rather than being combined into one continuous block. For a report that needs a predictable reading order, it is often simpler to arrange the content in one contiguous range or place separate sections on separate worksheets.

  • Set: Select the desired cells, then choose Page Layout > Print Area > Set Print Area.
  • Change: Select the replacement range and set the print area again.
  • Clear: Choose Page Layout > Print Area > Clear Print Area.
  • Verify: Open Print Preview and check that the expected rows and columns appear.

Move or reset page breaks

In Page Break Preview, you can drag a blue boundary to move a page break. Moving an automatic break creates a manual break, giving you more control over where the next printed page starts. For example, if a customer table has a heading in row 1 and records in rows 2 through 40, you may want a break before a new customer group rather than halfway through it. Drag the horizontal line to a suitable row, then inspect the resulting pages in Print Preview.

Dragging a break changes pagination, not the print area itself. It does not remove rows from the sheet or change their values. If the page layout becomes confusing after several adjustments, choose Page Layout > Breaks > Reset All Page Breaks to return to automatic pagination. This reset affects manual page breaks on that worksheet; review the preview afterward, because automatic pagination may not match the layout you previously chose.

For a single break, Excel also provides controls under Page Layout > Breaks, including options to insert or remove a page break based on the selected cell. A horizontal break is placed above the selected row, and a vertical break is placed to the left of the selected column. If you select a cell inside the data, consider carefully which side of that row or column should begin the next page.

Fit the print area to paper

Blue page boundaries can appear inconvenient because the sheet is wider or taller than expected, not because the print area is wrong. Before shrinking everything to one page, check the paper size, orientation, margins, and scaling. A wide table often works better in landscape orientation. On the Page Layout tab, use Orientation to choose Landscape, and use Size to select the paper supported by the printer or destination.

Scaling options are in the Page Layout tab’s Scale to Fit controls. Setting Width to 1 page can keep all columns together while allowing the rows to continue onto additional pages. Setting both Width and Height to 1 page forces the whole print area onto one sheet of paper, but can make text extremely small when the range is large. Use Print Preview to judge readability instead of assuming that a one-page result is automatically better.

Margins also affect where Excel places automatic breaks. Narrower margins create more usable space; wider margins reduce it. Headers, footers, and repeated title rows can further change the available page area. If a report has many rows, repeating its column headings on each page is often more useful than forcing the entire report onto one page. Use Page Layout > Print Titles to set rows to repeat at the top or columns to repeat at the left.

Why a blue line may seem wrong

Automatic page breaks depend on several settings, so a line can move when you change the printer, paper size, orientation, margins, or scaling. A workbook that looked correct on one computer may paginate differently on another if the available printer or paper configuration differs. Check the print settings and preview on the device that will produce the final copy, especially for forms, labels, or reports with strict page boundaries.

Another common source of confusion is content that appears blank but still affects the worksheet’s layout. Formatting, borders, or a stray value far to the right or below the visible table can expand the area Excel considers when it calculates pages. Check the rows and columns around the intended report, and remove genuinely unnecessary content or formatting only after confirming it is not needed. Do not delete data simply because it falls outside the desired print area; set or adjust the print area instead.

If a blue line crosses a table, first decide whether the table should continue across pages or whether a group should stay together. A manual break can control the starting point of the next page, while scaling or landscape orientation may prevent an awkward split across columns. These approaches solve different problems: breaks control page boundaries, and scaling changes the size of printed content.

Print preview and other useful distinctions

Use File > Print to inspect the final output before sending it to a printer. The preview helps reveal clipped columns, unexpected blank pages, tiny scaled text, or a print area that omits a heading. If the preview looks wrong, return to the worksheet and adjust the print area or page setup, then check again. Page Break Preview is best for editing boundaries; Print Preview is best for reviewing the finished page appearance.

A print area is also different from hiding rows or columns. Hidden worksheet content is generally excluded from printing, while setting a print area limits which cells are selected for the print job without hiding anything on screen. It is different from Print Titles, too: a print area chooses what to print, while Print Titles repeats specified headings on each page. Keeping these controls separate makes it easier to diagnose why a particular row or column appears—or fails to appear—in the output.

For a worksheet with several reports, consider using separate sheets if each section needs its own paper size, orientation, or pagination. Multiple print areas on one sheet can work, but they are less intuitive to manage and may print as separate sections. A dedicated report sheet can make the intended print range and page breaks easier for another person to understand.

Frequently Asked Questions

Does a blue line show the edge of the print area?
Usually, the blue line in Page Break Preview is a page-break boundary. The print area determines what worksheet cells are included; page breaks divide that content into pages. Check the gray shading and Print Preview to confirm which area will print.

How do I remove blue lines in Excel?
Switch from View > Page Break Preview to View > Normal to leave the view that displays page boundaries. If you need to remove manual breaks rather than hide the indicators, use Page Layout > Breaks > Reset All Page Breaks.

Why is my print area not printing everything?
The saved print area may exclude some cells, or rows and columns may be hidden. Choose Page Layout > Print Area > Clear Print Area to remove the range restriction, or select the complete intended range and set it again. Then check File > Print for a preview.

Can I move a blue line in Excel?
Yes. In Page Break Preview, drag the line to a new position. Moving an automatic break makes it a manual break. Use Reset All Page Breaks if you want Excel to calculate the divisions again.

Why does my worksheet print on several pages?
The print area may be larger than one page, or the current paper size, orientation, margins, and scaling may require multiple pages. In Page Layout, review Scale to Fit and use Print Preview. Fit one dimension, such as the width, to one page if that keeps text readable while allowing additional pages vertically.

Related

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.