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.

Use of Sheet Options to Show Gridlines in Excel When Printing

  • Secondly, select the Print option.

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

Use of Sheet Options to Show Gridlines in Excel When Printing


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.

Use of Sheet Options to Show Gridlines in Excel When Printing

  • Next, select the Print option.

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

Use of Sheet Options to Show Gridlines in Excel When Printing

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.

Employing Page Setup Group to Show Gridlines in Excel When Printing

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.

Employing Page Setup Group to Show Gridlines in Excel When Printing

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.

Using Print Titles Feature to Show Gridlines in Excel When Printing

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

Using Print Titles Feature to Show Gridlines in Excel When Printing

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


Similar Readings


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.

Use of Print Option to Show Gridlines in Excel When Printing

Here, you will see a dialog box has appeared.

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

Use of Print Option to Show Gridlines in Excel When Printing

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.

Using Excel Options to Change Color of Gridlines When Printing

  • 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.

Using Excel Options to Change Color of Gridlines When Printing

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

Using Excel Options to Change Color of Gridlines When Printing

  • Finally, select OK.

Using Excel Options to Change Color of Gridlines When Printing

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.

Using Excel Options to Change Color of Gridlines When Printing

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.

Use of Border Command to Show Gridlines in Excel When Printing

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.

Use of Border Command to Show Gridlines in Excel When Printing

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.

Use of Border Command to Show Gridlines in Excel When Printing


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

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo