Buy Now
Set-Print-Area-in-Google-Sheets

How to Set Print Area in Google Sheets

Aug 25, 2022

Google Sheets is a fantastic spreadsheet application and a great alternative to Microsoft Excel. If used correctly, it can make data analysis quick and easy. One of the key features you need to understand is how to set the print area for your sheets.

By default, Google Sheets will print the entire spreadsheet, but that can be a nightmare if you do it by mistake!

This article will show you how to set the print area and only print the area you want to.

How to Set the Print Area in Google Sheets on a PC

PCs have plenty of advantages over other options with regards to Google Sheets.

Firstly, a PC offers you a larger screen to input data into, making it quick and easy to use various Google Sheets commands.

However, the best thing is that there are many more printing options on PC than on mobile. You have the power to print an entire workbook, a current sheet, or just a couple of cells.

Setting the Current Sheet or Workbook as the Print Area

If you would rather print everything on your worksheet, follow these steps:

  • Open your worksheet.

  • Select the print button from the top left-hand corner of your menu bar. This action will open the print settings window, providing a preview of your sheet.

  • From the top right-hand corner of your print settings window, you will notice a greyed-out print button and a down arrow alongside it. Select that arrow and choose Current Sheet.

  • Select Next.

  • From here, a new window will show up, offering you the chance to change your print area and how many copies you print.

  • Once you are happy with your customized area, select Print.

Setting Selected Cells as the Print Area

There might be times when you want to print one certain part of your worksheet. Here's how to do this.

  1. Open up the worksheet you want to print.

  2. Choose the cells you want to print.

  3. Select the printer icon button located in the top left-hand corner of the menu bar.

  4. Select the down arrow next to the Print button, located in the top right-hand corner.

  5. Choose Selected Cells.

  6. Hit the Next button to customize your print area and then print.

How to Set the Print Area in Google Sheets on the Android App

The Android Google Sheets App is great for many things, such as editing or viewing your document without any internet connection.

However, you cannot customize the print area on the Google Sheets Android app. You do still have some control, though. You can adjust the print settings like paper orientation, paper size, and which pages you want to print.

  1. Open your Google Sheets app.

  2. Select the spreadsheet you want to press More.

  3. Choose Share & Export, then choose Print.

  4. Select the Paper Size and adjust print settings.

  5. Select your printer.

  6. Hit the print button.

How to Set the Print Area in Google Sheets on the iPhone App

As you would expect from an iPad app, the Google Sheets app is extremely convenient and easy to use. You have the power to access your work whenever and wherever you want!

However, you are unable to print selected cells in the Google Sheets Android or Apple app. You can still print the entire sheet, though. Here's how.

  1. Open your Google Sheets app.

  2. Select the file you want to print and tap the More button.

  3. Choose Share & Export and select Print.

  4. Follow the instructions and pick your printer.

  5. Change the printer settings and choose how many copies you want to print.

  6. Press the Print button, and the file will start printing.

How to Set Print Area in Google Sheets: Summary and Key Takeaways

Now you have all the information you need for the print area and create the perfect presentation. It is a fantastic way to ensure you print the necessities and not any other parts. This will allow you to reduce your printing costs and increase the life of your printer.

Frequently Asked Questions About How to Set Print Area in Google Sheets

How do you access a print preview on Google Sheets?

To see your print preview and identify where the page breaks sit, you can either press CTRL and P or click on Print in the Home tab.

How do you change the print range in Google Sheets?

  1. From your Google docs sheet, choose the range you want to print, then select the printer icon from your toolbar.

  2. This will open the print settings, showing your document and the settings panel next to it. Select the range, click Print, and swap the Current Sheet to Selected Cells.

  3. Change the print settings for your custom page, and select print.

What is the Google Sheets print default setting

  • Current Sheet

  • Letter (8.5 x 11)

  • Landscape

  • Fit to width

  • Normal

Related Articles

Excel: Remove Trailing Spaces Quickly and Easily With These Simple Steps

Excel Repeat Last Action: What is it and How Does it Work?

SUM Index-Match: What is it, and How do I Use it?

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sed sapien quam. Sed dapibus est id enim facilisis, at posuere turpis adipiscing. Quisque sit amet dui dui.

Call To Action

Stay connected with news and updates!

Join our mailing list to receive the latest news and updates from our team.
Don't worry, your information will not be shared.

We hate SPAM. We will never sell your information, for any reason.