Insert a Page Break

Posted on 27-03-2020 , by: admin , in , 0 Comments

Insert a Page Break

Problem I need to insert a page break, Move page break, and delete page break in excel worksheet.

Question
1. How I can Insert a page break in excel worksheet?
2. How I can Move a page break in excel worksheet?
3. How I can Delete a page break in excel worksheet?

Solution(step by step)

Insert a page break
1. Click the excel worksheet that you want to insert a break.
2. On the View tab, in the Workbook Views group and then click on the Page Break Preview.

Tip : You can also click Page Break Preview Button image on the status bar.

3. Do one of the following:
(a) To insert a vertical page break, select the row below where you want to insert the page break.
(b) To insert a horizontal page break, select the column to the right of where you want to insert the page break.

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

5. Click Insert Page Break.
Note : You can also right-click the row or column below or to the right of where you want to insert the page break, and then click Insert Page Break.

Move a page break

1. First we need to make sure that cell drag and drop feature is enabled
2. To verify that drag-and-drop is enabled, do the following:
Under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.
3. Click the worksheet that you want to modify.
4. To move a page break, drag the page break to a new location.

Delete a page break
1. Select the worksheet that you want to modify.
2. (a) To delete a vertical page break, select the column to the right of the page break that you want to delete.
(b) To delete a horizontal page break, select the row below the page break that you want to delete.
3. On the Page Layout tab, in the Page Setup group, click Breaks.

4. Click Remove Page Break.

Tip : You can also remove a page break by dragging it outside of the page break preview area (to the left past the row headers, or up past the column headers).

share:

Leave a comment