How to Set Print Area in Google Sheets

Are you tired of printing out endless sheets of paper with irrelevant data on it? Do you want to save time and reduce paper waste? Well, I've got great news for you! With Google Sheets, you can control exactly what gets printed and what doesn't. In this article, I'll show you exactly how to set the print area in Google Sheets.

Step 1. Select the desired range

The first step in setting the print area in Google Sheets is to select the range of cells that you want to print. This may include a range of rows, columns, or a combination of both. To select the desired range, click and drag your cursor over the cells that you want to include.

Pro tip: use keyboard shortcuts to speed up the selection process. On a PC, use the Shift key while clicking and dragging to select multiple cells. On a Mac, use the Command key.

Step 2. Open the Print Area menu

Once you have selected the desired range, it's time to open the Print Area menu. To do this, click on the File menu at the top of the page, and then select the Print area option from the dropdown menu.

A pop-up menu will appear with a few options to choose from. Select "Set print area" to finalize your selection.

Step 3. Preview your print area

Now that you've set the print area, it's a good idea to preview what it will look like before printing. To do this, click on the File menu and select Print from the dropdown menu.

A preview window will appear, showing you exactly what will be printed. You can use this window to make any necessary adjustments, such as adjusting margins or orientation.

Step 4. Print your spreadsheet

Once you're satisfied with the preview, it's time to print your spreadsheet. To do this, click on the Print button in the top left corner of the preview window.

Pro tip: save paper and ink by printing double-sided. To do this, select the "Two-sided" option under the "Settings" menu in the Print window.


Setting the print area in Google Sheets is a simple and effective way to save time and reduce paper waste. By controlling exactly what gets printed, you can focus on what's important and eliminate unnecessary distractions. Give it a try and see how it can improve your workflow!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.