Set a Print Area in MS Excel

Dennis Faas's picture

To ensure that you print only the area of your spreadsheet that is necessary, use the Set Print Area in MS Excel.

Follow the instructions below to learn how:

  • Click and drag to select the region of the spreadsheet that you would like to print.  
  • Click File | Print Area | Set Print Area.

The Print Area has now been set.

To clear the Print area:

  • Click File | Print Area | Clear Print Area.

This should clear the Print Area and reset MS Excel back to its default print settings.

When you become a member at, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet