How to set print area in excel with blue line

There are two ways to specify the workbook data that is printed: setting the print area and adjusting the page breaks.

Remove a Print Area

1. Click the Page Layout tab.
2. Click the Print Area button.
3. Select Clear Print Area.

The print area is cleared and the entire worksheet will print once again.

Page Breaks

Excel automatically breaks up the page based on the margins and other page settings, but it’s also possible to adjust these page breaks or add alternative breaks to divide a worksheet into separate pages for printing.

Adjust Page Breaks

1. Click the View tab.
2. Click the Page Break Preview button.

   Click the Page Break Preview button on the status bar.

   The worksheet appears in Page Break Preview view.

3. To move a page break, click and drag it to a new location.

Dashed lines indicate automatic page breaks, while solid lines represent page breaks that you have changed or added.