FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Page breaks are dividers that break a worksheet into separate pages for printing. Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert.

Detailed explanation-2: -To print a worksheet on a specific number of pages, in Page Setup, click the small window launcher button. Then, under Scaling, in both of the Fit to boxes, enter the number of pages (wide and tall) on which you want to print the worksheet data. Notes: Excel ignores manual page breaks when you use the Fit to option.

Detailed explanation-3: -Insert a horizontal or vertical manual page break Select the row that is underneath the row where you want the page to break. Select the column that is to the right of the column where you want the page to break. On the Layout tab, under Page Setup, click Breaks, and then click Insert Page Break.