Feeling Lucky?

Downloading Files from Google Sheets in PDF Format

 Bismillah,

Assalamualaikum 

Downloading files from Google Sheets in pdf format is quite easy to do, which is similar to printing files in pdf format from Microsoft Excel. 

The steps are as follows:

  1. The first step is to select the cell / part which will be downloaded.

    • Selecting the cell to be downloaded is by blocking the cell, either by left-clicking and holding the mouse or by selecting the end of the cell and then holding "Shift" on the keyboard and then directing the direction " up", "bottom", "left", and "right" on the keyboard until all the cells you want to download are blocked.

Examples of selecting cells to download

  1. Set the desired

    • size Setting the paper size is done by selecting the printer icon in the upper left submenu.

    • Next set the desired paper size

Select the “Printer” icon at the top left of Google Sheets


Set the paper size 

  1. Set the page 

    • orientation Set the page orientation to portrait or landscape in the right area


Set the page orientation

  1. Ensure the section to be downloaded is not cut horizontally

    • This section is also not to be missed , i.e. making sure the page doesn't crop horizontally. The trick is to select "Fit To Width" in the "Scale" option.

Selecting the scale of the printed page


  1. Download PDF

    • Then the last step is to download the page in pdf format, by pressing the blue “Next” button in the upper right corner.

    • Then select “Save as PDF” in the printer section on the left.

    • Then press the blue “Save” button in the lower left corner.

Pressing the “Next” button in the upper right corner

Selecting “Save as PDF” in the printer section on the left

. Pressing the blue “Save” button in the lower left corner.


This is a tutorial for downloading data from Google Sheets in PDF format. I hope this article can help. 

Thank you so much 

Wassalamualaikum 


Comments

Post a Comment

Popular posts from this blog

Protect Range and Protect Sheet in Google Sheets

Image
  Bismillah, Assalamualaikum On this occasion I will discuss one of the features of Google Sheets, namely "Protect Range" and "Protect Sheet".  Co-editing with others is one of the advantages of using Google Sheets. But sometimes we want some cells to be locked so that they are only edited by the account that owns the file. For that, Google Sheets provides a feature called “Protect Range” and “Protect Sheet”. With this protection system, the file owner will no longer worry that key data or formulas that have been compiled can be tampered with by other users.  Protect Range The steps to "Protect Range" are as follows: Select cells you want to protect with blocking cells, either by left-clicking and holding the mouse or by selecting the end of the cell and then holding "Shift" on the keyboard and then directing the direction"up", "down", "left", and "right" on the keyboard until all the cells you want to prot...
Read more

Membagikan Google Sheets dengan Orang Lain untuk Penyuntingan / Edit Bersama

Image
Bismillah, Assalamualaikum Warohmatullohi Wabarokatuh  Salah satu manfaat dari Google Sheets adalah kemampuan untuk melakukan penyuntingan dokumen bersama orang lain.Untuk melakukan fungsi ini anda perlu membagikan tautan dokumen tersebut. Adapun caranya adalah sebagai berikut : Metode Pertama Cara yang digunakan pada metode pertama adalah dengan melakukan klik kanan dokumen Google Sheets yang ingin dibagikan.  Klik kanan dokumen yang ingin dibagikan. Klik kanan pada dokumen yang ingin dibagikan Kemudian memilih “Share” Selanjutnya akan muncul jendela baru dan menekan tulisan “Change to anyone with the link” yang berwarna biru di pojok kiri bawah, hingga muncul jendela baru lagi. Menekan tulisan “Change to anyone with the link” Jendela baru yang muncul setelah menekan tulisan “Change to anyone with the link” Merubah “Viewer” menjadi “Editor” yang berada di sisi kanan jendela Merubah “Viewer” menjadi “Editor”  Menekan tombol “Copy link” yang berwarna biru dan anda dapat me...
Read more

Create Automatic Certificate with Autocrat Google Sheets

Image
  Bismillah, Assalamualaikum Hello everyone, in this article I will share a tutorial on how to create an automatic certificate using Google Sheets with Autocrat Add Ons. First, prepare a certificate design that will be distributed to trainees. You can design a certificate using canva.com. There are several certificate designs that can be customized.  Search for a certificate design on canva.com Choose the certificate design you want. Select certificate design Remove certificate recipient Delete certificate recipient name  Delete certificate recipient name Customize the type of activity and the name of the committee. Customize the activity type and committee name Download the certificate in .png or .jpg format. Download certificate Second, place the certificate design that you have downloaded on Google Slides. Put the certificate design in Google Slides. Insert a certificate design in Google Slides Set the slide size to match the certificate size. On the File menu > Pag...
Read more