How to Remove Page Border in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Removing page borders in Excel refers to erasing borders from the outside cells of a page.

In this Excel tutorial, you will learn how to remove any page border in Excel.
Although there isn’t any exact feature like Page Border in Excel, we can add page borders in the print area by applying the Outside Borders command. For example, consider the following dataset that contains a few employee details.

Sample Dataset to Demonstrate How to Remove Page Border in Excel

If you click the Page Layout button from the Status Bar, you will view the borders around some of the pages.

Page Border in Page Layout View of the Workbook

If you try to print the worksheet, you will notice these page borders in the print area as well.

Page Border in Print Area

Click the image for a detailed view

Now removing page border in Excel can be done in two ways: Using the Erase Border tool or using the No Border command.


1. Applying Erase Border Tool to Remove Page Border

Removing any page border can be quickly done by the Erase Border tool. Apply the following steps to remove the page border by using the Erase Border tool.


Step 1: Select Page Layout Button

  • In the bottom-right corner of your Excel window, you will find the Page Layout button.

Selecting Page Layout Command from Status Bar View Buttons

  • Click the Page Layout button and your workbook view will be like the following. You can see the page borders around the layout of the page.
Page Border in Page Layout View of the First Page

Click the image for a detailed view


Step 2: Select Erase Border Tool

  • Go to the Home tab => click the Borders dropdown => you will find the Erase Border option under the Draw Borders group of commands.
Selecting the Erase Border to Remove Page Borders in Excel

You can click the image for a detailed view

  • If you select the Erase Border tool, small plus (+) icons will appear in each corner of the cells. You will also notice an Eraser icon instead of the arrow symbol of your mouse pointer.

Border Eraser Icon in Excel


Step 3: Erase Page Borders

  • Drag the Eraser icon over the page borders to remove them.
  • After removing page borders, click the Erase Border button or the Esc key. You will notice there are no page borders now.

How to Remove Page Border in Excel Using the Erase Border Tool

Read More: How to Remove Borders in Excel


2. Using No Border Command

We can also apply the No Border command to remove page border in Excel. However, the borders in the actual dataset will be removed in this case. Therefore, you have to restore the cell border of the dataset.

Follow the steps below to remove borders using the No Border command.


Step 1: Check Page Layout from View Tab

  • First, go to the View tab. You will see the Page Layout option under the Workbook Views group of commands. You can find this option in the bottom-right corner of your Excel window as well.

Selecting Page Layout Command from the View Tab

  • After clicking the Page Layout command, your workbook view will split into pages. Now, you can view the page border around the layout of the first page (i.e. range A1:G47).
Page Border in Page Layout View of the First Page

Click the image for a detailed view


Step 2: Remove All Borders from the Page

  • Select the range A1:G47 (i.e. all cells on the first page) and go to the Home tab. You will see the Borders dropdown under the Font group of command.
Selecting All Cells in First Page to Remove Page Border in Excel

You can click the image for a detailed view

  • Click the Borders dropdown and you will find the No Border command.

Selecting No Border Command to Remove All Borders from the Page in Excel

  • After selecting the No Border command, the page border and cell borders will be removed.

No Borders in Page Layout of the First Page


Step 3: Return to Normal View of Workbook

  • After that, go to the View tab again. You will see the Normal option under the Workbook Views group of commands.

Selecting Normal Workbook View from the View tab


Step 4:  Restore the Borders of the Dataset

  • After clicking the Normal command, the Workbook view will return to normal. As the cell borders of the dataset are also gone, we have to restore the borders. If you don’t require cell borders in the dataset, then you can skip this step.
  • Select the range B4:F23 (i.e. data table) and go to the Home tab. We have to use the Borders option again.

Selecting All Cell in Data Table to Restore Borders

  • Click the Borders dropdown and you will find the All Borders command.

Selecting All Border Command to Restore Cell Borders of Data Table

  • After clicking the All Borders command, you will get cell borders around the cells of range A4:F23.
  • After that, select the merged cell B2:F2 (i.e. table header) and go for the Borders dropdown again.

Selecting Cells of Table Header to Restore Borders

  • After clicking the Borders dropdown, you will get the Thick Bottom Border command.

Selecting Thick Bottom Border Command to Restore Borders in Table Header

  • After selecting the Thick Bottom Border command, you will get a bottom border in the merged cell B2:F2. Our dataset borders are now restored.

Dataset After Removing Page Border in Excel

Now, if you click the Print command from the left-side pane of the File tab (or, apply the keyboard shortcut Ctrl + P). You will get the following print preview. As you can see, there is no page border in the print area.

No Page Borders in Print Preview

You can click the image for a detailed view

Read More: [Fixed!] Border Not Showing in Excel


Tips While Removing Page Border in Excel

  • There isn’t any exact feature for applying or removing page borders in Excel. Page borders are added by applying the Outside Borders command around the cells of the page.
  • The position of the page border may vary based on the settings of page margins.

Download Practice Workbook


Conclusion

This concludes our tutorial on how to remove any page border in Excel. We showed steps to use the Erase Border or No Border command to remove any page border. We hope that this tutorial was helpful for your requirements. Let us know your feedback in the comment section.


Related Articles


<< Go Back to Cell Borders in Excel | Excel Cell FormatLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Seemanto Saha
Seemanto Saha

Seemanto Saha graduated in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. He has been with ExcelDemy for a year, where he wrote 40+ articles and reviewed 50+ articles. He has also worked on the ExcelDemy Forum and solved 50+ user problems. Currently, he is working as a team leader for ExcelDemy. His role is to guide his team to write reader-friendly content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo