In this video I demonstrate how to stop Excel printing extra blank pages. The blank pages exist because your worksheet contains values or errors outside the immediate area you are working in. These values are probably hidden, so the trick is to find where they are and delete them. Alternatively you can specify a print area so that everything else on your worksheet is ignored.

Table of Contents:

00:00 Introduction
00:33 METHOD 1: Display and clear errors hidden in print preview
01:45 METHOD 2: Find and delete all hidden values and errors
03:32 METHOD 3: Print selection
04:03 METHOD 4: Set a print area