![]() The Paper tab includes the following options for setting your paper size: ![]() The Paper tab lets you set your page size, use paper source controls, or apply these settings to specific parts of your documents. ![]() To format or change paper size of a Word document, go to the Paper tab of the Page Setup Dialog box, which is on the Page Layout tab (click the lower-right arrow in the Page Setup group). To clear the Print Area from this dialog box, select the cell addresses in the Print Area text box and press the Delete key. ![]() Then click the Print Area text box on the Sheet tab and select the cell range or ranges directly in the worksheet. Click the Page Setup dialog box launcher on the Page Layout tab to open this dialog box. You also can define and clear the Print Area from the Sheet tab of the Page Setup dialog box. To clear a print area that you set previously, choose Print Area→Clear Print Area on the Page Layout tab of the Ribbon. Once you define a print area, its cell range is the only one you can print (regardless of what other Print What options you select in the Print dialog box, unless you select the Ignore Print Areas check box) until you clear the print area. You can select noncontiguous areas of the worksheet by holding down the Ctrl key as you select the cell ranges.Ĭhoose Print Area→Set Print Area on the Page Layout tab of the Ribbon. Select the range of cells you want to print. After you define the print area, Excel then prints this cell selection any time you print the worksheet using the Print dialog box or the Quick Print command on the Office button’s Print menu.įollow these steps to set a print area in an Excel 2007 worksheet: You can define any cell selection on a worksheet as the print area. but I'm jealous because I know it has already begun for many of you (and I hope you're having an amazing one).Excel 2007 includes a special printing feature called the print area. Welcome to Friday, everyone! The weekend is already around the corner.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |