How to add page breaks in excel

How to add page breaks in Excel: First click "Workbook View-Page Break Preview"; then click the row below which you want to insert a page break; and finally click "Page" on the "Page Layout" tab In the Settings group, click Separator.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to add page breaks in excel:

1. Open the excel document and select the worksheet you want to edit or print.

#2. In the "Workbook View" group on the "View" tab of the functional area, click "Page Break Preview".

#3. Then the "Welcome to Pagination Preview" dialog box will appear, click "OK". If you don't want this dialog box to appear every time you go to pagination preview view, select the Don't show this dialog again check box, and then click OK.

#4. To insert a horizontal page break, click on the line below which you want to insert the page break. If you want to insert a vertical page break, click on the column to the right of the column to insert the page break.

#5. Then on the Page Layout tab, in the Page Setup group, click Separator.

#6. Select line 29 and set the horizontal page break. You will get the horizontal page break as shown below.

#7. Select column D and set the vertical page break. You will get the vertical page break as shown below.

Related learning recommendations: excel tutorial

The above is the detailed content of How to add page breaks in excel. For more information, please follow other related articles on the PHP Chinese website!