Google Sheets Print Area: Set and Print a Cell Range

Google Sheets does not have a permanent, Excel-style “Set Print Area” command. To print just part of a sheet, select the cells, choose File > Print, and set the print range to Selected cells in the print settings.

What “print area” means in Google Sheets

A print area is the portion of a worksheet included when you print it. In desktop Excel, you can define a print area for a sheet and keep that setting with the workbook. Google Sheets works differently: you choose what to print in its print settings, and a cell selection can be sent to print as a one-time range. There is no matching command that permanently stores a print area for a sheet in the same way.

This distinction matters if you print the same report regularly. Selecting a range tells Sheets what to include in the current print job; it does not create a fixed boundary that automatically governs every later print. If you reopen the file another day, check the print preview and selected range rather than assuming the previous selection is still in effect.

Sheets does offer controls for how the printed pages look. You can choose paper size and orientation, set margins, scale the content, and adjust page breaks. Those controls help fit the selected cells onto paper, but they do not replace choosing which cells to print.

Print a selected range of cells

Use this method when you want to print a table, summary, or other part of a larger sheet without printing all the surrounding cells. These steps are for Google Sheets in a web browser:

Open the spreadsheet and select the cells you want to print. Drag across the range, or click the first cell and Shift-click the last cell.
Choose File > Print. You can also use the browser’s print command, but File > Print is preferable because it opens Sheets’ print settings first.
In the print settings panel, open the Print dropdown and choose Selected cells.
Check the preview. It should show the chosen range rather than the entire current sheet.
Adjust layout and page settings if needed, then click Next to continue to the browser or system print dialog.
Choose a printer or a PDF destination in that dialog and confirm the print job.

Some controls can look different as Google updates its interface or depending on the browser, but the key check is the preview: confirm that it contains the intended cells before sending the job. If the print dropdown does not offer the range you expect, return to the sheet, make the selection again, and reopen File > Print.

Fit the selected cells onto pages

A correct range can still produce an awkward printout if the columns spill onto extra pages or the text becomes too small. In the print settings, review the options for paper size, page orientation, scale, and margins. The preview updates to show the effect of many of these choices.

Landscape orientation can help with wide tables, while portrait is often suitable for narrow lists.
Scale controls how the content fits. Options can include fitting to width, fitting to height, fitting to the page, or using a normal scale. Fitting to one page may shrink text substantially on a large range.
Margins affect the printable space. Narrower margins may fit more content, but the printer may have physical limits near the paper edges.
Paper size should match the paper loaded in the printer or the size you intend to use for a PDF.

For example, a six-column monthly expense summary may be easier to read in landscape orientation and scaled to fit the width. That does not necessarily mean it should fit on one page in both directions: allowing several pages vertically can preserve readable text. Use the preview to judge the trade-off rather than relying on a scale setting alone.

Control where pages break

When a selected range spans multiple pages, Sheets may divide it at an inconvenient point, such as between a category heading and its rows. In the print settings, choose Set custom page breaks when that option is available. The preview lets you move page-break lines so that sections begin or end at more useful places; confirm the breaks when you are satisfied.

Custom page breaks control pagination, not the print area itself. They cannot make unselected cells part of the job, and they do not turn a selection into a saved print boundary. If the preview has the wrong content, first correct the print-range choice. If it has the right content but splits it poorly, adjust page breaks or scaling.

For a report with a heading row, consider whether the heading should appear on each printed page. Sheets’ print settings may provide header and footer options, and frozen rows can be relevant to repeating rows in print when that option is offered. Check the resulting pages in preview: a frozen row on screen is not, by itself, proof that it will repeat on paper.

Print the same range repeatedly

Because Sheets does not provide a persistent Excel-style print area, a recurring task needs a reliable routine. Keep a note of the range to select, such as A1:G28, and verify the print preview each time. A dedicated report tab can also help: arrange the information intended for printing together there, so you have less risk of including unrelated cells.

If the report changes size, update the selection to include new rows or columns. For instance, if a monthly report grows from 28 rows to 34, selecting the old range may omit the last six rows even though the sheet displays them. Check both the first and last items in the preview before printing.

Another practical option is to download or print a PDF after checking the layout, then keep that dated output as a record of what was actually produced. A PDF is a snapshot, not a live print area: later edits to the spreadsheet will not update an already saved PDF.

Common reasons the printout looks wrong

When a printout includes too much, too little, or poorly arranged content, the cause is often a mismatch between the selected cells and the print settings. Work through these checks:

The whole sheet appears: Check the Print dropdown and choose Selected cells rather than Current sheet or Workbook.
Rows or columns are missing: Return to the grid and select a larger range, then reopen print settings. Check for a clipped selection at the edge of the visible sheet.
The text is tiny: The range may be forced onto one page. Try fitting to width instead, changing orientation, or allowing more pages.
A table is split awkwardly: Use custom page breaks or adjust the range and scaling. Review every page in the preview.
Blank pages appear: Check whether the selected range contains extra blank rows or columns, and inspect the page breaks and scale.
The printout differs from the preview: Confirm the paper size and printer settings in the browser or system dialog. Printer margins and available paper can affect the final result.

Also check whether the range contains hidden rows or columns, filtered data, or cells with formatting far beyond the visible table. What appears on paper can depend on the selected range and sheet state, so the preview is the most useful place to verify the final output. If you need only the rows currently visible after filtering, inspect the preview carefully rather than assuming a filter automatically defines a permanent print area.

Google Sheets and Excel handle print areas differently

In Microsoft Excel for Microsoft 365 on Windows, you can select cells and use Page Layout > Print Area > Set Print Area. Excel stores that print-area setting with the worksheet, and the related menu includes an option to clear it. Excel also has a print selection option for printing a range without setting a lasting print area.

Google Sheets’ Selected cells choice is most like printing a one-off selection in Excel, not like saving an Excel print area. If someone says “Google Excel,” they may mean either product: Google’s spreadsheet application is Google Sheets, while Excel is Microsoft’s application. The steps above are specifically for Sheets in a browser. Excel for the web and the Excel desktop app have their own print controls and should not be assumed to use Sheets’ menus.

Frequently Asked Questions

Can I save a print area in Google Sheets?

Google Sheets does not offer the same persistent, worksheet-level print area feature as desktop Excel. Select the cells and choose Selected cells for the print job, then check the preview. For repeat jobs, use a dedicated print-friendly tab or keep a note of the range.

Where is Set Print Area in Google Sheets?

There is no Set Print Area command in Google Sheets. Select the cells, choose File > Print, and choose Selected cells in the print settings panel.

Can I print only one page in Google Sheets?

Yes, if the chosen range can fit legibly on one page. Select the range, open the print settings, and choose a fitting scale option if available. A very large range may become hard to read when forced onto one page, so review the preview before printing.

How do I print a selected range as a PDF?

Select the cells and choose File > Print, then set the print range to Selected cells. Click Next and choose a PDF destination in the browser or system print dialog, if offered. Confirm the preview and destination before saving.

Why does Google Sheets print the entire sheet instead of my selection?

The print range may be set to Current sheet or Workbook instead of Selected cells, or the cells may not have been selected when you opened print settings. Select the range again, reopen File > Print, choose Selected cells, and verify the preview.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.