Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • OneDrive
      • Google Docs
      • Google Sheets
      • Google Drive
    • Email
      • Gmail
      • Outlook
      • Emal Etiquette
    • Office Etiquette
    • Productivity
    Inside The Web
    Home»Office»Google Sheets»How to Set Print Area in Google Sheets

    How to Set Print Area in Google Sheets

    Nisha GurungBy Nisha GurungApril 24, 2023 Google Sheets 3 Mins Read

    While printing the documents in Sheets, you may be prompted to print only a particular cell range regularly. For Instance, the total sales report every week. During such cases, you may wish to set a Print Area on Sheet for your convenience. 

    Unfortunately, unlike Excel, Google Sheets does not have default Print Area settings. Meaning, when you enter Ctrl + P, you’ve to choose Print Settings every time. 

    In most cases, you would find the need to set a Print Area to print only specific areas. So, as a workaround, you can choose to print only the selected cells on your sheet.

    Step 1: Set Selected Cells to Print

    1. On your Sheet, select Cell Ranges to Print.
    2. Enter Ctrl + P to bring up the Print menu. Or, you can also navigate to File > Print.
    3. Under Print, pick Selected cells.
      Under Print, pick Selected cells

    Step 2: Print Page Setup

    Once you choose the Print option, stay on the same page. In this step, you can set up the paper size, margins, scale, and page orientation to print.

    1. Expand the drop-down menu of Paper size and choose an option. Here, we picked A4.
    2. On Page orientation, choose from Landscape or Portrait mode to print. 
    3. Under Scale, pick any one of the options as per your data size:
      • Normal (100%): Prints normal view.
      • Fit to width: Fits all Columns on one page.
      • Fit to height: Fits the entire Row on a single page.
      • Fit to page: Fits everything ( all Rows and columns) on one page.
      • Custom Number: Set your own scaling percentage number.
    4. Now, set the Margins for your document. Pick any one option from Normal, Narrow, Wide, or Custom Number. (If you choose Custom Number, drag the blue-dotted margins and set them as per your preference.)

    Step 3: Format Print Page

    After you’re done with Page Setup, you can see Formatting and Headers and Footers menu right below the Margins. Expand both menus to format your print page.

    1. Under Formatting, tick or untick the box for Show grid lines and Show notes.
    2. Change the Page Order and Alignment if you want.
    3. On Headers and footers, tick the boxes for the options you want to include in the Document. Then, under Row & Column headers, check the box for Repeat frozen rows/ Repeat frozen columns.
    4. When done, click Next at the upper right to proceed.
      When done, click Next to Continue
    NOTE: Repeat frozen rows/ Repeat frozen columns option will be greyed out if you haven’t frozen them.

    Step 4: Configure Print Settings and Print

    This is the final step where you’ll be prompted to choose Print Destination, number of Pages to print, and page color. Additionally, you can also re-set the page setup and Print.

    1. On Destination, expand the drop-down menu and choose your Printer.
      On Destination, expand the drop-down menu and choose your Printer
    2. Then, specify Print Pages and Color. 
    3. Expand More settings menu to set Paper size, Pages per sheet, Margins, and Scale as per your wish.
      Expand More Settings menu
    4. When done, hit the Print button.
      When done, hit Print Button

    Related Questions

    Can You Print the Selected Cells on the Google Sheets Mobile App?

    Unfortunately, the Google Sheets Mobile app does not have the option to Print Selected Cells like in the website version. However, when you tap the Print button, there are a few Print Settings you can change as per your wish. So, copy the desired data and paste them into the new sheet. Then, while printing, choose to print only that sheet. 

    Nisha Gurung

      As a Business Student, Nisha first used Excel to outline data trends for her college projects. Later, she started exploring basic Excel functions when she realized it is a powerful tool for all businesses today. Nisha believes she can relate to many of the issues users face when starting their Excel Journey. She uses this knowledge and experience to curate contents that are fit for all types of Excel users. Apart from writing, she enjoys reading books and traveling.

      Related Posts

      Google Sheets By Jabin Manandhar

      9 Ways to Fix Google Sheets Not Working

      Google Sheets By Asmi Dhakal

      How to Delete Every Other Row in Google Sheets

      Google Sheets By Nisha Gurung

      How to Highlight Duplicates in Google Sheets

      Add A Comment
      Table of ContentsToggle Table of ContentToggle
      • Step 1: Set Selected Cells to Print
      • Step 2: Print Page Setup
      • Step 3: Format Print Page
      • Step 4: Configure Print Settings and Print
      • Related Questions
        • Can You Print the Selected Cells on the Google Sheets Mobile App?
      • Home
      • About Us
      • Privacy Policy
      © 2025 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.