Question

What are the different types of breaks that can be added to an Excel worksheet?

Write the steps to add page breaks to an Excel worksheet?​

Answer 1

Insert a page break

Click the worksheet that you want to print

.On the View tab, in the Workbook Views group, click Page Break Preview.

You can also click Page Break Preview. ...

Do one of the following: ...

On the Page Layout tab, in the Page Setup

group, click Breaks.Click Insert Page Break.

Answer 2

The steps to add page breaks to an Excel worksheet are÷

1.Click the worksheet that you want to print.

2.On the View tab,in the Workbook Views group,Click page Preview.You can also click Page Break Preview.

3.Do one of the following.

4.On the Page Layout tab,in the Page Setup group,click Break.

5.Click Insert Page Break