Method 2: Inserting the PDF File into Excel through a Hyperlink But to apply this procedure you need to ‘Display as icon’ then checkbox by clicking ‘Object’ windows and then press the ‘OK’ button. Step 4: To insert your selected PDF file into the Excel spreadsheet click ‘OK’Īt this point, you can insert the selected PDF file as an icon that can be clicked for the file to open. Step 3: In the pop-up dialogue box, select ‘Create from File’ this will enable you to browse the folders and select the PDF file you want to use. Step 2: Next is to select ‘Object’ on your drop menu. Step 1: Open the Excel spreadsheet and tap on the ‘Insert’ menu. Steps to follow when inserting PDF files in Excel as an object These versions of Excel have essential tools that can help you to insert your PDF into excel using mac or windows. With excel 2010, 2013, 2016, and Excel 365 you can easily insert a PDF file into an Excel spreadsheet or excel workbook. The Excel workbook can integrate with many tools that are used when performing different tasks such as calculations and graphics. There are simple methods of inserting PDF files into Excel Method 1: Inserting PDF Files into Excel Sheets as an ObjectĪs we said, there are several ways of doing this, but the first way is to insert your PDF file as an object. We will help you to learn how to insert PDF into Excel using three outstanding methods of inserting PDF into excel, and steps to follow when doing it.

You may be trying to issue invoices using your excel workbook and do not know how to do it. This is an important tool for accounts and several other professionals. Remember, the excel sheet is one of the key players when carrying out data analysis. It is quite easy if you follow the following steps carefully. This article is set to help you know how to merge PDF files into excel. Sometimes it is hard for a beginner to know how to insert a PDF into an excel sheet.

Import pdf into excel 2016