In this article:

How to Print Gridlines in Google Sheets (The Easy Way!)

In this article we will show you how to print gridlines in Google Sheets. Choose to print your spreadsheet with or without lines. Just follow the steps below:

How to Print Gridlines in Google Sheets

For demonstration purposes a sample sheet was created. Click here to access the sheet and follow along at home.

1. Ensure the gridlines are enabled

To print gridlines in Google Sheets we must first ensure they are enabled. From the top toolbar click View followed by Show, from the side menu ensure the Gridlines option has a tick next to it. 

Once this is ticked the gridlines will appear in the sheet.

Google Sheets show print lines

2. Select File > Print to open the print options screen

Click File from the top toolbar followed by Print from the menu displayed. Alternatively you can use the keyboard shortcut Ctrl + P (Windows) or Cmd ⌘ + P (Mac). This will open the print options screen.

If printing a single sheet or a cell selection ensure you have navigated to the target sheet and/or highlighted the target selection prior to opening the print options screen. 

If your aim is to print the current selected sheet or the entire workbook there is no requirement to highlight any data.

How to print gridlines in Google Sheets: Open print options menu

3. Choose the print selection

The print options screen will now appear. In the right hand side of the screen is the print menu, a print preview can be seen on the left.

Google Sheets show print lines‍

Underneath the Print label on the print menu there is a drop down box with the following options:

Current Sheet: Prints only the sheet that is selected when accessing the print options.

Workbook: If you have multiple sheets the option to print the entire workbook will display. Within this option there is a further drop down menu labelled Selection, clicking this will allow you to tick to select specific sheets in the workbook.

By default this will be set to print all sheets in the workbook.

Selected Cells: Prints the cells that were selected earlier (if applicable).

As our example only contains one sheet we only see the options to include the Current sheet or Selected cells. We will choose Current sheet.

How to print gridlines in Google Sheets: Set print selection

4. Choose the paper size and orientation

Choose a paper size that matches the size of paper you are using to print on. A4 (21.0cm x 29.7cm) is the most common type of paper size and is selected by default. 

You can change the paper size by using the drop down menu which offers multiple sizes including the option to set a custom paper size.

We will leave the paper size to the default size of A4 in our example.

How to print empty gridlines in Google Sheets: Set paper size

Next change use the selection buttons to change the page orientation. The two options are Portrait and Landscape, select the layout most preferable to suit your data and requirements.

How to print gridlines in Google Sheets: Set orientation

 

5. Set the scale and margins

In the Scale drop down menu you can set the scale of your content in relation to the page. The options are:

Normal (100%): The content is as originally scaled with no changes

Fit to width: The content is scaled on the width of the page

Fit to height: The content is scaled to the height of the page

Fit to page: The content will be adjusted in size to fit the entirety of the page

Custom: This option allows you to specify the scaling percentage

By default the scale will be set to Normal (100%) which is the option we will choose in our example sheet.

How to print gridlines in Google Sheets: Margins

Choose your margin preference from the drop down menu. Google Sheets gives the options to change the margins to normal, narrow, wide or custom numbers.

How to print empty gridlines in Google Sheets: Margins

6. Apply custom page breaks if applicable 

Google Sheets also offers the ability to add custom page breaks to your prints, this allows you to split your content across multiple pages when printed. To use this function click on  SET CUSTOM PAGE BREAKS. 

This will display a window. You can now drag the split lines to the desired breakpoint and select CONFIRM BREAKS to complete this task. 

How to print gridlines in Google Sheets: Custom page break

7. Choose to show or hide gridlines

Expand the formatting tab in the options menu on the right hand side by clicking the downwards arrow ˅ on the right hand side of the label. 

You will now see the option Show grid lines. If the checkbox is left unchecked the grid lines will not be shown in the print preview on the left hand side and therefore will not be included on the printed content.

How to print Google Sheets without gridlines

If the checkbox is ticked you will see the grid lines appear in the print preview on the left hand side and the gridlines will be shown in the print out.

In our example we will choose to show the grid lines so will ensure the checkbox is checked.

How to print gridlines in Google Sheets

8. Select the page order and alignment

In the formatting area of the print options menu you can select the page order by using the drop down menu.

Where the content appears on the printed page can be set using the alignment drop down options. These can set the content both vertically and horizontally.

We will set the alignment to top left in our demonstration as can be seen below.

Print gridlines in Google Sheets: Alignment options

9. Choose the headers and footers to display

By expanding the headers and footers section of the print options menu you can choose from the various checkboxes which elements to display which include Page numbers, Workbook title, Sheet name, Current date and Current time.

In our example we have checked several elements as can be seen below.

Print gridlines in Google Sheets: Headers and footers

You can enter your own custom header or footer by clicking the EDIT CUSTOM FIELDS label. This will display a screen to enter custom text. Simply click the area and enter your text. Click the confirm button when finished.

Google Sheets show print lines: Custom text in header

10. Click Next followed by Print

At the top right of the print options menu click the NEXT button, your operating systems print dialogue window will appear. Make sure the correct printer is chosen and click print. Your sheet will be printed.

If you have chosen to show the grid lines they will display on the print out.

Google Sheets show print lines: Results

Related Articles:

- Set Print Area

- Print Selected Cells

- How to print

- how to print labels

- print address labels

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started