Ever needed to print just a specific part of your Google Spreadsheet instead of the entire document? Printing only the selected area can save ink, time, and make your spreadsheets more readable on paper. Here's a step-by-step guide on how to achieve this.
Before we dive into the steps, ensure that you're using a Google account and that the Google Spreadsheet you want to print is open.
Selecting the Area to Print
First, identify the range or area you want to print. This could be a single cell, a specific row or column, or a defined range like A1:C10.
To select a single cell or a range, click and drag your mouse over the desired cells. For rows or columns, click on the header (e.g., A, 1, or 2) to select the entire row or column.
Print the Range using the Print Dialog Box
Once you've selected the area, click on 'File' in the menu bar, then 'Print'. A print dialog box will appear. At the bottom of this dialog box, you'll see 'Range' with two empty fields separated by a colon (:).
In the first field, type the top-left cell of your selected range (e.g., A for the first column, 1 for the first row). In the second field, type the bottom-right cell of your selected range (e.g., C for the third column, 10 for the tenth row). Make sure to leave no space between the cell references and the colon. For example, if you want to print A1 to C5, you would type 'A1:C5'.
Print the Range using the Print Preview Option
Another way to print a specific range is via the Print Preview option. After selecting the range, click on 'File' then 'Print'. In the print dialog box, click on 'Print preview'. On the print preview screen, click on the three vertical dots at the top right, and select 'Print area'. In the pop-up, enter your range (e.g., A1:C10) and click 'OK'.
The selected range will be highlighted on the screen. Click 'Save as PDF', name your file, and choose the location. Google will create a PDF file of your selected range, which you can then print or share.
Previewing and Adjusting Print Settings
Before you hit that print button, ensure you've previewed and adjusted your print settings. The print dialog box allows you to change the paper size, orientation, and number of copies. You can also choose between a color or black and white print, and whether to print gridlines or not.
For better control over how your spreadsheet prints, consider using Google's 'Print layout' feature. This feature allows you to fit your data to a specific number of pages, set headers and footers, and adjust the margins.
Once you're satisfied with your print settings, click 'Print' to send your selected range to the printer. With these steps, you'll never again need to print unnecessary pages from your Google Spreadsheet.