How To Set Print Range In Google Sheets

Steps

1. 1

   Navigate to https://sheets.google.com in any web browser. If you're non already signed in to your Google account, sign in now.

2. 2

   Click the spreadsheet you want to print.

   Advertising

3. iii

   Select the cells you want to print. Click and hold ane cell and then drag the mouse to select others.

   • To select multiple rows, click and drag the mouse down the row numbers on the left side of the screen.
   • To select multiple columns, click and drag the mouse across the column letters at the height of the screen.

4. 4

   Click the print icon. It's near the pinnacle-left corner of the screen. A print bill of fare will appear.

5. v

   Select Selected Cells from the "Print" drop-downwards card. Information technology'south at the tiptop of the print menu.

6. 6

   Click Side by side . Information technology's at the top-correct corner of the screen. This opens your computer's impress dialog box, which may vary by reckoner.

7. seven

   Click Impress . The document will now impress simply the selected cells.

   • You may have to select a printer before you can print.

Advertisement

Add New Question

• Question

  I select all, but just half gets printed out. What might be incorrect?

  

  Your printer must have a broken circuit board, perhaps because of an ink leak. You volition need to have it replaced.

• Question

  How practice I preview a Google Sail before press?

  

  Automatically, earlier you print, a preview box should popular up with options and everything else yous might need to know.

• Question

  How do I see impress boundaries on Google Sheets?

  

  When yous print, the options/preview box should pop up subsequently you click print. Adjust every bit needed from this box.

• Question

  What practise I do if my highlighted columns in Google Sheets are actualization twice?

  

  Bailee Timmons

  Community Respond

  Attempt refreshing the page or clicking off of those columns, then trying once more.

• Question

  How do I change the formats of documents on Google Sheets?

  

  Unfortunately, at present, Google does non include the formats of Google Sheets.

• Question

  How do I impress frozen columns with the highlighted columns?

  

  Max Is Ballsy

  Customs Answer

  To repeat frozen rows and/or columns each folio: Go to the "Page Layout" tab on the ribbon and click "Print Title". There you lot tin input witch row to repeat on top and which column to repeat at left.

• Question

  How to print two non-contiguous columns?

  

  Anoushka Richard

  Community Respond

  Select a range of cells. Printing Ctrl and select another expanse. Echo this as many times equally you need. Click the Impress Surface area icon (if the icon is displayed in the Standard toolbar).

Enquire a Question

200 characters left

Include your email accost to get a message when this question is answered.

Submit

Advertising

About This Article

Article Summary X

ane. Open up Sheets.
2. Click a spreadsheet.
iii. Select cells to print.
four. Click the print icon.
5. Select Selected Cells from the "Impress" menu.
6. Click Next.
7. Click Print.

Did this summary help you?

Thanks to all authors for creating a page that has been read 120,920 times.

Is this commodity up to date?

Source: https://www.wikihow.com/Set-Print-Area-on-Google-Sheets-on-PC-or-Mac

Share this post