A blue border around a worksheet in Excel usually means you are viewing it in Page Break Preview, where blue lines mark the print area and page boundaries. To check or change what Excel prints, go to Page Layout > Print Area, or switch to View > Page Break Preview to see the boundaries.
What the Blue Border Means
In Excel for Microsoft 365 on Windows, the blue outline is most commonly a visual guide in Page Break Preview. It shows the edge of the printable area, while blue lines inside that edge show where Excel divides the worksheet into printed pages. The area outside the print range is usually shaded gray. The border does not add a colored line to the printed page; it is an on-screen indicator.
The blue outline can also help distinguish the chosen print area from the rest of a large worksheet. If a print area has been saved for the sheet, Excel uses it to limit what is included when you print. If no print area has been set, Excel generally determines what to print from the worksheet’s used cells and the selected print settings. The preview is the practical way to verify the result.
Color and appearance can vary with the view and Excel version. In Page Break Preview, a solid blue line commonly indicates a page break that has been set manually, while a dotted line commonly represents an automatic page break. Treat those lines as layout guides, not as cell borders or formatting applied to the worksheet.
Why Excel Shows It
Excel worksheets can be much larger than a sheet of paper. Page Break Preview makes the gap between the worksheet grid and the printed page visible: it shows which cells fall on each page, where a page ends, and which cells are outside the chosen print range. That is especially useful for wide tables, long reports, and sheets with a print area smaller than the used range.
Excel also needs to divide a worksheet into pages based on paper size, orientation, margins, scaling, and printer settings. A blue line may therefore move when one of those settings changes. It is not necessarily a fixed boundary around a permanent print area; it may be a page break that Excel calculated to fit the current setup.
One common misconception is that a blue outline means the cells have a blue border format. Usually, it does not. A real cell border is part of the worksheet’s formatting and can appear in a printout. A Page Break Preview guide is part of the view and normally does not print. If unsure, check File > Print and inspect the print preview.
How to Show or Hide the Blue Border
To see the blue lines, choose View > Page Break Preview. Excel displays the page layout over the worksheet, with gray shading outside the printable region. To return to the standard grid, choose View > Normal. This changes the view, not the print area or worksheet data.
Another way to inspect the output is to open File > Print. The print preview shows the pages as they should be sent to the printer or saved as a PDF. Use the page navigation controls in the preview to check every page, especially if the sheet spans more than one page. The preview is more reliable than judging the blue outline alone because it reflects print settings such as scaling and margins.
If Excel continues to show page-break indicators in Normal view after printing or previewing, switching to Normal may not remove every indicator in all configurations. In desktop Excel for Windows, open File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks for the relevant sheet. This hides page-break guides on that sheet; it does not clear its print area. Excel for Mac has different preferences and menu organization, so use the corresponding Excel settings for worksheet display if the option is available in your version.
Set or Clear a Print Area
A print area is a defined range of cells that Excel uses as the worksheet’s print range. To set one in Excel for Microsoft 365 on Windows:
- Select the cells you want included, such as A1:F35.
- Choose Page Layout > Print Area > Set Print Area.
- Open View > Page Break Preview or File > Print to check what will be printed.
For example, if a worksheet has notes in columns G and H but the report occupies A1:F35, selecting A1:F35 before setting the print area keeps those notes out of the printout. The worksheet still contains the other columns; setting a print area does not delete or hide them.
To remove the defined area, choose Page Layout > Print Area > Clear Print Area. Excel then returns to determining the print range from the sheet and print settings. To replace an existing area, select the new range and use Set Print Area again. Menu names can vary slightly between desktop versions, but Print Area is found on the Page Layout tab. On Mac, the ribbon also provides Page Layout and Print Area commands; check the print preview after making changes.
Excel can also store more than one print area on a worksheet. If you select separate, nonadjacent ranges and set them as the print area, Excel generally prints each area separately rather than treating the gaps as part of one continuous block. That can produce unexpected extra pages. For a single continuous report, select one rectangular range instead.
How to Read the Page Break Lines
In Page Break Preview, the outer blue boundary identifies the extent of the print range being shown, and the internal lines divide that range into pages. A page can be one column wide and many rows tall, or several columns wide and only part of the worksheet tall. Page size, orientation, margins, scaling, and the active printer all affect where Excel places automatic breaks.
When a line is draggable, you can move it to adjust where a page ends. Dragging an automatic break creates or changes a manual break, which Excel may show as a solid blue line. This can be useful when a heading should stay with the rows below it. However, manual breaks can make later layout changes less predictable. If the worksheet’s size or paper setup changes, review the breaks again.
To reset manual page breaks, use Page Layout > Breaks > Reset All Page Breaks. This resets page-break placement, not the defined print area. Conversely, Clear Print Area removes the range restriction but is not the command for resetting manual breaks. The two settings affect different aspects of printing.
Adjust the Printed Layout
If the blue lines show too many pages, decide whether the problem is the print range or the page layout. A print area that includes unused columns can create extra pages, while a narrow paper orientation may split a wide table. Try these adjustments one at a time and review File > Print after each change:
- Set the print area to only the cells needed for the report.
- Choose Page Layout > Orientation > Landscape for a report with many columns.
- Choose Page Layout > Size to match the paper loaded in the printer.
- Adjust margins using Page Layout > Margins.
- Use the scaling controls in Page Layout, such as fitting the sheet to a page, when reducing the size remains readable.
- Insert or reset page breaks if a table is being split at an inconvenient row.
Fit to one page can make a wide or long worksheet technically fit, but it can shrink text until it is difficult to read. For a long report, it is often better to fit the columns to one page wide while allowing multiple pages tall, if that layout suits the content. Check the preview at a useful zoom level and consider whether headings repeat where readers need them. Print Titles on the Page Layout tab can repeat selected rows or columns on printed pages; that setting is separate from the blue border and the print area.
Common Problems and What to Check
If the border appears to enclose the wrong cells, first confirm the active worksheet and its print area. Use Page Layout > Print Area > Clear Print Area, then select the intended range and set it again. Also check for multiple print areas, hidden rows or columns, and content far from the main table. A stray value or formatting far down the sheet can affect what Excel regards as used content when no specific print area is set.
If the outline looks right but the printout has extra pages, open File > Print and check the page count and page thumbnails. Look for a manual break, a second print area, or scaling set to an unexpected value. Confirm the paper size and orientation as well. A printer driver can report different paper settings, so a preview may change when the selected printer changes.
If the blue line seems to print, verify whether it is actually a cell border or shape. A line drawn with a border-formatting command or inserted as a shape can print; the Page Break Preview guide should not. Return to Normal view, inspect the cells along that edge, and use File > Print to see the final output before printing on paper.
If a saved workbook opens with a different-looking boundary on another computer, compare the Excel version, printer selection, paper size, and scaling settings. Page breaks can depend on the printer driver and page setup, so the same worksheet may paginate differently in different environments. The defined print area may still be intact even if automatic page boundaries have shifted.
Frequently Asked Questions
Does the blue border print on paper?
No, not when it is the Page Break Preview guide. It is an on-screen indicator. A separately formatted cell border or inserted line can print, so use File > Print to confirm what the page will contain.
How do I get rid of the blue border in Excel?
Choose View > Normal to leave Page Break Preview. If page-break indicators remain in Normal view, Windows users can go to File > Options > Advanced and turn off Show page breaks for that worksheet. This does not remove a saved print area.
How do I change the cells inside the print area?
Select the desired cells and choose Page Layout > Print Area > Set Print Area. To remove the old restriction first, choose Clear Print Area, then set the new range. Check the result in File > Print.
Why is there a dotted blue line through my worksheet?
It is generally an automatic page break showing where Excel currently plans to start a new printed page. A solid line commonly indicates a manual break. Paper size, margins, scaling, and orientation can change the location.
Why does Excel print more pages than the blue outline suggests?
Check the print preview for multiple print areas, manual breaks, scaling, paper size, and orientation. Also confirm that the correct worksheet is selected and that the print settings are for the active sheet rather than the entire workbook.
Final Check Before Printing
Think of the blue border as a map of Excel’s current print layout, not as proof that the sheet is ready to print. Confirm the intended range, inspect each page in File > Print, and check that text remains readable at the chosen scaling. If the layout is wrong, adjust the print area or page setup rather than trying to format the blue guide itself. Once the preview matches the report you want, print or save the pages as a PDF.
Related
- Circular Reference Settings in Excel: How They Work
- Change the Print Area in Excel: Steps and Fixes
- Excel Text to Columns: How to Split Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel 2016: How to Freeze Panes and Keep Headers VisibleIn Excel 2016, select the cell just below the rows and to the right of the columns you…
- Power Query in Google Sheets: What You Can Do InsteadNo—Google Sheets does not include Microsoft Excel’s Power Query editor, and it cannot run Power Query’s M language…
- Excel Data Validation: Can You Select Multiple Items?No. In Excel for Microsoft 365, a data-validation drop-down list lets you choose one item for a cell…
- How to Create Individual Labels in WordTo create individual labels in Word, open Mailings > Labels, choose the label product that matches your sheets,…
- Google Sheets Filter: How to Create and Use OneTo create a filter in Google Sheets in a web browser, select your data range, including its header…
- How to Insert an Image File in ExcelTo insert an image file in Excel for Microsoft 365 on Windows, open the worksheet, select Insert >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.