Set Your Print Area in Three Steps
The print area in Excel is the section of your spreadsheet that will actually print when you send the file to a printer. By default, Excel prints everything on your sheet. To print only specific cells — a table, a chart, or a single section — you select those cells first, then tell Excel to print only that selection.
The fastest way is to highlight the cells you want to print, go to the Page Layout tab (or Sheet tab on Mac), click Print Area, and choose Set Print Area. Excel will remember this choice until you change it again. You can see what will print by opening Print Preview before you send anything to the printer.
Key Takeaways
- Select the cells you want to print, then use Page Layout > Print Area > Set Print Area to lock in your choice.
- Print Preview (Ctrl+P or Cmd+P) shows you exactly what will print before the paper comes out.
- To print your entire sheet again after setting a print area, go to Print Area and choose Clear Print Area.
- You can set multiple separate print areas on the same sheet by holding Ctrl while selecting different cell ranges, then setting the print area once.
- Page breaks (the dotted lines you see in the sheet) show where Excel will split your print area across pages.
Select and Highlight the Cells You Want to Print
Start by clicking on the first cell of the section you want to print. Hold down your mouse button and drag to the last cell, or click the first cell, hold Shift, and click the last cell. The selected area will turn blue or gray depending on your Excel version.
If your print area is not one continuous rectangle — for example, you want to print a table on the left and a separate chart on the right — hold Ctrl (or Cmd on Mac) and click-drag to select each section. Excel will treat all your selections as one print area.
Open Page Layout and Set the Print Area
With your cells selected, click the Page Layout tab at the top of the ribbon. On Mac, this tab is called Sheet. Look for the Print Area button in the ribbon — it is usually in the middle-left section.
Click Print Area and a small menu will drop down. Select Set Print Area. Excel will now remember this selection. The cells you chose will have a thin border around them (usually a dashed line) to show they are your print area.
Preview Your Print Area Before Printing
Before you print, open Print Preview to see exactly what will come out. Press Ctrl+P (Windows) or Cmd+P (Mac), or go to File > Print. The preview pane on the right side of the screen shows your print area as it will appear on paper.
If the preview looks wrong — if it is cutting off data, printing blank pages, or showing more than you selected — close the preview and adjust your print area. You can also use the Page Setup options in the Page Layout tab to change margins, orientation (portrait or landscape), or paper size.
Clear or Change Your Print Area
To print your entire sheet again, go back to Page Layout > Print Area and click Clear Print Area. Excel will remove the border around your previous selection and return to printing the whole sheet.
To change your print area to a different section, select the new cells and go to Page Layout > Print Area > Set Print Area again. The new selection replaces the old one. You can change your print area as many times as you need without affecting the data in your spreadsheet.
Handle Page Breaks When Your Print Area Spans Multiple Pages
If your print area is larger than one page, Excel automatically splits it across multiple pages. You will see dotted blue lines in your sheet showing where the page breaks occur. These lines show you where one printed page ends and the next begins.
To adjust where the page breaks happen, go to Page Layout > Breaks and choose Insert Page Break or Remove Page Break. You can also drag the page break lines directly in the sheet to move them. This is useful if a table is being split awkwardly across pages and you want to move the break to keep related rows together.
Print Specific Rows or Columns on Every Page
If your print area is wide or tall, you may want certain rows (like headers) or columns (like labels) to repeat on every page. Go to Page Layout > Print Titles. In the dialog box, enter the row numbers or column letters you want to repeat — for example, type 1:1 to repeat row 1 on every page, or A:A to repeat column A.
This is especially helpful for large tables where you need the column headers visible on every printed page. The repeated rows or columns do not take up extra space in your print area — they just appear on each page for reference.
Frequently Asked Questions
What if I select cells but Set Print Area is grayed out?
Make sure you are on the Page Layout tab (or Sheet on Mac). If the button is still grayed out, try clicking a single cell first, then selecting your range again. Some versions of Excel require you to be in the correct view mode.
Can I print multiple separate areas from the same sheet?
Yes. Hold Ctrl (or Cmd on Mac) and select each area you want to print. Then set the print area once. Excel will treat all your selections as one print area and print them in order.
How do I see the print area border in my sheet?
The print area border is a thin dashed line that appears around your selected cells after you set the print area. If you do not see it, go to File > Options > Advanced (Windows) and look for "Show print areas" or similar. On Mac, check Excel > Preferences > View.
Will changing the print area affect my actual data?
No. Setting a print area only controls what prints — it does not change, delete, or move any data in your spreadsheet. You can change your print area as many times as you want without affecting the cells themselves.
What if my print area looks different in Print Preview than in the sheet?
This usually happens because of margins or page size settings. Open Page Layout > Margins and choose a preset, or click Custom Margins to adjust them manually. You can also check Page Layout > Orientation to make sure it is set to portrait or landscape as you intended.