In this article:

How to Print From Google Sheets in 10 Simple Steps

In this article we will show you how to print from Google Sheets both with and without gridlines.

How to Print Google Sheets

Google Sheets offers several options when printing.

For the purpose of this demonstration an example workbook has been created to show how to use the various options available when printing in Google Sheets. Click here to access this and follow along at home.

1. Click File followed by Print

In your selected sheet access the print menu by clicking on File followed by Print. This can also be accessed by using the keyboard shortcut Ctrl + P (Windows) or Cmd + P (Mac).

How to print in Google Sheets: Accessing the print menu

Note that if you are aiming to print a specific selection of cells you must ensure this selection is highlighted at this point. 

If you want to print the current selected sheet or the entire workbook there is no requirement to select any data.

How to print in Google Sheets: Highlight data

2. Choose the print selection

The print options screen will now appear. In the left hand side of the screen is a preview of the content to be printed. To the right is the print menu.

Print google sheets: Options screen

You can select the selection to be included in the print. To do this click the drop down menu underneath the Print label on the print menu. This will give the following options:

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

Workbook: Shows the option to print all of the workbook or just specific sheets. When this option is selected a further drop down menu will appear labelled Selection, clicking this will allow you to tick to select the 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).

In our example we will choose to print the current sheet.

How to print Google Sheets: Highlight data

3. Choose the paper size

This option can be changed via the drop down menu labelled Paper size. By default this is set to A4 (21.0cm x 29.7cm) however the drop down menu offers a variety of different sizes including the option to define a custom paper size.

For our example we will ensure the A4 (21.0cm x 29.7cm) option is selected as this is the most standard. 

How to print in Google Sheets: Highlight data

4. Choose the page orientation and scale

There are two page orientation options to choose from: Landscape and Portrait. Choose the option that best suits your data or requirements.

The Scale will be set to Normal (100%) by default, by selecting the drop down menu underneath the Scale label on the print menu you can change this to Fit to width, fit to height, fit to page or even to a custom percentage.

We will leave this set to Normal (100%) for our example.

How to print from Google Sheets: Page orientation and scale

5. Choose the Margins

Underneath the Margins label the drop down menu offers the choice to change the Margins of the document. You can set the margins to various options including Normal, Narrow, Wide or even specify custom numbers.

This feature is especially useful as it gives you full control over the margins of all four sides.

How to print from Google Sheets: Margins

6. Set Custom Page Breaks if needed

Clicking on SET CUSTOM PAGE BREAKS will display a window that gives the option to split your data across multiple pages on a custom basis by dragging the split lines to the desired breakpoint and selecting CONFIRM BREAKS. 

Custom page breaks

7. Show/Hide grid lines

In the Formatting section of the print options menu there is a checkbox that is labelled Show grid lines. If this box is checked the grid lines will display in the print. For our example we will choose not to show grid lines and therefore will leave the checkbox unchecked.

Google Sheets print: Show grid lines‍

8. Set the page position of content

The content can be aligned to various parts of the page. To do this use the drop down menus labelled Alignment. Here we can set the horizontal and vertical alignment to position the content in various parts of the page. In our example we will change this to be top-left.

google sheets print: Set the page position

9. Choose which headers and footers to display

Under the Headers and footers label you will see several checkboxes. If checked these will display on your printed results. 

In the example we will choose to display the Page numbers, Workbook title, sheet name and the current time. As can be seen this is reflected in the preview.

print google sheets: Headers and footers

There is also an option to set custom fields in this section allowing custom text to be inserted into the header or footer areas. Simply enter your custom text in the available area and select confirm in the top right hand corner of the screen.

How to print in Google Sheets: Headers and footers

10. Click next then Print

Above the print options menu click the next button, this will open your operating systems print window. Ensure the correct printer is selected and click print. Your document will be printed.

How to print from Google Sheets: Print

Related Articles:

- How to print selected cells

- Print gridlines in Google Sheets

- How to set print area

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

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
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started