Manually Set Print Area In Excel 2010

Advertisement

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.

461d1274351468-manually-set-print-area-

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

462d1274351469-manually-set-print-area-

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

460d1274351467-manually-set-print-area-

Now just Press Print button to print the selected area.

Advertisement
  • M Lam

    How do I set print review task for Excel 2010 version please?

  • joenotafan

    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.

    • Rustibus

      I totally agree! Excel 2010 sucks!