Question

8. Write the steps to insert page break after column only.
9. Write the steps to insert page break after 10th row and Column C.
10. How will you set the page margins, size and orientation of a page in Excel
IL Write the steps to repeat the contents how
repeat the contents Row 1 on each page of the printout

Answer 1

Answer:

Select the column after which u want to add Page breaks. Click on Page Breaks in Page layout tab > Page Setup group.

Similarly click the row after which u want to add page breaks. Click on Page Breaks in Page Layout tab page setup group.

Set page margins, Size and Orientation in Page layout Tab.

To repeat the contents click on the cell and then drag it by clicking on plus sign available at the corner