iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Google Sheets does not have Excel’s Page Layout → Print Area → Set Print Area command. Instead, you define the area when you print by selecting the cells and choosing Selected cells in the print settings.
This is a computer/web workflow. The key detail is that selecting cells alone is not enough: Google Sheets may still open the print screen with Current sheet selected, which would print the entire tab.
How to set a print area in Google Sheets
- Open the spreadsheet at sheets.google.com on a computer.
- Select the cells you want to print. For example, select
A1:H35by dragging across the range, or click the name box above the grid and enter the range. - Click File → Print.
- In the print-settings screen, open the print-scope dropdown. It may initially say Current sheet.
- Choose Selected cells.
- Check the preview, then click Next.
The selected range is now the content sent to the print process. In Chrome, a print window opens; click Print. In Firefox or Safari, Google Sheets downloads a PDF, which you can open and print using File → Print in the PDF viewer.
Recommended Free Tools
What the print-scope options mean
| Option | What it prints |
|---|---|
| Workbook | Every tab in the spreadsheet. |
| Current sheet | The tab that was active before you opened the print screen. |
| Selected cells | Only the range selected before opening the print screen. |
If you selected a range but the preview contains the whole tab, return to the print-scope dropdown and change Current sheet to Selected cells.
#1 Best Overall
- PERFECT FOR BASIC PRINTING NEEDS – Print everyday color documents like to-do lists, letters, financial documents and recipes
- KEY FEATURES – Color print, copy, scan, and a 60-sheet input tray, plus mobile and wireless printing
- OPTIMIZE PRINT FORMATTING WITH HP AI – Print web pages and emails with precision—no wasted pages or awkward layouts; HP AI easily removes unwanted content, so your prints are just the way you want
- ICON LCD – Print your basic documents with ease from the intuitive control panel
- PRINT SPEED – Up to 7.5 ppm black, 5.5 ppm color
Print one complete sheet tab
To print an entire tab rather than a selected range:
- Click the tab you want to print.
- Click File → Print.
- Set the print scope to Current sheet.
- Click Next, then complete printing in the browser or PDF viewer.
This prints the active sheet only, not every tab in the spreadsheet.
Print every tab in a spreadsheet
- Click File → Print.
- Choose Workbook from the print-scope dropdown.
- Click Next.
Use this option when the file contains several tabs that all need to be included.
Make a selected range fit the page
After choosing Selected cells, use the print settings to control how the range is laid out on paper or in the PDF.
Change orientation
Under Orientation, choose:
- Portrait for a taller, narrower layout.
- Landscape for tables with many columns.
Landscape is often the better choice for a range such as A1:N30, because it gives wide columns more room.
Choose paper size
Open Paper size and choose the required size. If the available sizes do not match the paper or document format, choose Custom size and enter the height and width.
Rank #2
- Affordable Versatility - A budget-friendly all-in-one printer perfect for both home users and hybrid workers, offering exceptional value
- Crisp, Vibrant Prints - Experience impressive print quality for both documents and photos, thanks to its 2-cartridge hybrid ink system that delivers sharp text and vivid colors
- Effortless Setup & Use - Get started quickly with easy setup for your smartphone or computer, so you can print, scan, and copy without delay
- Reliable Wireless Connectivity - Enjoy stable and consistent connections with dual-band Wi-Fi (2.4GHz or 5GHz), ensuring smooth printing from anywhere in your home or office
- Scan & Copy Handling - Utilize the device’s integrated scanner for efficient scanning and copying operations
Adjust margins
Under Margins, click Normal and choose another margin type. To enter exact values, choose Custom numbers and enter the margin measurements.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Set page breaks for a multi-page printout
If the selected range spreads across several pages, you can decide where each page ends:
- Click File → Print.
- Click Set custom page breaks.
- Drag the page-break lines to reposition them. Each rectangle represents one printed page.
- To remove a break, point to its line and click Remove.
- Click Confirm breaks.
Use page breaks when a row would otherwise be split awkwardly or when a logical section should begin on a new page.
Repeat headings on every printed page
For a long table, repeat the heading row so later pages remain understandable:
- Freeze the heading row first. Use View → Freeze, then choose the appropriate number of rows.
- Open File → Print.
- Open Headers & footers.
- Select Repeat frozen rows.
- Click Confirm, if shown, and review the preview.
You can also freeze a column and select Repeat frozen columns when a left-side identifier needs to appear on every printed page.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Add headers and footers
In the print settings, open Headers & footers and select the information to include. To change the placement or formatting, choose Edit custom fields, make the changes, and click Confirm.
Rank #3
- Affordable Versatility - A budget-friendly all-in-one printer perfect for both home users and hybrid workers, offering exceptional value
- Crisp, Vibrant Prints - Experience impressive print quality for both documents and photos, thanks to its 2-cartridge hybrid ink system that delivers sharp text and vivid colors
- Effortless Setup & Use - Get started quickly with easy setup for your smartphone or computer, so you can print, scan, and copy without delay
- Reliable Wireless Connectivity - Enjoy stable and consistent connections with dual-band Wi-Fi (2.4GHz or 5GHz), ensuring smooth printing from anywhere in your home or office
- Scan & Copy Handling - Utilize the device’s integrated scanner for efficient scanning and copying operations
This is useful for adding details such as page numbers or other available header and footer information without changing the cells in the sheet.
Does Google Sheets save a permanent print area?
Google’s current print workflow does not document a persistent print-area setting, a Set Print Area command, or a Clear Print Area command. The print scope is chosen in the print screen as Workbook, Current sheet, or Selected cells.
Therefore, if you need to print the same range again, select that range before opening File → Print, then explicitly choose Selected cells again. There is no standard formula, Apps Script command, or command-line syntax required for this normal workflow.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Common mistakes and fixes
| Problem | Fix |
|---|---|
| The whole tab appears in the preview. | Change the print scope from Current sheet to Selected cells. |
| The wrong tab prints. | Return to the sheet, click the correct tab, select the range again, and reopen File → Print. |
| The table is cut off horizontally. | Choose Landscape, use a larger paper size, or reduce the margins. |
| Column headings appear only on the first page. | Freeze the heading row, then enable Repeat frozen rows under Headers & footers. |
| The output has unexpected page divisions. | Open Set custom page breaks and move or remove the break lines. |
| There is no browser print dialog after clicking Next. | Check whether Google Sheets downloaded a PDF. In Firefox and Safari, print the downloaded PDF using the PDF viewer’s File → Print command. |
Google Sheets versus Excel
Instructions that say Page Layout → Print Area → Set Print Area apply to Microsoft Excel, not Google Sheets. Excel supports a named, persistent print-area feature; Google Sheets’ documented method is to select cells and choose Selected cells when printing.
That distinction explains why searching Google Sheets for Clear Print Area or looking for a Page Layout tab does not produce the expected command.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.FAQ
Can I set a print area in Google Sheets like I can in Excel?
Not through a documented permanent print-area command. Select the desired cells, choose File → Print, and set the print scope to Selected cells.
Rank #4
- AFFORDABLE ALL-IN-ONE FOR HOME AND HOME OFFICE: Print, copy, and scan on one compact wireless printer designed for everyday home office printing, schoolwork, documents, and reports. Produce beautiful prints for results that stand out.
- EASY TO USE WITH CLOUD APP CONNECTIONS: Print from and scan to popular Cloud apps(2), including Google Drive, Dropbox, Box, OneDrive, and more from the simple-to-use 1.8” color display on your printer.
- FULL-SIZE FEATURES IN A COMPACT DESIGN: This printer includes automatic duplex (2-sided) printing, a 20-sheet single-sided Automatic Document Feeder (ADF)(3), and a 150-sheet paper tray(3). Engineered to print at fast speeds of up to 16 pages per minute (ppm) in black and up to 9 ppm in color(4).
- MULTIPLE CONNECTION OPTIONS: Connect your way. Interface with your printer on your wireless network or via USB.
- MOBILE PRINTING MADE EASY: Go mobile with the Brother Mobile Connect app(5) that delivers easy onscreen menu navigation for printing, copying, scanning, and device management from your mobile device. Monitor your ink usage with Page Gauge to help ensure you don’t run out(6).
Why does Google Sheets print the whole sheet after I select cells?
The print screen may default to Current sheet. Selecting cells does not automatically change that option. Open the print-scope dropdown and choose Selected cells.
Free tools Windows power users keep installed
One-click scans. No signup required.
How do I print just one tab in Google Sheets?
Activate the tab, choose File → Print, and select Current sheet.
How do I print all tabs?
Choose File → Print and set the print scope to Workbook.
Can I print a selected range from the Google Sheets mobile app?
Google’s documented selected-cell print-area workflow is for Google Sheets on a computer/web browser. The help page provides separate mobile instructions, so use the web version when you need this exact print-scope process.
How do I remove a print area in Google Sheets?
There is no documented Clear Print Area command because Google Sheets does not document a persistent print-area object. For the next print job, choose Current sheet, Workbook, or a different Selected cells range.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Clear out junk files and repair common Windows errors3Fix the driver behind crashes, sound loss and screen glitchesThe Bottom Line
To print a defined area in Google Sheets, select the cells, go to File → Print, change the scope to Selected cells, and click Next. Google Sheets does not use Excel’s persistent Set Print Area feature, so make the selection again whenever you need to print that range.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
