Current location - Education and Training Encyclopedia - Resume - What should I do if there is a broken page in the middle of the EXCEL table after adjusting the number of rows?
What should I do if there is a broken page in the middle of the EXCEL table after adjusting the number of rows?
The way to cancel the page break of a table is as follows

1. After inserting a page break in Excel, the first line of forced paging has a dotted line, as shown in the following figure:

2. Select any cell below the horizontal page break you want to delete. That is, any row of cells under the dotted line. For example, if the page break is below line 7, you can select any line below line 7. After selecting this line, click "Insert → Delete Page Break" in the menu taskbar, and the page break will be deleted.

Thirdly, after deleting the page break, the dotted line in the Excel worksheet disappears and returns to the state without page break. If it is vertical paging, the deletion method is basically the same as the parallel paging deletion method mentioned above, except that when selecting, you should select any cell on the right side of the vertical page break and click the menu to operate.

4. If there are many page breaks, to delete all page breaks, in normal view, you can click the box where the row label and column label intersect in the upper left corner of the worksheet to select the whole worksheet, and then click Insert → Reset All Page Break to delete all page breaks.

5. If there are many pages, you can delete page breaks. You can also right-click any cell in the Page Break Preview view and select Reset All Page Breaks in the shortcut menu that pops up to delete page breaks.

6. In Excel 2007, the operation of inserting and deleting page breaks is to select the page layout tab in the ribbon, and then click the separator button in the page setup group to select from the drop-down list. Other operation methods are the same as Excel 2003.