DonnaYoung.org

Print Preview and Selecting Print Area

Check Print Preview before Printing.


What you will discover with print preview:

All of the sheets were formatted to print well, however, when a file is opened on a different computer, the formatting might not be exactly right. This is an example of what you will find:

This sheet is formatted so that the grades and footer-comments will print on one sheet of paper. Notice that it will use two sheets of paper. See the bottom left corner of image.

It will use two sheets of paper because I added the current averages per column to the subject sheets and now Excel wants to print that part too.

You can force the printer to print only one sheet, by using your printer options.

Another alternative is to Set Print Area. I always go for that option.

Continued below...
After leaving the print preview screen, you will notice that you now have dotted lines on the sheet.

These dotted lines indicate the page breaks. The page breaks show you how your printer is recognizing a page (or something like that).

To read how to force the printing of a certain area keep reading.

Continued Below....
How to set the Print Area:
  1. Select the area that you want to print.

  2. Open from File: Print Area > Set Print Area

  3. That is all, now to check what will print, Use Print Preview again and see what you have.

Note: If after setting you the print area, it still shows that it will take more than one piece of paper, you may have to delete a row or two from the comment section. The comment section is located at rows 44-54.