Sometimes you may need to print out your data from Excel spreadsheets. In that case, if there are Borders then it will be easy to read the data. But sometimes the border may not be showing in Excel. So, in this article, I will explain the reasons and solutions for not showing borders in Excel.
Border Not Showing in Excel: 6 Reasons & Solutions
Here, I will describe 6 possible ways to fix not showing Border in Excel. In addition, for your better understanding, I’m going to use a sample data set named Border not Showing. Which contains 3 columns. These are Student ID, Test Score, and Status. The dataset is given below.
1. Changing Line Color
Sometimes, there are such cases when you use the border but still, the border is not visible on the Excel sheet or even the printed copies. In that case, perhaps, the border color becomes White. If the border color becomes White, then the borders will not be visible not only in the Excel sheet but also in the printed copies.
Now, notice the following dataset. Some cells have lost their proper borders even though, I used borders. This is because the Borders line color becomes White.
Following, I have attached the printed copy. There are also some missing Borders.
- Here, you can see the reason clearly. The Line Color of the Borders becomes White.
- On the other hand, sometimes it can happen if the Line color of the Border matches the paper color.
- Moreover, if the Fill color of cells matches the Border color, then the Borders won’t be visible.
Now, let’s talk about the solution.
- First, from the Home tab >> go to the Borders menu.
- Then, from the Line Color >> choose any dark color (except White or those which are close to White).
- After that, you can draw the Borders with a Pencil where there are White borders.
- Otherwise, just select the cells to apply the new borders.
- Then, you may choose All Borders from the Borders menu under the Home tab.
- Here, you can see the following dataset has visible borders.
- Furthermore, I have attached the new printed copy where all borders are visible. Here, you can use Excel keyboard shortcuts CTRL+P to check the print preview.
Read More: How to Insert Border in Excel
2. Use of Format Cells Feature
Sometimes, the borders won’t be visible in the printed copies for using None Border. Furthermore, if the Borderline color becomes White then there will be no Borders in Excel when printing.
Thus, you have to Re-Format the cells. Here, you can use the Format Cells feature to solve this problem. The steps are given below.
- At first, you may select the data.
- Then, press the CTRL+1 keys.
Here, also you may Right Click on the data. Then, from the Context Menu Bar >> you may select the Format Cells option.
- Subsequently, a dialog box named Format Cells will appear.
- Now, from that Format Cells dialog box >> you have to go to the Border option.
- Then, you need to select both Outline and Inside.
- After that, you should check the Color whether it is White or not. If it is White, then make it Black or any dark color.
- Finally, you must press OK to make the changes.
- At this time, if you will be able to see the Borders.
3. Expand Size of Cells
Suppose you use long text inside the cells and the cells are compressed as below.
In this case, if you see the printed copy then you will notice that Border is not showing in the printed copies or even in Excel.
Now, let’s talk about the solution.
- Here, you may use the Mouse cursor on the Column head to expand the columns. Expand the columns as all the text should remain in the cells properly.
- As you can see, I have attached the new printed copy where all Borders are visible.
Read More: How to Apply All Borders in Excel
4. Applying Color Index in Cell Using VBA
In case you want to color your data cells, then don’t paint the cells. If you paint them, then there is a good chance of not showing the border in Excel.
So, the solution is, that you should use the Excel VBA Color Index to color your cells. As an example, I have used alternate row colors in my dataset. Moreover, I have attached the following code of the color index and the effect of that color.
- Here, you can easily see all the Borders.
Read More: How to Add or Remove Dotted Border in Excel
5. Don’t Merge Any Cell
Let there be some cells merged in your dataset. In this case, you will see that Border is not showing in Excel.
- First, select your data.
- Then, from the Home tab >> choose Merge & center which is under the Alignment group. Here, you may notice that for unmerging some of the data consisting of one cell, you should re-write them again according to your preference.
- Now, select your data again.
- Then, from the Home tab >> choose the All Borders option.
- As a result, the Borders will be visible to you.
Read More: How to Change Border Color in Excel
6. Unprotect Worksheet in Excel
Sometimes you may keep your Excel file protected. In that case, the border may not be showing in Excel. Then, you should unprotect your Excel worksheet to keep visible the borders.
Furthermore, you should keep all cells visible. This means don’t keep any row or column hidden. For the visibility of Borders, you should unhide all the rows and columns.
Read More: How to Lock Borders in Excel
💬 Things to Remember
- Always, must use the All Borders option under the Borders option for showing Borders in Excel.
Now, you can practice the explained method by yourself.
Download Practice Workbook
You can download the practice workbook from here:
I hope you found this article helpful. Here, I have explained 6 suitable solutions for not showing Border in Excel. Please drop comments, suggestions, or queries if you have any in the comment section below.
- How to Make Graph Paper in Excel
- How to Remove Page Border in Excel
- How to Cancel Moving Border in Excel