Md. Abdur Rahim Rasel
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.
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.
- 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.
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.
- 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.
- 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.
- 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.
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.
