Setting the Print Area

In addition to the printing capabilities you'll find in the Backstage, there are some additional and important options stored in other areas of the worksheet. You've already seen that by selecting a specific range to print, you can avoid the problem of overprinting (i.e., printing blank areas of the worksheet that you don't need to see in your printed results). But selecting a print range may cause a problem or two on its own, because once you select that range you need to print it right away. If you decide you want to work elsewhere in the sheet before printing, you'll have to click elsewhere to begin your work, which will deselect the range you want to print.

But Excel lets you have it both ways by letting you designate and save a print area so you can go on do to work somewhere else before printing.