How to Insert PDF Files inside Excel
HTML-код
- Опубликовано: 7 авг 2024
- How to Insert PDF Files inside Excel
Sometimes we need to connect PDF Files in Excel. If an architect tries to list all the completed project and send it to a colleague. Its time to insert the building design inside the excel file through PDF. There are two ways to insert PDF files in excel. You can either link it or embed it. Both have their advantages and drawbacks. In this tutorial I’ll show you both ways and I’ll show you some awesome hacks for both this option.
Insert pdf file in excel by linking it:
1. First way to link Pdf file is to create a shape. Click on the insert menu and then click on shapes. Design and format shapes according to your need. Right click on the shape and click on link. Browse the pdf file and click ok. Done you just added your first pdf file into excel.
2. The second way is to click on the cell you want to link the PDF file and then right-click and select link. Select the file and click ok. Done. This will create a hyperlink to you excel cell and the hyperlink text will be the PDF file name. When you click on it the file will open.
3. The third way to link Pdf file is to click on the insert menu and then click on text. From the text dropdown select object. Click on create from file Right. Check mark on link to file. Browse the pdf file and click insert. Now resize the PDF object and done.
Pros Of licking PDF to Excel File:
1. The file will be linked but the excel file size will not increase. This will allow you insert tons of PDF files in excel.
2. The Link will size and move based on the cell by default allowing you to hide/unhide link when you hide/unhide the cell.
3. You’ll be able to do sorting and the file link will move based on the sorting.
Cons of Linking PDF files to excel:
1. As the pdf is just lined inside excel cell if you move/delete pdf file from its original location the link will be broken and you can’t open it from excel.
2. If you share the excel file the link will stop working
Insert pdf file in excel by embedding it:
1. First way to embed Pdf file is to click on the insert menu and then click on text. From the text dropdown select object. Click on create from file Right. Check mark on display as Icon. Click ok and browse the pdf file and click insert. Now resize the PDF object and done. Your PDF file is embedded and the icon is from your default PDF reader.
2. The second way to embed Pdf file is to click on the insert menu and then click on text. From the text dropdown select object. Click on create from file Right. Uncheck display as Icon. Click ok and browse the pdf file and click insert. Now resize the PDF object and done. Your PDF file is embedded and the icon is the first page of your PDF file.
Things to consider when Embedding PDF File in Excel: Right click on the embedded file and click on Format Object. Click on Properties. There are three options:
Move and Size with cells: This will keep the object connected to the cell. If you hide/unhide, resize or even filter cells the pdf object will move just like the cell.
Move but don’t Size with cells: This will keep the object partially connected to the cell. If you hide/unhide, resize or even filter cells the pdf object will move just like the cell but it will not resize or hide or filter.
Don’t Move and Size with cells: This will keep the object floating and on the same location. If you hide/unhide, resize or even filter cells the pdf object will not move
Pros Of Embedding PDF to Excel File:
1. The Link will size and move based on the cell by default allowing you to hide/unhide link when you hide/unhide the cell based on the properties you select.
2. You’ll be able to do sorting and the file link will move based on the sorting based on the properties you select.
3. You’ll be able to share the workbook and it’ll be open the PDF from anyone.
4. Even you delete the main PDF file the embedded pdf will still be there.
Cons of Linking PDF files to excel:
1. As the pdf is embedded inside excel cell the excel file size increases a lot. This will make your excel file slower if you add too many PDFs.
#Insert #PDF #Excel
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe: goo.gl/uL8fqQ
The most recent video: bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Quora: bit.ly/3bxB8JG
Thank you for your help
Every tutorial on RUclips should be presented in this way. Precise and concise
Thanks a million
Excellent explanation and thorough documentation.
Thank you.
Thanks a Million
Exactly what I wanted!
Explained as plain and simple.
Thanks!
Glad it helped! Please subscribe and share.
Thank you. i got what i was searching in so many videos. helpfull as well as easy to understand. 😊
Thanks a million. Please share and be with us.
The video was really helpful. Thanks.
You're welcome!
Great information but if you could slow down to give us time to follow along that would be very helpful. Thanks!
Noted!
Nippy and informative tutorials!
Glad you like them!
Thank you so much 💕
You are most welcome
Dziekuje.
Tego potrzebowalem.
👍
You're most welcome.
Thank you very much!!! Great work!!!
Glad you liked it!
great vedio thank you so much ❤
So nice of you
excellent!!! thanks for the info
Glad it was helpful!
Thanks a lot for your video
You are most welcome. Please subscribe and share.
I'm so happy to get your good material solving my problem.
Thanks a million.
Thank you 🙏
You're most welcome.
thank you very much... usefull
You're most welcome. Please subscribe and be with us.
Really nicely discrbed
Glad you like it. Please subscribe and be with us.
Very good explanation.. keep going..
Thanks a million. Please subscribe and be with us.
omg this help so much
Glad it was helpful.
Great video!!!!
Glad you enjoyed it. Please subscribe and share.
Woow...Thanks alot
Most welcome 😊 Please subscribe and be with us.
Thanks a lot sir
Most welcome
Nice video ...thanks
Most welcome
Great yaar...
Thanks man. Please subscribe and be with us.
THANK YOU
You're most welcome. Please subscribe and be with us.
Really Helpful 👍
Glad to hear that
Thanks so much
You're welcome! Please subscribe and share
Can we share the embedded object file of excel on mail and the recepient also able to view the attachments at same place?
Yes, sure. If you attach the file with it. If you link it it will not work.
Thank you .. But please slow down.
Liked and subbed.
I will try my best
Excellent brother.. I make use this of video
Great 👍 Please subscribe and share.
Very informative and very direct to the point! I've learned a lot.
Glad you enjoyed it!
Thank you
You're welcome. Please subscribe and share
Thanks
Most Welcome. Please subscribe and be with us.
THANKS
You're welcome!
Will the links still work if you export your excel document to a pdf?
Try and let us know.
Can be done on phone excel or only on laptop? Because ive been trying to do on my phone but i cant
Not on the phone. Sorry.
I've got hundreds of pdfs to add. Do you recommend either of these methods or should I just not attempt linking them in the Excel file?
Try a few. Check the workbook size. Then decide what is best for you. You can always use hyperlink to connect pdfs. let me know what you decide.
@@Excel10tutorial Do you happen to know what the size restriction would be to send this via email?
too fast, but thanks for your effort
Sorry for that. Newer videos don't have that problem.
Itni speed main kesay pta lagay ga bhai?
Sorry for that brother.
First you said to subscribe before showing me how to fix my problem....then I didn't... until 1:15 min watching the video😂
Thanks for subscribing.
شكرا جدا لكن قلل سرعة التحدث قليلا
You're most welcome and thanks for the tip.
Please explain slowly
I've done that recently.
Remember it is tutorial, so please go slow
Yes. New Videos don't have that problems. I am trying to fix it. Thanks a million for your input.
go slow
I will. Thanks for the sugestion.
its so hard to find someone doing these videos where english is their first language!
They have greater things to do!