2 Different Methods to Print Excel Sheet with Gridlines

  • Print gridlines using the “Page Layout” tab.Print gridlines using the “Page Setup” section.

Now, let us discuss each of the methods in detail:

  • But, first, we must select the “View” section from the “Gridlines tab” in the “Page Layout.” Then, we need to choose the “Print” box available in the “Gridlines” tab to print it. Finally, we can go to the “Print” section and click on the “Print Preview” to see the gridlines.

#1 – Using Page Layout Tab

Below is the data we want to print. It has no borders.

  • Step 1: Go to “Page Layout > Sheet Options > Gridlines > and check the box > “View” and “Print.”

  • Step 2: We can only VIEW the gridlines here. If we want to print, we need to tick the PRINT checkbox. It would print gridlines for you. For example, look at the below print preview image.

#2 – Using the Page Set Up Tab

Below is the data we want to print. It has no borders. You can also print an Excel sheet with gridlines under the “Page Setup” option.

  • Step 1: First, go to the “PAGE LAYOUT.” Under this, click on the little expand icon.

  • Step 2: Go to the “SHEET” tab under the dialog box below.

  • Step 3: Under the “SHEET” tab, we have a “PRINT” section. Select the “Gridlines” check box.

  • Step 4:  After you have selected the option “Gridlines,” at the end of this dialog box, click on “Print Preview” in excelClick On Print Preview In ExcelPrint preview in Excel is a tool used to represent the print output of the current page in the excel to see if any adjustments need to be made in the final production. Print preview only displays the document on the screen, and it does not print.read more.

  • Step 5: It will show the preview of your print with gridlines.

How to Print Gridlines with Different Colors?

  • Step 1: Go to the “File” option, then select “Options.”

  • Step 2: Under “Options,” go to “Advanced.”

  • Step 3: After selecting “Advanced,” scroll down, and choose “Display options for this worksheet.”

  • Step 4: In this section, at the bottom, we have an option called “Gridlines” color.

  • Step 5: Select the color as per your requirement.

  • Step 6: Now, we have a pink grid line.

Things to Remember

  • The ALT + W + V +G is the shortcut key to show and hide gridlines in Excel.Whatever changes you make for the gridline apply only to the current worksheet. For each sheet, you have to do it separately.Removing and using gridlines is applicable for the whole worksheet, not the worksheet’s portion.We can remove the gridline in one shot by holding the control key, selecting all the worksheets, and clicking on remove gridlines.Excel cannot print the gridlines without your insistence.

This article is a guide to Print Gridlines in Excel. Here, along with examples, we discuss how to print gridlines using the top three ways (Page Layout, Page Setup”Page”Toread more, and a different color). You may also look at these useful functions in Excel: –

  • Print in VBAPrint In VBAPrint in VBA is similar to print in Excel. Before using the print command, one must first configure it in VBA. The command prints or writes the data into another file.read moreGridlines in ExcelGridlines In ExcelGridlines are little lines made of dots to divide cells from each other in a worksheet. The gridlines have slight faint invisibility; you can find it in the page layout tab. This option has a checkbox; for activating the gridlines, you can tick on it and untick if you wish to deactivate gridlines.read morePrint Comments in ExcelSplit Panes in ExcelExcel Group SumExcel Group SumExcel group by sum is a method through which the user can determine the individual sum of the target data groups. Here, a combination of If and SumIf Functions is applied to find the aggregate of each group of values.read more