{"id":4055,"date":"2023-02-03T20:42:00","date_gmt":"2023-02-03T20:42:00","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=4055"},"modified":"2024-01-25T20:45:06","modified_gmt":"2024-01-25T20:45:06","slug":"how-to-insert-embed-pdf-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-insert-embed-pdf-in-excel\/","title":{"rendered":"How to Insert (Embed) PDF in Excel?"},"content":{"rendered":"

Insert Embed PDF in Excel stands as the bridge between two powerful data formats, offering you the versatility to seamlessly integrate PDF documents into your Excel workbooks. This feature opens up a world of possibilities, from creating comprehensive reports to sharing information-rich presentations. With ‘Insert Embed PDF in Excel,’ your spreadsheet becomes more than just rows and columns\u2014it becomes an interactive platform where data and documents converge. Embrace this innovative function to elevate your data presentation and reporting capabilities, ensuring that your Excel files are not just static tables but dynamic hubs of information. Whether you’re crafting engaging reports or conducting data-driven presentations, ‘Insert Embed PDF in Excel’ empowers you to create more engaging, informative, and interactive data experiences.<\/p>\n

\u00a0<\/strong>This Content Covers:<\/strong><\/p>\n

    \n
  1. How to Embed PDF in Excel?<\/strong><\/a><\/li>\n<\/ol>\n

    1.1 From the Insert Tab<\/strong><\/p>\n

    1.2 Embed all PDF files from a Folder with VBA<\/strong><\/p>\n

      \n
    1. \n
        \n
      1. How to Fix the Embedded PDF File to a Cell?<\/strong><\/a><\/li>\n
      2. How to Change the Icon\/Title of an Embedded PDF File in Excel?<\/strong><\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

        1. How to Insert PDF in Excel?<\/strong><\/h2>\n

        1.1 From the Insert Tab<\/strong><\/p>\n

        Step 1: <\/strong>Open a worksheet and go to Insert>>Object.<\/strong><\/p>\n

        \"Insert<\/p>\n

        \"Insert<\/p>\n

        Step 2: <\/strong>From Object <\/strong>dialogue box go to Create from File <\/strong>tab and select Browse. <\/strong>Or use ALT+N+J<\/strong> shortcut keys to open the Object<\/strong> dialogue box.<\/p>\n

        \"Insert<\/p>\n

        Step 3: <\/strong>Look for the pdf file that you want to insert in your device and click Open.<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 4: <\/strong>Check Display as icon box<\/strong>. You can also check the Link to file<\/strong> option if you want any future changes to the source file to be reflected in the embedded file. Click OK.<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 5: <\/strong>Your selected pdf file has been inserted in your Excel worksheet.<\/p>\n

        \"Insert<\/p>\n

        1.2 Embed all PDF files from a Folder with VBA<\/strong><\/p>\n

        Step 1: <\/strong>Right click on the sheet name and select View Code.<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 2: <\/strong>Insert the below given code inside VBA Script<\/strong> box. Change this text (type your folder location here) <\/strong>with the folder location in your device which has all the pdf files you want to insert. Click on RUN.<\/strong><\/p>\n

        Sub EmbedPDFs()<\/strong><\/p>\n

        Dim pdfFiles As String<\/strong><\/p>\n

        pdfFiles = Dir(“type your folder location here\\”)<\/strong>\u00a0<\/strong><\/p>\n

        Do While Len(pdfFiles) > 0<\/strong><\/p>\n

        \u00a0\u00a0\u00a0 If Right(pdfFiles, 3) = “pdf” Then<\/strong><\/p>\n

        \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ActiveSheet.OLEObjects.Add(Filename:= _<\/strong><\/p>\n

        \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ” type your folder location here\\” & pdfFiles _<\/strong><\/p>\n

        \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Link:=False, DisplayAsIcon:=True, IconFileName:= _<\/strong><\/p>\n

        \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ” type your folder location here\\HowtoExcel.ico”, _<\/strong><\/p>\n

        \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IconIndex:=0, IconLabel:=pdfFiles).Select<\/strong><\/p>\n

        \u00a0\u00a0\u00a0 End If<\/strong><\/p>\n

        pdfFiles = Dir<\/strong><\/p>\n

        Loop<\/strong><\/p>\n

        End Sub<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 3: <\/strong>All the pdf files embedded with by using a VBA code.<\/p>\n

        \"Insert<\/p>\n

        2. How to Fix the Embedded PDF File to a Cell?<\/strong><\/h2>\n

        A PDF file is put as an object above the worksheet cells when it is embedded in Excel. If you changed the cells under the icon, its location remains the same. You can follow the step below to make sure the pdf file sticks with a particular cell.<\/p>\n

        Step 1: <\/strong>First of all, you have to set the pdf file inside a cell either by resizing the pdf file or the cell itself.<\/p>\n

        \"Insert<\/p>\n

        Step 2: <\/strong>Once the pdf file is set inside a cell, right click on the pdf and select Format Object.<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 3: <\/strong>Go to Properties tab<\/strong>>>select Move and size with cells<\/strong> and click OK.<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 4: <\/strong>The pdf file is fixed with cell A1 and whenever you resize this cell the pdf file will change also.<\/p>\n

        \"Insert<\/p>\n

        3. How to Change the Icon\/Title of an Embedded PDF File in Excel?<\/strong><\/h2>\n

        Step 1: <\/strong>Right click on the pdf file and select Acrobat Document Object>>Convert. <\/strong>Or select the pdf file and use ALT+E+O+V<\/strong> to open the Convert<\/strong> dialogue box.<\/p>\n

        \"Insert<\/p>\n

        Step 2: <\/strong>Select the Change Icon<\/strong> from the Convert <\/strong>dialogue box. This will open the Change Icon<\/strong> dialogue box. Click on Browse<\/strong> if you want to change the icon and type a new name\/title for your pdf file inside the Caption<\/strong> box. Click OK>>OK.<\/strong><\/p>\n

        \"Insert<\/p>\n

        Step 3: <\/strong>The embedded pdf file\u2019s title has been changed.<\/p>\n

        \"nsert<\/p>\n

        Application of Insert Embed PDF in Excel<\/strong><\/h2>\n
          \n
        1. Comprehensive Reports<\/strong>:\n