#Print selection google sheets how to
#Print selection google sheets windows 10

You can also print using the print icon, which is in the toolbar, or using the keyboard shortcut ctrl +P How to Set the Print Area to Print the Whole Workbook You can also add and print labels on your Google Sheet.

#Print selection google sheets windows 10

Usually, this just involves selecting the desired printer and hitting the “Print” button, but you may need to change things like color settings here.įor example, on this Windows 10 system, I’ve selected to print the spreadsheet from the “HP ENVY Photo 7100” destination.Īfter following these steps, you’ll soon have a physical printed copy of your spreadsheet. Hit “Next” and use your operating system’s print management program to send it to the printer.This is what the preview looks like in the example: Check the preview to make sure you’ve highlighted the correct range.The print preview window will change the print area from the entire spreadsheet to just what you selected in a previous step. Click on the “Print Settings” menu option that says “Current Sheet”.You can do this by clicking the File menu then Print option (first image), clicking the printer icon from the sub-menu (second image), or pressing the “Ctrl+P”(“CMD+P” on Mac) keyboard shortcut. In the example below, I’ve selected the first 10 lines and the header row for a range of A1:F11. The following steps explain how to set the print area in Sheets. These are the first 20 references of the spreadsheet: We’ll be using a spreadsheet with user information for this tutorial. The important takeaway from configuring the Google Sheet print area is you need to do it every time you print. If you’re trying to set the print areas in Google Sheets, you probably are trying to avoid using excessive amounts of paper to show a narrowed information selection. How to Set Print Area in Google Sheets for a Range How Do I Set the Print Area Based on Cell Value?.How Do I Make Google Sheets Not Print Lines?.How Do I Print Only a Selected Area in Google Sheets?.Can You Set Print Area on Google Sheets?.

How to print a Google Sheet from a mobile app.How to Set Custom Page Breaks in Google Sheets.How to Adjust the Scale and Margin to Fit.How to Print the Header Row(s) on Each Page.How to Adjust Google Sheet Print Settings.How to Set the Print Area to Print Everything on the Sheet.How to Set the Print Area to Print the Whole Workbook.How to Set Print Area in Google Sheets for a Range.So, how do you set the print area in Google Sheets? The following processes explain how to set the print area in Google Sheets and configure how the print area displays on paper. Instead, you must define the print area each time you print in Google Sheets. However, Google Sheets does not include a “permanent” print area setting. The Google Sheets printing process is relatively straightforward. In Excel, you define a print area under the layout menu before printing content as a permanent setting, whereas Google Sheets manages the print area each time you print. These two spreadsheet tools handle this task in very different ways. If you’re coming over from Microsoft Excel, you might find how Google Sheets handles setting the print area confusing.

Setting the print area in Google Sheets is an important part of transferring spreadsheet information in an office.Īn incorrectly configured Google Sheets print area can result in poorly located page breaks and wasted paper. How to Set Print Area in Google Sheets – Video tutorial: