Skip to main content

How to insert or remove page break in Excel?

When you want to print a worksheet, you may need to insert or remove the page breaks for printing more professionally. Here I talk about how to insert or remove page break in Excel for you.

Insert page break in Excel

Remove page break in Excel


arrow blue right bubble Insert page break in Excel

In Excel, you can insert page break by two methods, one is using right-click, and the other is using Break function.

Insert page break by right-click

1. Click View > Page Break Preview. See screenshot:

doc-insert-page-break-1

Tip: You also can click Page Break Preview button in the status bar.

2. If you want to insert a horizontal page break above a specified row, you need to select the first cell of this row, right click the cell, and then click Insert Page Break from the context menu. See screenshot:

doc-insert-page-break-2

Now a horizontal page break has been inserted.

doc-insert-page-break-3

3. Then just click Normal under View tab to go back to normal view. See screenshot:

doc-insert-page-break-4

Note: If you want to insert a vertical page break before a column, you need to select the first cell of the column, and right click to select Insert Page Break. See screenshots:

doc-insert-page-break-5
doc-1
doc-insert-page-break-6

Insert page break by Break function

If you want to insert a vertical page break, select the first cell of a column which will be right to the page break you want to insert, and click Page Layout > Breaks > Insert Page Break. See screenshot:

doc-insert-page-break-7

Tip: If you want to insert a horizontal page break, select the first cell of a row which will be below the page break you want to insert, and click Page Layout > Breaks > Insert Page Break.


arrow blue right bubble Remove page break in Excel

Remove page break also can use Break function in Excel.

If you want to remove a horizontal page break, select the cell which is below to the page break you want to remove, and click Page Layout > Breaks > Remove Page Break. See screenshot:

doc-insert-page-break-8

Tip:

1. If you want to remove a vertical page break, select the any cell of the column which is right to the page break you want to remove, and click Page Layout > Breaks > Remove Page Break.

2. If you want to remove all page break, both of vertical page breaks and horizontal breaks, you can click Page Layout > Breaks > Remove All Page Break.

Note: The automatic page break cannot be removed.


Relative Articles:

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations