Question

How can you insert a page break between row 20 (Cracker Jacker) and row 21 (Raspberry Chocolate) in Excel?

a) Drag and drop a page break line
b) Access the "Page Break Preview" view and click on the row
c) Use the "Insert Page Break" option in the "Page Layout" menu
d) Manually add a row with a page break symbol

Answer 1

To insert a page break in Excel, select the cell at the beginning of the new page, go to the 'Page Layout' tab, click 'Breaks' in the 'Page Setup' group, then choose 'Insert Page Break'. This will start a new printed page from the selected cell.

Step-by-step explanation:

To insert a page break between row 20 and row 21 in Excel, the correct method is to use the "Insert Page Break" option in the "Page Layout" menu. Here is a step-by-step explanation:

1. Select the cell in row 21, column A. This is where the new page will start after the page break.
2. Go to the "Page Layout" tab on the Excel ribbon.
3. Within the "Page Setup" group, click on "Breaks".
4. In the dropdown menu, select "Insert Page Break".

Once you have done this, Excel will insert a horizontal page break above the cell you have selected. When you print the document, everything above row 21 will be on one page, and row 21 and everything below will start on a new page.