Explain how manual page breaks is a better option over automatic page breaks.?

What will be an ideal response?

?Answers will vary. Often the contents of a worksheet do not fit onto a single page. By default, Excel prints as much of the content that fits on a single page without resizing the content and then inserts automatic page breaks to continue printing theremaining worksheet contenton successive pages.This can result in pagebreaks that leave a singlecolumn or row on a separate page or split worksheet content in awkward places such as within range ofrelated data. Automatic page breaks appear as dotted blue lines in Page Break Preview.One way to fix this problem is to scale the printout by reducing the font size to fit on a single sheet of paper. However, if you have more than one or two columns or rows to fit onto the page, the resulting text is often too small to read comfortably. A better fix is usually to split the worksheet into logical segments, which you can do by insertingmanual page breaksthat specify where the page breaks occur. A page break is inserted directly above and to the left of a selected cell, directly above a selected row, or to the left of a selected column. Remember that automatic page breaks appear as dotted blue lines in Page Break Preview. Manual page breaks appear as solid blue lines. Please see the section "Formatting a Worksheet for Printing" for more information.