Setting the Print Area in Google Sheets Main Image

When you are printing off a lot of Sheets, it is good to conserve as much paper as possible. You can do so by setting the print area.

Follow these steps on how to not only conserve  paper and ink, but also make your physical spreadsheets look their best for your next meeting or presentation.

Step #1: Highlight the Range

Setting the Print Area in Google Sheets 1

First, you will want to highlight everything that you wish to appear on the printed copy. In this case, I want to print a neat copy of a student’s class schedule for the coming semester.

Step #2: Select “Print”

Setting the Print Area in Google Sheets 2

Next, you will hit the Print button, located on the top-left corner of Google Sheets. It is the button that looks like a printer.

Alternatively, you could use the keyboard shortcuts:

CTRL + P for PC

or

COMMAND + P for Mac

Step #3: Printer Menu

Setting the Print Area in Google Sheets 3

As you can see, the current version of the printed copy will have a bunch of ugly gridlines around the actually important stuff. To fix this, open the Print drop-down menu and select the Selected Cells () option.

That will change the display to only show the range that we highlighted in step 1.

Setting the Print Area in Google Sheets 4

From here, you can add any final margin edits to your sheet and print it off by selecting Next.

And there you have it; that is how you crop your data tables and graphs to better in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!