How to Insert a Page Border in Excel for Printed Sheets

Excel has no built-in page-border command like Word. To add a border to a printed sheet, draw a no-fill rectangle over the print area, then check its position in print preview; for a simpler border around your data, apply an outside cell border instead. The steps below are for Excel for Microsoft 365 on Windows.

What You’ll Need

The Excel workbook you want to print, preferably with its page layout and print area already planned.
A printer or access to print preview. You can check the layout without printing on paper.
Excel for Microsoft 365 desktop for the shape method. Excel for the web may not offer the same shape-formatting controls, so open the workbook in the desktop app if needed.

Step-by-Step

Decide what the border should enclose. If you want a box around the table itself, use the cell-border method in step 8. If you want a frame around a larger printed region that includes blank space, use the rectangle method. Excel prints worksheet content on paper, so a shape can frame the printable sheet area but cannot draw into a printer’s nonprinting margins.
Set up the worksheet and page. Check that the data is arranged as you want it to print. On the ribbon, choose Page Layout and set Orientation, Size, and Margins as appropriate. If the sheet has several pages, consider whether the border should appear on every printed page or only around a particular section; a single worksheet shape may not frame each page independently.
Define the print area. Select the cells that should be included on the printed page, including the blank cells behind the intended frame. Choose Page Layout > Print Area > Set Print Area. The rectangle must sit within this area to be included reliably in the printout. If your print area is already correct, leave it as is.
Insert a rectangle. Choose Insert > Shapes, then select the plain rectangle. Move the pointer to one corner of the area you want to frame, click and drag to the opposite corner, and release. Keep the shape’s edges inside the print area rather than extending them beyond the worksheet cells selected for printing. For a neat frame, use the cell grid as a guide and zoom in while positioning the shape.
Remove the rectangle’s fill. Select the rectangle so the contextual Shape Format tab appears. Choose Shape Format > Shape Fill > No Fill. This leaves the worksheet visible inside the frame. Do not choose a white fill: it can cover cell contents even if the result looks blank on a white screen.
Choose the line style. With the rectangle selected, choose Shape Format > Shape Outline and pick a color. Use the same menu to set Weight for line thickness and, if desired, Dashes for a dashed or dotted frame. A dark, thin line is usually easiest to read on paper. Avoid a very thick outline near the edge, where it may be clipped by the printer.
Keep the shape aligned as the sheet changes. Right-click the rectangle and choose Format Shape. In the formatting pane, open Size & Properties, then Properties. Choose Move and size with cells if you want the frame to follow the rows and columns beneath it when their dimensions change. This setting is useful for a frame aligned to a cell block, but changing row heights or column widths can also change the frame. Recheck it after layout edits.
Preview and adjust the printed result. Choose File > Print to inspect the preview. Confirm that the whole frame is visible and that the page count and scale are right. If Excel has split the sheet across pages, adjust the print area, orientation, margins, or scaling under Page Layout. Avoid shrinking a large sheet so much that its text becomes unreadable. Return to the worksheet, resize or reposition the rectangle, and check the preview again before printing.
Use an outside cell border for a table-only frame. Select the cells around the table, then choose Home > Borders and select Outside Borders. For more control over color, thickness, or which edges appear, open Home > Borders > More Borders, choose the line style and color, and apply the outline in the preview area. This method borders the selected cells, not the physical edge of the printed page.

On a Mac, the general approach is the same: use Insert to add a shape, then use the contextual shape-formatting controls to remove the fill and set the outline. Ribbon labels and pane placement can vary slightly by Excel version. Excel for the web can display and print many workbooks, but shape editing and print-layout controls may differ; use Open in Desktop App for the most consistent access to the steps above.

Common Mistakes

Expecting a dedicated Page Border button. Excel does not provide a worksheet page-border feature comparable to Word’s. A rectangle is a drawn object, while cell borders belong to the cells. Choosing between them matters: a rectangle can frame a larger area, but a cell border is easier to keep attached to a table.

Using a filled shape. A rectangle with a solid fill can hide values, gridlines, or other objects underneath it. Set the fill to No Fill rather than selecting white. If the shape seems to obscure content, select it and check its fill settings.

Putting the frame outside the print area. A shape that is visible on the worksheet may be absent or cut off in the printout if it falls beyond the cells being printed. Set the print area deliberately and keep the complete shape inside it, then confirm the result in File > Print.

Assuming the frame will repeat on every page. A rectangle is positioned on the worksheet, not attached to the paper page. When a print area spans multiple pages, the rectangle may appear only where it lies on the sheet or may not form a complete frame around each page. Check every preview page; use separate page-sized areas or a different layout if each page needs its own frame.

Making the border too close to the paper edge. Printers have nonprinting margins, and a line placed at the extreme edge can disappear. Leave a small inset and verify the preview. A preview cannot always represent a printer’s exact hardware limits, so use a test print if the border must be precisely positioned.

Tips

Keep a clean copy of the worksheet before adding decorative shapes, especially if the workbook is used for ongoing data entry. A shape can be selected accidentally, moved, or layered above content. Use Home > Find & Select > Selection Pane to locate and select objects when the rectangle is difficult to click. You can also rename it in the Selection Pane, for example to Page frame, so it is easier to identify later.

Make the border slightly inset from the outermost printable cells. This gives the line some breathing room and reduces the chance that printer margins will clip it. If the rectangle is aligned to cell edges, temporarily show gridlines and use a consistent row or column boundary for each side. Gridlines are worksheet guides; they are not the border itself.

For a professional-looking report, use a restrained line weight and a color with sufficient contrast when printed in grayscale. Print preview is useful for checking page breaks, but it may not show the exact shade or weight produced by every printer. If the border is important, print one test page before making multiple copies.

If you need a border around several printed pages, first decide whether you mean one large outline around the entire multi-page sheet or a separate outline on each page. Those are different layouts. Excel’s page breaks divide worksheet cells for printing; they do not automatically repeat a rectangle on each page. Adjust the worksheet or create a separate print-ready layout for each page rather than relying on one shape to behave like a page setting.

Troubleshooting

The shape is visible in the worksheet but missing from print preview. Check that the print area includes the cells under the shape and that the rectangle is fully inside that area. If you chose Print Selection in the Print screen, switch to printing the active sheet or workbook as intended. Check the preview again after changing the print choice.

The outline prints but covers the data. Select the rectangle and choose Shape Format > Shape Fill > No Fill. If text or objects still appear hidden, use Home > Find & Select > Selection Pane to inspect the object order and select the correct shape.

The frame shifts after changing the worksheet. This can happen when the object is set to move or size with cells and the underlying rows or columns change. Undo the layout change if appropriate, reposition the frame, and review its Format Shape > Size & Properties > Properties setting. Choose the object behavior that best matches how you expect the sheet to change, then preview again.

The border is cut off or too close to the edge. Move it inward, reduce the line weight, or increase the page margins. Also check Page Layout > Scale to Fit and the print preview: scaling or page breaks can change how the worksheet fits on paper. If only one side is missing, inspect that edge of the shape and verify the print area includes the adjacent cells.

The sheet prints on multiple pages unexpectedly. In print preview, note where the page breaks fall. Try landscape orientation, a suitable paper size, or a modest change to margins. You can adjust scaling in Page Layout, but forcing an entire large worksheet onto one page may make it too small to read. Set the print area to exclude unused rows and columns before changing scale.

Frequently Asked Questions

Does Excel have a built-in page border option?
No. Excel does not have a dedicated page-border command. Use a no-fill rectangle for a drawn frame or apply an outside border to cells for a table outline.

Will a rectangle print on every page?
Not automatically as a repeated page frame. A shape sits at a position on the worksheet, so a multi-page printout may not have a complete border on each page. Inspect each page in print preview.

Can I put a border around the whole printed page, including the margins?
Usually not to the physical paper edge. Printers need nonprinting margins, and Excel’s worksheet content cannot print beyond the printer’s printable area. Place the line slightly inside that area.

Can I use cell borders instead of a rectangle?
Yes. Select the cells to outline and choose Home > Borders > Outside Borders. This is often the simplest choice for a table, but it follows the selected cells rather than enclosing blank page space.

Can I add the border in Excel for the web?
Some shape and print controls differ in the web app and may not match the desktop steps. For reliable placement and formatting, open the workbook in Excel for Microsoft 365 desktop, then review its print preview.

Why does my border look different on paper?
Printer margins, scaling, paper size, and line weight can affect the result. Check the print preview, keep the frame inset from the edge, and make a test print when exact placement matters.

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.