HOW TO SET AND CLEAR PRINT AREA IN EXCEL 2007/2010

As a link to my other tutorial on printing , I am going to show you how to do the following in this tutorial:

• Set a print area
• Clear a print area
• Hide columns/rows if you only want to print specific parts of the spreadsheet, that may not be side by side…

As always here is the video to see how it is done…

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/setting+a+print+area.m4v’]

Here is a file for you to practise on.