How To Set Print Area In Excel

Set One or More Excel Print Areas

How to Add Cells to an Excel Print Area

Once you’ve set a print area, you can add adjacent cells to it, if you made a mistake the first time or input additional data.

How to Clear a Print Area in Excel

You can also change print areas that you no longer need or created by mistake.

View Your Excel Print Areas

You can see your print areas and preview them before printing your spreadsheet. To see your print areas:

Reasons to Set Print Areas in Excel

If you print out a large spreadsheet without setting print areas, you run the risk of outputting hard to read, unformatted pages. If the sheet is wider or longer than the paper your printer is using, you’ll end up cutting off rows and columns. It won’t look pretty. Setting print areas gives you control over what each page looks like, so it’s easy to read and understand.