How to Set Print Area in MS Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to define and preview a print area in Microsoft Excel.

Quick summary

Setting a print area in Microsoft Excel lets you control exactly which cells appear on printed pages, preventing unwanted data from being included. Use the Page Layout tab to define the range and Page Break Preview to confirm the output before printing.

Steps

Select the cells you want to print.
Go to the Page Layout tab and click on Print Area.
Select Set Print Area to define your print range.
Navigate to the View tab and click on Page Break Preview to see how the selection is laid out across pages.
Review the highlighted print area to confirm how it will appear on printed pages.

📌 Why this matters

Knowing how to set a print area in Microsoft Excel is an essential skill for anyone who regularly shares spreadsheet data in printed or PDF format. Without a defined print area, Excel defaults to printing all populated cells, which can result in wasted pages and poorly formatted output. By using the Page Layout tab to set a precise print range and Page Break Preview to verify the layout, users gain full control over their printed documents. This feature is especially valuable for creating clean financial reports, data summaries, and professional presentations directly from Excel.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel