How to Show Gridlines in Excel When Printing (6 Easy Ways)

Gridlines are the pale lines around each cell in your Excel worksheet. These lines define the space occupied by each cell and make your data easier to read. You’ll see by default the gridlines don’t show when you print your Excel sheet. The main objective of this article is to explain how to show gridlines in Excel when printing.

Download Practice Workbook

6 Easy Ways to Show Gridlines in Excel When Printing

Here, I will explain how to show gridlines in Excel in 6 different methods. I have taken the following dataset to explain this article. The dataset contains Month and Sales information.

1. Use of Sheet Options to Show Gridlines in Excel When Printing

In this method, I will show you how to show gridlines in Excel when printing by using the Sheet Options group.

Let’s see the steps.

Step-01: Checking If Gridlines Are Showing

In this step, I will show you how you can check if the gridlines will show when printing.

• Firstly, go to the File tab from the Ribbon.

• Secondly, select the Print option.

Now, you will be able to see the Print Preview. Here, you can see the gridlines are not showing.

Step-02: Using Sheet Options Group to Show Gridlines

In this step, I will show you how you can use the Sheet Options group to show gridlines when printing.

• Firstly, go to the Page Layout tab.
• Secondly, select the Sheet Options group.

Now, you will see a drop-down menu will appear.

• Thirdly, select the Print option from Gridlines.

• After that, select the File tab.

• Next, select the Print option.

Now, you will be able to see the Print Preview. Here, you can see the gridlines are showing.

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

2. Employing Page Setup Group to Show Gridlines in Excel When Printing

In this method, I will show you how to show gridlines in Excel when printing by employing the Page Setup group.

Let’s see the steps.

Steps:

• Firstly, check the Print Preview to see if the gridlines are showing by following the procedure from Step-01 of Method-1. Here, the gridlines are not showing in my Print Preview.

Now, go back to your worksheet to do further operations.

• First, go to the Page Layout tab.
• Secondly, select the dialog box option from Page Setup.

Here, you will see the dialog box named Page Setup.

• Firstly, go to the Sheet tab.
• Secondly, select Gridlines from Print.
• Thirdly, select the Print Preview.

Now, you will be able to see the Print Preview. Here, you can see the gridlines are showing.

Read More: How to Print Excel with Lines on One Page (3 Easy Methods)

3. Using Print Titles Feature to Show Gridlines in Excel When Printing

In this method, I will explain how to show gridlines in Excel when printing using the Print Titles feature.

Let’s see the steps.

Steps:

• Firstly, check the Print Preview to see if the gridlines are showing by following the procedure from Step-01 of Method-1. Here, the gridlines are not showing in my Print Preview.

Now, go back to your worksheet.

• Firstly, go to the Page Layout tab.
• Secondly, select the Print Titles feature.

Here, you will see the dialog box has appeared.

• Firstly, check the Gridlines from Print.
• Secondly, select the Print Preview.

Now, you will see the Print Preview. Here, you can see the gridlines are showing.

Read More: How Do You Fix Missing Gridlines in Excel (5 Ways)

Similar Readings

• [Fixed!] Why Are Some of My Gridlines Not Showing in Excel?
• How to Hide Gridlines in Excel When Printing (4 Quick Tricks)
• Show Gridlines after Using Fill Color in Excel (4 Methods)
• How to Print Gridlines with Empty Cells in Excel (2 Methods)
• [Fixed] Excel Gridlines Not Showing by Default (3 Solutions)

4. Use of Print Option to Show Gridlines in Excel When Printing

In this method, I will explain how to show gridlines in Excel when printing by the use of the Print option.

Let’s see the steps.

Steps:

• Firstly, go to the File tab.

• Secondly, select the Print option.

Now, in the Print Preview you can see that the gridlines are not showing.

• After that, select Page Setup from Settings.

Here, you will see a dialog box has appeared.

• Now, go to the Sheet tab.
• Next, select Gridlines from Print.
• Finally, select OK.

Now, you will be able to see the Print Preview. Here, you can see the gridlines are showing.

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

5. Using Excel Options to Change Color of Gridlines When Printing

In this method, I will show you how you can change the color of your gridlines when printing.

Let’s see the steps.

Steps:

• Firstly, check the Print Preview to see if the gridlines are showing by following the procedure from Step-01 of Method-1. Here, the gridlines are not showing in my Print Preview.

After that, go back to your worksheet to do further operations.

• Firstly, select the File tab.

• Secondly, select Options.

Here, you will see a dialog box.

• Firstly, select Advanced.
• Secondly, select the drop-down option from the Display option for this worksheet.
• Thirdly, select the worksheet you want to work with. Here, I selected the worksheet named Changing Color of Gridlines.

• After that, select the drop-down option for Gridline color.
• Next, select the color you want. Here, I selected Blue.

• Finally, select OK.

Now, you will see the color of the gridlines is changed.

• After that, go to the Page Layout tab.
• Next, select the Sheet Options group.

Here, you will see a drop-down menu will appear.

• Then, select the Print option from Gridlines.

Now, go to the Print Preview by following the procedure from Step-02 of Method-1. Here, you will see the gridlines are showing.

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

6. Use of Border Command to Show Gridlines in Excel When Printing

In this method, I will show you how to show gridlines in Excel when printing using the border command.

Let’s see the steps.

Steps:

• Firstly, check the Print Preview to see if the gridlines are showing by following the procedure from Step-01 of Method-1. Here, the gridlines are not showing in my Print Preview.

Now, go back to your worksheet to do further operations.

• Firstly, select the whole worksheet by clicking on the marked portion in the following image.
• Secondly, go to the Home tab.
• Thirdly, select the drop-down option for Borders.

Now, a drop-down menu will appear.

• After that, select All Borders.

Here, you will see the borders are added to your Excel sheet.

Now, go to the Print Preview by following the procedure from Step-02 of Method-1. Here, you will see the gridlines are showing.

Things to Remember

• It should be noted that the Draft quality option must be unchecked if you want to show gridlines when printing.

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

Practice Section

Here, I have provided a practice sheet for you to practice how to show gridlines in Excel when printing.

Conclusion

In this article, I tried to explain how to show gridlines in Excel when printing. I covered 6 different methods of doing it. I hope, this article was helpful for you. To get more articles like this visit ExcelDemy. Lastly, if you have any questions, feel free to let me know in the comment section below.

Related Articles

• How to Get Gridlines Back in Excel (5 Possible Solutions)
• Excel Fix: Gridlines Disappear When Color Added (2 Solutions)
• How to Print Empty Gridlines in Excel (2 Easy Ways)
• Keep Gridlines When Copy and Paste in Excel (2 Ways)
• How to Print a Blank Sheet with Lines in Excel (3 Effective Ways)