and Size. It also has some special commands such as Print Area
Background
and Print Titles that you will learn in the following section.SET PRINT AREAA print area is a range of cells that you select to print when you do not want to print the entire data of the worksheet. The Print Area command enables you to select only the area of the worksheet you need to print. You can also remove the selected print area using the Clear Print Area option of the Print Area command.To set Print Area
follow the steps given below: Select the area that you want to set as print area. Click on the Print Area command in the Page Setup group. Select the Set Print Area option. To Clear Print Area
Select the Clear Print Area option of the Print Area command.WORKSHEET BACKGROuNDThe Background command enables you to insert a picture as worksheet background. You can browse your computer for the background picture or search for online pictures using Microsoft Bing Search box. The worksheet background picture is used for display purpose only and is not printed.12341234You can select multiple print areas by holding down Ctrl key before using the Set Print Area command. Each Print Area will print as a separate page.TIP