How to Remove Page Border in Excel (3 Methods)

Sometimes, we apply Borders in Excel cells to make them stand out. But we also need to Remove those Borders when they are not useful or necessary anymore in our Excel datasheets. In this article, you’ll get to know three quick methods to Remove Page Border in Excel effectively with appropriate illustrations. To do that, we will apply Keyboard Shortcuts, No Border command, and so on. Here’s an overview of the dataset for today’s task.

remove page border in excel


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Suitable Ways to Remove Page Border in Excel

1. Use Keyboard Shortcuts to Remove Page Border in Excel

We will use the keyboard shortcuts Ctrl + 1 to remove the page border. From our dataset, we can easily do that. This is time-saving also. Let’s follow the instructions below to remove the page border in Excel!

Steps:

  • First of all, select cells range from B4 to F15 for the convenience of our work.
  • After that, press Ctrl + 1 on your keyboard simultaneously.

Use Keyboard Shortcuts to Remove Page Border in Excel

  • As a result, a Format Cells dialog box will appear in front of you.
  • From the Format Cells dialog box, firstly, select the Border.
  • Secondly, select the None option under the Presets menu.
  • Hence, press OK.

  • After completing the above process, you will be able to remove the page border which has been given in the below screenshot.

Use Keyboard Shortcuts to Remove Page Border in Excel

Read More: How to Print Borders at Page Break in Excel (2 Quick Methods)


2. Apply Format Cells Command to Remove Page Border in Excel

Another way to remove the page border is the Format Cells command. From our dataset, we can apply the Format Cells command to remove the page border. We will remove the page border from the cells range B4 to F15. Let’s follow the instructions below to learn!

Steps:

  • First of all, select cells range from B4 to F15 for the convenience of our work.

Apply Format Cells Command to Remove Page Border in Excel

  • After that, press right-click on your keyboard.
  • Hence, a window will appear in front of you.
  • From the window, select the Format Cells option.

  • As a result, a Format Cells dialog box will appear in front of you.
  • From the Format Cells dialog box, firstly, select the Border.
  • Secondly, select the None option under the Presets.
  • Hence, press OK.

Apply Format Cells Command to Remove Page Border in Excel

  • After completing the above process, you will be able to remove the page border which has been given in the below screenshot.

Read More: How to Add or Remove Cell Borders in Excel


3. Use Borders Command to Remove Page Border in Excel

Last but not the least, we will use the Borders command to remove page borders in Excel. Let’s follow the instructions below to learn!

Steps:

  • First of all, select cells range from B4 to F15 for the convenience of our work.

Use Borders Command to Remove Page Border in Excel

  • After that, from your Home ribbon, go to

Home → Font → Borders → No Border

  • As a result, you will be able to remove the page border which has been given in the below screenshot.

Use Borders Command to Remove Page Border in Excel


Things to Remember

➜ While a value can not found in the referenced cell, the #N/A! error happens in Excel.

#DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Conclusion

I hope all of the suitable methods mentioned above to remove the page border will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo