This is another one of those questions I get asked regularly “how can I print just this section in Excel?”. Thankfully the answer to this is easy and can be done in one of two ways. One is to select the area you want to print, click on the File tab, click on Print and just below settings is to click on the drop down list and choose Print Selection.

The other option is to again highlight the area click on the Page Layout tab and then click on the Print Area button and choose Set Print Area. Doing it this way means that if you want to print this selection again you do not need to highlight it again and when you save you file it will be remembered for when you open it again.

To see how to do these and how to clear the print area watch the video below and don’t forget I have more tutorials on my website www.jargonfreehelp.com