Page 296 - Excel 2013 All-in-One For Dummies

278 Working with the Page Setup Options
✦ Print Area: Set and clear the Print Area. (See “Setting and clearing the Print Area” immediately following in this chapter.)
✦ Breaks: Insert or remove page breaks. (See “Solving Page Break Problems” later in this chapter.)
✦ Background: Open the Sheet Background dialog box, where you can select a new graphic image or photo to be used as a background for all the worksheets in the workbook. (Note that this button changes to Delete Background as soon as you select a background image.)
✦ Print Titles: Open the Sheet tab of the Page Setup dialog box, where you can define rows of the worksheet to repeat at the top and columns at the left as print titles for the report. (See “Putting out the print titles” later in this chapter.)
Setting and clearing the Print Area
Excel includes a special printing feature called the Print Area. You choose Print Area➪Set Print Area on the Ribbon’s Page Layout tab or press Alt+PRS to define any cell selection on a worksheet as the Print Area. After you define the Print Area, Excel then prints this cell selection anytime you print the worksheet (either with the Quick Print button on the Quick Access toolbar or by choosing File➪Print and then clicking the Print button on the Print screen).
Whenever you fool with the Print Area, you need to keep in mind that after you define it, its cell range is the only one you can print (regardless of what other print area options you select in the Print screen unless you click the Ignore Print Areas check box at the bottom of the very first drop-down menu in the Settings section of the Print screen and until you clear the Print Area).
To clear the Print Area (and therefore go back to the printing defaults Excel establishes in the Print screen), you just have to choose Print Area➪Clear Print Area on the Page Layout tab or simply press Alt+PRC.
Keep in mind that you can also define and clear the Print Area from the Sheet tab of the Page Setup dialog box opened by clicking the dialog box launcher button in the Page Setup group on the Page Layout Ribbon tab (Alt+PSP). To define the Print Area from this dialog box, click the Print Area text box on the Sheet tab to insert the cursor and then select the cell range or ranges in the worksheet. (Remember that you can reduce the Page Setup dialog box to just this text box by clicking its minimize box.) To clear the Print Area from this dialog box, select the cell addresses in the Print Area text box and press the Delete key.
Massaging the margins
The Normal margin settings that Excel applies to a new report use standard top and bottom margins of 0.75 inch (3⁄4 inch) and left and right margins of 0.7 inch with just over a 1⁄4 inch separating the header and footer from the top and bottom margins, respectively.