[Fixed!] Table Border Not Showing in Print Preview (2 Solutions)

In order to decorate our data while working with Microsoft Excel, we often use tables. Normally, the data are organized in different rows and columns in a table within a certain border. It is possible to happen to anyone that in time of Print preview, the table border is not available. If you are looking for the solution to the problem table border not showing in Print Preview, you will be glad to know that you have come to the right place for the solution. I am going to explain 2 simple solutions to this problem in this article. I hope it will be very helpful for you.

For more clarification, I am going to use a dataset of Annual Exam Results in the Student, Physics, Chemistry, and Math columns.

Table Border not Showing in Print Preview


Download Practice Workbook


2 Simple Solutions for Table Border Not Showing in Print Preview

There may be several reasons for the table border not showing in the preview (or after print) while printing it, like borders not selected, gridlines are not set to print. Let’s see how to deal with the issue and show the borders.


1. Using Gridlines as Table Border in Print

Gridlines are the default format in Excel Worksheet. We can use these gridlines as border to solve the problem of table border not showing in Print Preview. For this, you need to follow some sequential processes. They are described in the below section.

Steps:

  • First of all, go to the Page Layout tab.
  • Check the Print box from the Gridlines option in the ribbon.

Table Border not Showing in Print Preview

  • Followingly, select the whole table. In this case, my table range is B4:E11.
  • Click on the Page Layout tab.
  • Choose Print Area from the ribbon.
  • Next, pick the Set Print Area This command will choose the selected area for Print.

Table Border not Showing in Print Preview

  • After that, go to the File tab.
  • From the available options, select Print.

Alternatively, you can press CTRL + P to have the Print Preview.

We can see in the Print Preview section that the Gridlines have worked there as the table border.

Table Border not Showing in Print Preview

Read More: How to Remove Page Border in Excel (3 Methods)


Similar Readings


2. Showing Border Using Borders from Home Tab

We can set the table border manually to solve this problem. This is not a complicated process at all. The steps are simplified in the following section.

Steps:

  • Firstly, select the whole table. Here, my table range is B4:E11.
  • Next, click on the Home tab.
  • Choose the Borders option from the ribbon.
  • From the available options, pick a type that covers the whole table. I have picked the Thick Outside Borders options.

  • Now, go to the Page Layout tab.
  • Then, click on Print Area from the ribbon.
  • Next, pick the Set Print Area This command will choose the selected area for Print.

Table Border not Showing in Print Preview

  • Followingly, go to the File tab.
  • Select Print from the available options.

Now, in the Print Preview section, we can see our desired table border.

Table Border not Showing in Print Preview

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


Practice Section

You can practice here. Practice will improve your efficiency in solving this problem.


Conclusion

At the end, I like to add that I have tried to explain 2 simple solutions for the table border not showing in Print Preview problem in this article. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo