1. Home
  2. MS Office

Manually Set Print Area In Excel 2010

Excel 2010 includes many printing options, you can tweak with the options to print the spreadsheet in a way you like. If you need to print only the specific part of spreadsheet, it provides you with a handy Add to printer area option, so you can set print area of spreadsheet manually.

To begin, select the range of cells located in spreadsheet.


Now navigate to Page Layout tab and from Print Area options, click Add to Print Area.


It will draw a border around the range of cells, indicating that it is now added into print area.


Now just Press Print button to print the selected area.


  1. this sucks. I’ve been screwing with this stupid version of excel 2010 for an hour, and still can’t set the print range. Why is it so complicated. This is not user friendly. Why did you have to make it so hard to simply go to page setup and do the settings, as in previous versions of Excel. I wasted my money.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.