How to Stop Excel from Printing Extra Blank Pages

In this video I show how to prevent Excel from printing extra blank pages. Blank pages exist because your spreadsheet contains values or errors outside of the immediate area in which you are working. These values are probably hidden, so the trick is to find where they are and remove them. You can also specify a print area so that everything else on your spreadsheet is ignored.

Contents:

00:00 – Presentation
00:33 – METHOD 1: Show and clear hidden errors in print preview
01:45 – METHOD 2: Find and remove all hidden values and errors
03:32 – METHOD 3: Print the selection
04:03 – METHOD 4: Define a print area
——————–

Please take the opportunity to connect and share this video with your friends and family if you find it useful.