How to Print Gridlines in Excel (2 Ways)

By default gridlines of a worksheet do not appear when we print it. But gridlines, rows, and column headings could be very useful to go through the data in a printed Excel worksheet. In this tutorial, I will show you how to print gridlines in Excel along with changing the colors and preview the appearance of gridlines in the printed format by changing some settings.


Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.


2 Suitable Methods to Print Gridlines in Excel

Let’s assume a scenario where we have an Excel worksheet that contains information about the products that a country will export to different countries in Europe. We have the Order ID, Product Name, Product Category, Exported Amount, Importer Country, and the Export Date.  We will print this worksheet with its gridline visible. The image below shows how the worksheet will look if it is printed without the gridlines.

Set Gridlines on Worksheet From Page Layout in Excel

The next image shows how the worksheet will look if it is printed with the gridlines.

Set Gridlines on Worksheet From Page Layout in Excel


1. Set and Print Gridlines on Worksheet From Page Layout in Excel

We can set the gridlines in the worksheet for printing from the Page Layout option. Just follow the below steps.

Step 1:

  • First, we will select the entire data range of the worksheet we are working on.
  • Next, we will go to the Page Layout.
  • Then, we will click on the Print Area drop-down menu.
  • We will now select the Set Print Area option from the list.

select the Set Print Area option

Step 2:

  • Now, we will check the Print option under the Gridlines in the Sheet Options section of the Page Layout.

check the Print option under the Gridlines in the Sheet Options

  • Checking the Print option from the Gridlines tab will insert the gridlines in the worksheet when we will print it.

Step 3:

  • We can also use the dialogue box launcher tool to open the Page Setup.
  • We will have to click on the dialogue box launcher tool icon on the down-right corner of the Sheet Options section under the Page Layout tab like the image below.

dialogue box launcher tool icon on the down-right corner

  • A new window titled Page Setup will appear. We will click on the Sheet tab from that window.
  • Then, check the Gridlines option under the Print section.
  • Finally, click OK.

Set Gridlines on Worksheet From Page Layout in Excel

Read More: How to Fit to Page and Print in Excel (10 Ways)


Similar Readings:


2. Insert and Print Gridlines on Worksheet From Print Option in Excel

Alternatively, we can insert gridlines on the worksheet from the Print option in Excel.

Step 1:

  • First, we will click on the File.

Insert Gridlines on Worksheet From Print Option in Excel

  • A new window will appear. We will click on the Print option from that window.

Insert Gridlines on Worksheet From Print Option in Excel

Step 2:

  • Another window with different Print options will now appear. We will click on the Page Setup option written in green color.

click on the Page Setup option written in green color

  • A new window titled Page Setup will appear. We will click on the Sheet tab from that window.
  • Then, check the Gridlines option under the Print
  • Finally, click OK.

Insert Gridlines on Worksheet From Print Option in Excel

  • Now, we will see that our Print Preview is showing the preview of the worksheet with the gridlines.

Insert Gridlines on Worksheet From Print Option in Excel

  • If everything is ok, we will click on the Print button like below to print the worksheet.

Insert Gridlines on Worksheet From Print Option in Excel

Read More: How to Adjust Print Settings in Excel (8 Suitable Tricks)


Bonus: Print Headings on Worksheet From Page Layout in Excel

Here is a bonus for you! Like the gridlines, we can also insert the column and row headings in the worksheet while printing it. You have to do the following.

Steps:

  • Now, we will check the Print option under the Headings in the Sheet Options section of the Page Layout.

check the Print option under the Headings

  • Now, if we check the Print Preview, we will see that it is showing the print preview of the worksheet with the rows and columns headings.

print preview of the worksheet


Things to Remember

  • You can press CTRL+P to activate the Print feature of Excel.
  • Checking the Print options for Gridlines and Headings for a specific worksheet will not affect the other worksheets in the same Excel file. You have to follow the above procedures for other worksheets if you want to print them with the gridlines and headings.

Conclusion

In this article, we have learned to print gridlines in Excel. Along with that, we also learn to print rows and columns headings in Excel.  I hope from now on you can print the gridlines and headings in Excel very easily. However, if you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!!


Related Articles

ASM Arman

ASM Arman

Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo