WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to hide page breaks in Excel?

January 11, 2022
4.4K Views

In the world of Excel, where numbers rule and tables sprawl, a curious hiccup arises. Imagine this: all seems set, but then pesky page lines appear, puzzling fresh learners. Our task as teachers is clear: to shed light with care, making the complex seem clear. Among many ways, our goal is simple - to guide and make it simple again. So, how to unhide rows in Excel? This guide holds the key.

Part 1: How to Delete Page Breaks in Excel

Remove a Manual Page Break

Step 1 Click the "Page Break Preview" icon on the Status Bar or access it via Ribbon View > Page Break Preview.

View


Step 2 Select the appropriate element to delete the page break:

  • To remove a horizontal page break, choose the row just below the targeted break.

  • For a vertical page break, select the column immediately to the right of the desired break.

  • To eliminate a criss-cross page break, select the cell at the bottom-right corner of the break.

Step 3 Proceed to the Page Layout tab, located in the Ribbon. In the Page Setup section, find the "Breaks" button and select "Remove Page Break."

Remove Page Break


Alternatively, you can right-click the selected area and choose "Remove Page Break" from the context menu. Alternatively, use the keyboard shortcut ALT + P + B + R to achieve the same result.

The result


This method is the most precise way to remove a manual page break, as you can select the exact page break that you want to remove. However, it can be a bit time-consuming if you need to remove multiple page breaks.

Reset All Manual Page Breaks

Step 1 Move to the Page Layout tab and locate the "Page Setup" section. Within this section, click on the "Breaks" button.

Page layout


Step 2 From the dropdown menu, select the "Reset All Page Breaks" option.

Reset all


Alternatively, you have the choice to right-click anywhere on the sheet. From the context menu, choose "Reset All Page Breaks."

As an additional method, you can swiftly achieve this action using the keyboard shortcut ALT + P + B + A.

Result


This method is useful if you want to remove all manual page breaks in a worksheet at once. However, it is important to note that this will not remove any automatic page breaks that Excel has inserted.

Part 2: How to Hide Page Breaks in Excel

Excel offers the flexibility to determine page transitions during printing by placing page breaks. If you wish to conceal these breaks while in normal view, adhere to the steps below:

Step 1 Open the Ribbon and navigate to File > Options.

option


Step 2 Inside the Excel Options window, opt for "Advanced" from the menu situated on the left-hand side. Scroll down to the section titled "Display options for this worksheet."

Advanced


Step 3 Deselect the "Show page breaks" box. Confirm your choice by clicking OK.

Desect


By following these steps, you successfully obscure the page breaks

This method is useful if you want to hide page breaks in the Normal view, so that you can focus on the data in your worksheet. However, it is important to remember that page breaks will still be visible in Page Break Preview.

Part 3: Comparison of the Three Methods

Method

Description

Pros

Cons

Remove a Manual Page Break

Select the row or column below or to the right of the page break, and then click Remove Page Break on the Breaks menu.

The most precise way to remove a manual page break.

Can be time-consuming if you need to remove multiple page breaks.

Reset All Manual Page Breaks

Click Reset All Page Breaks on the Breaks menu.

A quick way to remove all manual page breaks in a worksheet.

Does not remove any automatic page breaks that Excel has inserted.

Hide page breaks in Normal view

Uncheck the Show page breaks checkbox in the Advanced section of the Excel Options dialog box.

Hides page breaks in Normal view, so that you can focus on the data in your worksheet.

Page breaks will still be visible in Page Break Preview.

The best method to use depends on your specific needs. If you need to remove a single manual page break, the most precise way is to use the Remove a Manual Page Break method. If you need to remove multiple manual page breaks, the Reset All Manual Page Breaks method is a quick way to do it. If you want to hide page breaks in Normal view, the Hide page breaks in Normal view method is the best option.

Part 4: Why Use WPS Office?

WPS Office



While the methods discussed are applicable to both Microsoft Excel and WPS Office Spreadsheet, there are compelling reasons to consider using WPS Office. Here's why we recommend downloading and utilizing WPS Office for your spreadsheet needs:

  • Price: WPS Office is free to use for personal and educational purposes. Microsoft Excel is not free, and you need to purchase a subscription to use it.

  • Compatibility: It seamlessly works with Microsoft Excel formats, ensuring smooth document exchange.

  • Features: WPS Office provides a comprehensive suite for various needs, from basic calculations to advanced data analysis.

  • User-friendly Interface: Its intuitive design suits all users, fostering ease of use and productivity.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

How to Hide Page Breaks in WPS Office

1. Click Menu > Options > View.

2. In the view area, uncheck Page breaks. Then click OK.

FAQs About Hide Page Breaks in Excel

How Do I Hide a Page in the Page Break View?

To hide a page in Page Break view, click the "File" tab, proceed to "Options" -> "Advanced," then scroll down to the "Display options for this worksheet" group and uncheck the "Show page breaks" checkbox as needed, allowing you to easily control the visibility of page breaks in the Normal view.

Why Is Page Break Not Deleting?

The persistence of page breaks not deleting might be attributed to having Track Changes enabled in Word. To resolve this, disable Track Changes by navigating to the Review tab on the top ribbon, clicking on Track Changes, and selecting it again. This will turn off Track Changes and likely allow you to successfully remove the page breaks.

Summary

Through this guide, we've learned about Excel's page breaks, making things easier. We now know how to delete and reset them. Wrapping up our exploration, a noteworthy option to enhance your Excel experience naturally emerges: WPS Office. With its blend of user-friendly design, compatibility, and cost-effectiveness, it seamlessly complements your spreadsheet tasks.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.