Printing a Selection with Excel 2010

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

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast
This entry was posted in Excel and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s