0:00
Hey everybody. In this video tutorial,
0:02
I'm going to show you how to link a PDF
0:04
document in a Google Sheets spreadsheet.
0:07
So, as you can see here, we have
0:09
successfully linked a PDF in our
0:11
spreadsheet and we can click on this uh
0:13
Bitcoin PDF white paper and it will open
0:16
up in a new tab as you can see here. So,
0:19
how you can insert or add a PDF link to
0:22
your Google sheet spreadsheet? It's
0:24
really easy to do. Let me you do it from
0:26
scratch. So all you have to do is first
0:29
you have to upload this PDF document to
0:32
the Google drive. You have opened this
0:34
uh Google sheet spreadsheet. So this
0:36
example we're going to use this Bitcoin
0:38
white paper. I download it to my PC.
0:40
Then all you have to do is go to Google
0:42
Drive and then click on new file upload.
0:45
So this is what I have done with this
0:47
Bitcoin PDF. As you can see upload is
0:49
complete. And then what you have to do
0:51
is click on these three dots. Select
0:53
share. Share again. And you have to make
0:56
sure that anyone with the link can view
0:59
this PDF document. So once you have
1:01
changed the access level, the general
1:04
access settings, click on done. You have
1:06
to share the PDF to be able to link in
1:08
the Google Sheets spreadsheet. Then
1:11
let's come back this project management
1:13
sheet we have here. And all we have to
1:15
do to link the PDF. Now we have in our
1:18
Google Drive folder is to right click on
1:20
the cell where we want to link it and
1:21
select insert link. And all you have to
1:23
do is in the search or paste the link
1:25
field here, search for your PDF. And as
1:28
you can see, it's here, Bitcoin PDF, and
1:31
click on that. And as you can see, just
1:33
like that, it has been linked to our
1:36
Google sheet spreadsheet. We can also
1:37
click on this edit link option and
1:40
change the visible text we have on the
1:43
cell like so. And click on apply. And as
1:46
you can see, we changed the visible text
1:48
as well. But now if you hover over this
1:51
cell, we can see the PDF preview and we
1:54
can click on it and check it out. So
1:56
I'll notice how to link a PDF in a
1:59
Google Sheets spreadsheet. I hope you
2:01
found this tutorial useful. If you want
2:03
to get access to our complete Google
2:05
Sheets function database or our Google
2:08
Sheets shortcut keys ebook for free and
2:10
other Google Sheets resources and Google
2:12
Sheets templates, then make sure to
2:14
check the links in the description
2:16
below. Also, if you want to learn more
2:18
about how to use Google Sheets, make
2:20
sure to check out our YouTube channel
2:21
and playlists where we have a ton of
2:23
tutorials and more Google Sheets
2:25
tutorials are coming up. So, also make