[Fixed!] Missing Gridlines in Excel When Printing (5 Solutions)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes you may need to print out your data or Excel spreadsheets. In that case, if there is Gridlines then it will be easy to read the data. But, sometimes there may be missing Gridlines in Excel when printing. So, in this article, I will explain how to fix missing Gridlines in Excel when printing.


Download Practice Workbook

You can download the practice workbook from here:


5 Reasons & Solutions for Missing Gridlines in Excel When Printing

Here, I will describe 5 possible ways to fix missing Gridlines in Excel when printing. In addition, for your better understanding, I’m going to use a sample data set named Missing Gridlines When Printing. Which contains 3 columns. These are Student ID, Test Score, and Status. The dataset is given below.

 Missing Gridlines in Excel When Printing


1. Using Page Layout Ribbon in Excel

If your Gridlines are not selected from Sheet Options then it won’t be visible when printing. First, you will need to check whether it is selected or not.

It is mandatory to keep Gridlines visible in Excel when printing, by adding a tick mark on the Print option under Gridlines.

To check the options follow the steps given below.

Solution:

  • Firstly, you have to open your worksheet in Excel.
  • Secondly, you must go to the Page Layout ribbon. Here, you can also use Excel keyboard shortcuts ALT+P to go to the Page Layout ribbon.
  • Thirdly, from the Sheet Options >> Click tick mark to Print under Gridlines option.
  • Finally, you need to click on the Drop-Down Arrow to see the printing draft.

At this time, a dialog box named Page Setup will appear.

  • Here, you must make sure that the Gridlines option of Print section under Sheet command is marked.
  • Now, you need to select the Print Preview option from that Page Setup dialog box.

 Missing Gridlines in Excel When Printing

After that, you will see the following page layout which includes the Gridlines.

Thus, you should use the Page Layout ribbon to fix missing Gridlines in Excel when printing.

Read More: How to Print Gridlines in Excel (2 Ways)


2. Change Gridlines Color

Sometimes, there are such cases when you keep on the Gridlines while printing but still the Gridlines are not visible to the printed copies. In that case, perhaps, the Gridlines color becomes  White. If the Gridlines color becomes White then the Gridlines will not be visible in the printed copies.

Basically, this method is for checking purpose that either the Gridline color becomes White or remains auto-selected Grayish.

Now, let’s make changed the Gridlines color to fix missing Gridlines in Excel when printing. So, the steps are given below.

Solution:

  • At first, you need to go to the File ribbon.

 Missing Gridlines in Excel When Printing

  • Now, you have to select the Options command.

At this time, a dialog box named Excel Options will appear.

  • Now, you need to select the Advanced feature.
  • Then, from Gridline color >> choose your preferable color. Here, I have chosen green. Or, you can keep the Automatic color.
  • Finally, you must press OK to make the changes.

 Missing Gridlines in Excel When Printing

  • Now, you must go to the Page Layout ribbon.
  • Then, from the Sheet Options >> Click tick mark to Print under Gridlines option.
  • Finally, you need to click on the Drop-Down Arrow to see the printing draft.

At this time, a dialog box named Page Setup will appear. Here, I will select the printing area.

  • Now, from the Sheet command in the Page Setup dialog box >>  you may go to Drop-Down Arrow which is adjacent to the Print area.

 Missing Gridlines in Excel When Printing

  • At this time, you need to select the data up to which you want to print them. Here, I have selected the data range A1:E11.
  • Then, you must click on the Drop-Down Arrow to go back to the whole Page Setup dialog box.

  • Here, you must make sure that the Gridlines option of Print section is marked.
  • Finally, you need to press OK to make changes.

 Missing Gridlines in Excel When Printing

Now, if you go to the Print Preview option then you can see the following result which has visible Gridlines.

Hence, you should check the Gridlines Color.

Read More: How to Print Excel Spreadsheet with Lines and Change Its Color


Similar Readings


3. Check Fill Color of Printing Area

Suppose, you filled the background of a dataset with colors. In such a case, if you print the Excel spreadsheet then the Gridlines won’t be visible in the printed copies. I have given an example of this below.

Here, the following dataset is filled with a background color.

Now, let you have marked the Print under the Gridlines option.

 Missing Gridlines in Excel When Printing

But, if you preview the printing draft then you will see no Gridlines in that paper. Here, I have attached the printing draft below.

So, you can follow the steps, given below to solve the problem of missing Gridlines in Excel when printing.

Solution:

  • Firstly, you need to select the data range up to which you want to print. Here, I have selected the range A1:E11.
  • Secondly, you may go to the Home tab. Or, you can use the Context Menu Bar option for this. Where you will also get the Fill Color feature.

 Missing Gridlines in Excel When Printing

  • Now, from the Fill Color feature >> you must choose No Fill option.

At this time, you will see the following changes.

 Missing Gridlines in Excel When Printing

  • Now, you must go to the Page Layout ribbon.
  • Then, from the Sheet Options >> Click tick mark to Print under the Gridlines option.

Here, I have also changed the Title of my dataset to “Applying No Fill Color” in the following image.

At this moment, if you preview the printing draft then you will be able to see the Gridlines. The result is given below.

 Missing Gridlines in Excel When Printing

Briefly, you must not use a background color to keep the Gridlines in Excel when printing.

Read More: How to Print Gridlines with Fill Color in Excel (4 Useful Ways)


4. Removing Conditional Formatting

If there is any Conditional Formatting, then you may not see the Gridlines in the printing copies. So, you can remove the Conditional Formatting to fix missing Gridlines in Excel when printing. The steps are given below.

Solution:

  • Firstly, you need to select the data range up to which you want to print. Here, I have selected the range B2:D10.
  • Secondly, you may go to the Home tab.
  • Thirdly, from the Conditional Formatting >> you have to choose Clear Rules option.

  • Now, from the Conditional Formatting >> you need to select Clear Rules from Selected Cells under the Clear Rules option.

 Missing Gridlines in Excel When Printing

  • Now, you must go to the Page Layout ribbon.
  • Then, from the Sheet Options >> you have to check Print under the Gridlines option.

At this time, if you preview the printing draft then you will be able to see the Gridlines. The result is given below.

 Missing Gridlines in Excel When Printing

Read More: How to Get Gridlines Back in Excel (5 Possible Solutions)


5. Use of Context Menu Bar to Format Cells

Sometimes, the Gridlines won’t be visible in the printed copies for using White colored Inside or Outside Border.

Thus, you have to Re-Format the cells. Here, you can use the Context Menu Bar to solve this problem. The steps are given below.

Solution:

  • At first, you may select the data.
  • Then, you have to Right Click on the data.
  • Finally, from the Context Menu Bar >> you need to 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 Border option.
  • Then, you need to select None.
  • Alternatively, you can check the Color whether it is Automatic or not. If the Color becomes White then you can make it to any visible colors.
  • Finally, you must press OK to make the changes.

 Missing Gridlines in Excel When Printing

Last but not the least, you will see the following formatted cells.

At this time, if you preview the printing draft then you will be able to see the Gridlines. The result is given below.

 Missing Gridlines in Excel When PrintingRead More: How to Print Gridlines with Empty Cells in Excel (2 Methods)


💬 Things to Remember

  • Always, you must be checked the Print option under Gridlines to get the Gridlines in Excel while printing.


Practice Section

Now, you can practice the explained method by yourself.

 Missing Gridlines in Excel When Printing


Conclusion

I hope you found this article helpful. Here, I have explained 5 ways to fix missing gridlines in Excel when printing  You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Musiha Mahfuza Mukta

Musiha Mahfuza Mukta

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo