How to Print Gridlines in Google Sheets ( Easy Guide )

In this tutorial, we will learn How to Print Gridlines in Google Sheets.

To Print Gridlines in Google Sheets, select the cells with gridlines on your Google Sheet. Go to “File” Menu ->Print and change the Print settings from Current to Selected Sheet . Ensure the “Show guidelines” option is checked under Formatting settings.

Here are the steps to print gridlines in Google Sheets.

  • Open your Google Sheets where you need to Print Gridlines.
  • Select the Range of Cells that you need to Print with Gridlines in Google Sheet
  • Click on the File menu and select “Print” from the drop-down menu
  • Change the Print option from “Current Sheet ” to “Selected cells”
  • Expand the formatting option and ensure that the “Show grid lines” option is Selected
  • Click on the “Next” option on the top right of Print Settings

Let’s go through the above steps in detail with step by steps screenshots.

How to Print Gridlines in Google Sheets: Step by Step Guide

Enclosed are the steps to Print Gridlines in Google Sheets

Step 1: Open your Google Sheets where you need to Print Gridlines.

Step 2: Select the Range of Cells that you need to Print with Gridlines in Google Sheet

How to Print Gridlines in Google Sheets

Step 3: Click on the File menu and select “Print” from the drop-down menu

Step 4: Change the Print option from “Current Sheet ” to “Selected cells”

  • Once you click on the Print option under the File menu, the Print Settings screen will pop up.
  • On the right-hand side of your print settings, under Print options change from “Current Sheet” to “Selected cells” by clicking on the down arrow.

Step 5: Expand the formatting option and ensure that the “Show grid lines” option is Selected

Step 6: Click on the “Next” option on the top right of Print Settings

Now you will be able to see the Print Preview along with Gridlines.

You can either save it to Pdf or change the destination and specify your local printer to print the Google Sheet.

We hope this tutorial on How to Print Gridlines in Google Sheets was helpful.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )