FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -On the View tab, in the Workbook Views group, click Page Break Preview.

Detailed explanation-2: -In Page Break Preview, dashed lines are page breaks Excel automatically added. Solid lines are breaks that were added manually. Tip: If you don’t want to change the page breaks, you can see what the printed pages will look like in Print Preview (File > Print).

Detailed explanation-3: -View page breaks On the status bar, click the Page Break Preview button. Or, click the View tab, then click the Page Break Preview button.

Detailed explanation-4: -To insert a page break using a keyboard shortcut, simply press Ctrl+Shift+Enter. This will insert a page break above the active cell. If you want to insert a page break below the active cell, you can press Ctrl+Shift+Enter and then press the down arrow key. This will move the page break below the active cell.

Detailed explanation-5: -View page breaks Click the View tab on the ribbon, and choose Page Break Preview. P). In the Print dialog box, you can view a quick preview of how the pages will print, and use the left/right buttons to see each page. Click Cancel to close the Print dialog box.