How to set a print area in Google Sheets, so you can print selected cells or sheets

Business Insider Lifestyle 1 month ago

You can change the print area of Sheets in one of two ways — by printing only certain cells, or by changing the layout on the page. 

Here's how to do both.

How to print selected cells in Google Sheets

1. Open the Sheets document you wish to print.

2. Highlight the cells you want to print.

3. Hit Ctrl + P on a PC, or Command + P on a Mac, or go to File, then select Print at the very bottom of the list. 

4. In Print options, choose "selected cells."

5. This will only print the highlighted region of the current sheet. Highlighting cells across sheets will not group them together.

How to change the print layout in Google Sheets

1. You can use the same option as above to choose to print only one sheet, or all sheets in the document. To print all sheets in a document, select "workbook" from the print options.

2. If you're having trouble printing on one page, then you can adjust the Margins to "Narrow," or select "Fit to page" under scale.

If that doesn't work, then you can adjust the scale more precisely by setting Scale to "Custom number" and entering the preferred scale as a percentage number. Larger numbers make the sheet or cell bigger on the page and smaller numbers take up less space on the page.

Source link
Read also:
Business Insider › Lifestyle › 1 week ago
You can lock cells in Excel, as well as lock entire sheets. While Microsoft Excel sheets can be a great way to collaborate and share data, sometimes you don't want others to be able to change certain bits of data. You can also lock cells to not allow...
Business Insider › Lifestyle › 9 hours ago
You can add a drop-down list in Google Sheets to better organize data within your spreadsheet. To add a drop-down list, you'll have to use the Data Validation function in Google Sheets. Here's how to add a drop-down list in Google Sheets, from either a...
New York Post › 1 month ago
Still sleeping on cotton sheets? It’s time to get bamboo sheets on your radar. Bamboo sheets have many benefits. For one, they tend to be the softest and silkiest sheets out there. They also are stronger than other sheets and less prone to ripping...
New York Post › 2 weeks ago
"People have sheets," attorney John Meringolo said of the 17 bed sheets found wadded under Christopher Londonio's bunk in his eighth-floor cell of the Metropolitan Detention Center in 2017. "I submit to you, bed sheets in his room, that's not gonna cut...
Business Insider › Lifestyle › 1 month ago
You can add tasks to a Google Calendar at any time for optimal organization. Google Tasks allows you to create to-do lists, which you can then easily sync with your Google Calendar. Here's how to add tasks to a Google Calendar on a computer or mobile...
Business Insider › Lifestyle › 1 week ago
You can print a shipping label on eBay to send out products that you've sold. It's easy to print a shipping label to mail your item through USPS, as you will just have to put it in your mailbox or drop it at the post office. You can also print FedEx...
Business Insider › Lifestyle › 1 month ago
You can easily delete any Google Groups that were used for a temporary project or just to free up page space. You can delete a Google Group in a few simple steps using your Google profile. Visit Business Insider's homepage for more stories. Google...
Business Insider › Lifestyle › 0 month ago
Few would deny that at the end of a long, hard day, sliding into a comfortable bed outfitted with soft, smooth sheets that pamper your skin is one of life's greatest pleasures. After reviewing dozens of contenders for the best sheets, our top pick is...
Business Insider › Lifestyle › 1 day ago
You can avoid highways on Google Maps for your directions if you wish to avoid traffic or take an alternate route. It's easy to set this preference on Google Maps, whether you're using the website or mobile app. Here's how to set up your Google Maps to...
Business Insider › Lifestyle › 0 month ago
If you don't know your Google password, it's easy to recover your account and reset your password. You can also change your Google password at any time, although you'll need to know your current password to do it. It's a good idea to change your Google...
Sign In

Sign in to follow sources and tags you love, and get personalized stories.

Continue with Google