How to Set Print Area in Google Sheets

This guide provides essential instructions for setting the print area in Google Sheets, a crucial skill for anyone looking to efficiently print specific data without unnecessary clutter. It details two methods: using layout options and selecting specific cells, ensuring users can customize their printouts according to their needs. By following this guide, users can streamline their printing process, saving time and resources while achieving professional-looking results. Whether for presentations, reports, or personal use, mastering these techniques enhances productivity in managing spreadsheets.

21 steps
|
2 minutes

Google Sheets

How to Set the Print Area in Google Sheets Using Layout

Sign in to your Google account and open a [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323)

Make sure the spreadsheet has all the data you need to print.

Click "File" on the menu bar on the top or press [[Ctrl + P]] or [[cmd + P]]

Scroll down the dropdown menu and click “Print”

On the right side of the screen, you will see a panel with options.

Click the arrow next to “Print”.

Select the ”Workbook" option.

Click the "Next" button.

Under "Destination," select printer information or "Print to PDF" to create a PDF.

Click "Print"

How to Set the Print Area in Google Sheets Using Cell Selection

Make sure the spreadsheet has all the data you need to print.

Highlight the cells you wish to print by holding your mouse button down and dragging the cursor or by holding the Ctrl or Cmd key and clicking multiple cells.

Click "File" on the menu bar at the top.

Scroll down the dropdown menu and click “Print”

You will see a panel with options on the right side of the screen.

Click the arrow next to “Print”.

Click the “Selected cells” option.

Click "Next"

In the printer menu, select your printer or "Print to PDF"

Click "Print"