How To Set The Print Area In Google Sheets

Device Links

Google Sheets is a powerful spreadsheet application that offers many tools to make data analysis easier. One of the most important features for printing your work is the print area, which defines how much of your sheet will be printed.

How To Set The Print Area In Google Sheets

Getting the print area right is essential.

By default, Google Sheets prints the entire sheet when you hit the print button. But you don’t want to do this because you could end up leaving out some cells or columns. You might even end up printing blank pages with only the headers and footers.

Setting the print area is a skill you need to learn if you want your printer to spit out quality, well-organized pages that make it easy to present or analyze data.

In this article, we’ll show you how to set the print area and print only what you want, without wasting paper or ink.

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

PCs have many advantages over other devices when it comes to using Google sheets.

For starters, a PC comes with a large screen to help you enter your data with ease and execute various Google Sheets commands. For example, you can add formulas and charts that build sophisticated spreadsheets for business or personal use.

Most importantly, working on Google Sheets using a PC comes with more printing options when setting your printing area. You can choose to print the entire workbook, the current sheet, or just a few cells in the current sheet.

Let’s see how to set the print area to set the current sheet or workbook.

Setting the Current Sheet or Workbook as the Print Area

If you want to print everything on a given worksheet, do as follows:

  1. Open the worksheet.
    How To Set The Print Area In Google Sheets
  2. Click on the “print” button found in the top left corner of the menu bar. This should open the print settings window. By default, the window comes with a preview of your sheet.
    How To Set The Print Area In Google Sheets
  3. In the top right corner of the print settings window, you should see a greyed-out print button with a down arrow next to it. Click on the down arrow and select “Current Sheet.”
    How To Set The Print Area In Google Sheets
  4. Click on “Next.”
    How To Set The Print Area In Google Sheets
  5. At this point, a new window will pop up on your screen, giving you the chance to customize the print area and specify the number of copies you’d like to print. You can also change the print color.
    How To Set The Print Area In Google Sheets
  6. Once you’ve customized your print area to your satisfaction, click on “Print.”
    How To Set The Print Area In Google Sheets

Setting Selected Cells as the Print Area

Sometimes you may want to print only a specific part of your worksheet. This could happen when you want to present just a part of your work or even share certain sections with your colleagues for discussion before printing the entire worksheet.

Whatever the situation, here’s how to print selected cells in Google Sheets.

  1. Open the worksheet you’d like to print.
    How To Set The Print Area In Google Sheets
  2. Select the cells of interest. While you’re at it, you should select a continuous range of cells.
    How To Set The Print Area In Google Sheets
  3. Press the printer icon button found in the top left corner of the menu bar. Alternatively, click on “File” and select “Print” from the dropdown menu. This will open the print settings window.
    How To Set The Print Area In Google Sheets
  4. Click on the down arrow that appears right below the greyed-out “Print” button in the top right corner.
    How To Set The Print Area In Google Sheets
  5. Click on “Selected Cells.”
    How To Set The Print Area In Google Sheets
  6. Press “Next” to open the final pre-printing window where you can customize your print area before sending the file to your printer.
    How To Set The Print Area In Google Sheets

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

The Android Google Sheets app allows you to save your spreadsheets on your phone for quick access.

A big advantage is that you can edit or view your document even when you’re not connected to the internet. This way, you’re able to keep working when you are on the go.

On the downside, the Android Google Sheets app doesn’t allow you to set a customized print area. You can only print the entire spreadsheet. However, it does allow you to adjust print settings such as paper size, paper orientation, specific pages to print, color

Here’s how to print a spreadsheet when you’re using the Android app:

  1. Open the Google Sheets app on your device.
    How To Set The Print Area In Google Sheets
  2. Open the spreadsheet you’d like to print and tap on “More” in the top right corner of your screen.
    How To Set The Print Area In Google Sheets
  3. Tap on “Share & export.” and then tap on “Print.”
    How To Set The Print Area In Google Sheets
  4. Tap on “Paper size.” This will allow you to adjust your print settings and specify things like paper orientation and color.
    How To Set The Print Area In Google Sheets
  5. Follow the on-screen instructions to choose the printer to use.
    How To Set The Print Area In Google Sheets
  6. Tap on “Print” to begin printing your spreadsheet.

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

The Google Sheets iPhone app is built with convenience in mind. You can access your work anytime, anywhere. You can also update your spreadsheets with new information or even start a new project.

But as with the Google Sheets Android app, you can’t print selected cells in a sheet. You can only print the entire sheet.

Here are the steps:

  1. Open the Google Sheets app on your iPhone.
    How To Set The Print Area In Google Sheets
  2. Open the file you wish to print and tap on “More.”
    How To Set The Print Area In Google Sheets
  3. Select “Share & export” from the popup window and then tap on “Print.”
    How To Set The Print Area In Google Sheets
  4. Follow the on-screen instructions to choose the printer you’d like to use.
    How To Set The Print Area In Google Sheets
  5. Adjust your printer settings if you want, and specify other details such as the number of copies you’d like.
  6. Tap on “Print” to send the file to your printer for printing.
    How To Set The Print Area In Google Sheets

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

The Google Sheets iPad app works pretty much like its iPhone counterpart.

Here’s how to print a spreadsheet:

  1. Open your iPad and launch the Google Sheets app.
    How To Set The Print Area In Google Sheets
  2. Navigate to the file you’d like to print and tap on “More.”
    How To Set The Print Area In Google Sheets
  3. Tap on “Share & export” and then tap on “Print.”
    How To Set The Print Area In Google Sheets
  4. Follow the on-screen guide to specify the printer you’d like to use.
    How To Set The Print Area In Google Sheets
  5. Adjust your printer settings to tweak things like orientation and color.
  6. Tap on “Print” to begin printing.
    How To Set The Print Area In Google Sheets

Print With Freedom

Setting the print area is the first step toward a successful presentation. It’s a great way to make sure you only print what you want. This can help you cut printing costs and extend the useful life of your printer and other printing accessories.

Be that as it may, a PC is the best device for customizing your print area. Although Android and iOS mobile apps come equipped with the print button, you can’t dictate which cells to print and which ones to leave out.

Have you tried printing selected cells in google Sheets? How did it go?

Let us know in the comments section below.

Sign up and earn $1000 a day ⋙

How to fix error 0xa00f4288 in Camera app on Windows 10 & 11

How to fix error 0xa00f4288 in Camera app on Windows 10 & 11

How to fix error 0xa00f4288 in the Camera app on Windows 10 & 11. Windows' default Camera App is the main tool for taking photos. So in the case of Win 10 & 11 cameras

How to open multiple programs with one shortcut on Windows 10

How to open multiple programs with one shortcut on Windows 10

How to open multiple programs with one shortcut on Windows 10, You can actually open multiple programs at the same time with a single key. Here's how to use one

How to delete old boot menu options on Windows

How to delete old boot menu options on Windows

How to remove old boot menu options on Windows, Windows 10 dual boot is useful but can leave redundant boot options in the menu. Here's how to remove the menu

Instructions for fixing Snipping Tool errors on Windows 11

Instructions for fixing Snipping Tool errors on Windows 11

Instructions for fixing Snipping Tool errors on Windows 11. Windows 11 has officially been released for a while, but during use there are still many errors

Instructions for entering text by voice on Windows 11

Instructions for entering text by voice on Windows 11

Instructions for entering text by voice on Windows 11, Entering text by voice on Windows 11 helps you significantly improve your work efficiency. Here's how

How to turn on/off Sticky Key on Windows 11

How to turn on/off Sticky Key on Windows 11

How to turn on/off Sticky Key on Windows 11, Sticky Key makes the PC keyboard easier to use. Here's how to turn Sticky Key on and off on Windows 11.

What is Windows Modules Installer?

What is Windows Modules Installer?

What is Windows Modules Installer?, Windows Modules Installer sometimes takes up a lot of system resources. Is Windows Modules Installer important or not?

How to increase volume in Windows 10

How to increase volume in Windows 10

How to increase volume in Windows 10, How to increase computer volume to maximum level? Let's learn with WebTech360 how to increase Windows 10 computer volume

How to use Windows 11 Installation Assistant to install Windows 11

How to use Windows 11 Installation Assistant to install Windows 11

How to use Windows 11 Installation Assistant to install Windows 11, Windows 11 Installation Assistant is one of the best ways to upgrade your computer to Windows 11.

How to turn off the startup sound in Windows 11

How to turn off the startup sound in Windows 11

How to turn off the startup sound in Windows 11, Does the PC startup sound bother you? Then please refer to how to turn off the startup sound for PC running Windows 11 below

Instructions for changing the screen lock timeout on Windows 11

Instructions for changing the screen lock timeout on Windows 11

Instructions for changing the screen lock timeout on Windows 11. While using Windows 11, there are times when users will need to leave the computer for a period of time.

Windows 11 optimization guide to increase FPS when playing games

Windows 11 optimization guide to increase FPS when playing games

Instructions for optimizing Windows 11 to help increase FPS when playing games, Windows 11 is an operating system platform that is introduced as more improved in gaming quality, helping games

Windows 11: How to use and customize the Quick Settings menu

Windows 11: How to use and customize the Quick Settings menu

Windows 11: How to use and customize the Quick Settings menu, Windows 11 brings some great new features and the Quick Settings menu is no exception. Here it is

How to fix the error of not being able to start Windows 11 after enabling Hyper-V

How to fix the error of not being able to start Windows 11 after enabling Hyper-V

How to fix the error of not being able to start Windows 11 after turning on Hyper-V. Hyper-V helps you run virtual machines on Windows. However, after enabling Hyper-V, you cannot post again

How to fix error 0xc00007b in Windows

How to fix error 0xc00007b in Windows

How to fix error 0xc00007b in Windows, Windows displays error 0xc00007b when the application does not work properly. Below is a step-by-step guide to fix error 0xc00007b in

How to change the login screen on Windows 10/11

How to change the login screen on Windows 10/11

How to change the login screen on Windows 10/11, Don't like the blurry screen when logging in on Windows 10/11? So, instructions on how to turn off and change the login screen

How to uninstall drivers in Windows 11

How to uninstall drivers in Windows 11

How to uninstall drivers in Windows 11, Do you want to remove unwanted drivers on Windows 11? Then please see instructions on how to remove drivers in Windows

How to fix No Internet Secured error on Windows 10

How to fix No Internet Secured error on Windows 10

How to fix No Internet Secured error on Windows 10, No Internet Secured is a common error on Windows 10. Below are simple ways to fix No Internet Secured error

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to open DMG files on Windows

How to open DMG files on Windows

How to open DMG files on Windows, DMG is a file format specific to the macOS operating system. However, you still have a way to open DMG files on Windows.