You can add a hyperlink to a picture, and the link can help you open a file when you click on it. Microsoft Excel has a not very well-known feature. The second method is not as easy as the first one. How to Insert PDF into Excel with 'Hyperlink' Feature Click on the 'OK' button to import the PDF into your Excel document as an attachment. Choose 'Create from file' and browse your folder to select the PDF you want to insert in the popping-up window. Then, select the 'Object' option in the 'Text' section in the right corner. Open your Excel spreadsheet and navigate to the 'Insert' tab. Steps to Insert PDF in Excel as An Object: Next, you know how to insert a PDF into Excel without losing formatting. This function is embedded in Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 365, and other versions. Merits of this type of method are evident - no third-party software is included, no money is charged, and both Mac and Windows users can gain access to this method. The first way is inserting PDF into Excel as an object. If you have any older version of Office, such as office 2010, head to the Microsoft Support page for more information.Method 1. Click “Save” to save the new PDF version.

Click “Ok” to close the “Options…” window.

“Selection”: convert a previously highlighted selection as PDF.

“Active sheet(s)”: convert only the sheets with data as PDF.

“Entire workbook”: convert the whole workbook as PDF.

Under “Publish what”, choose to publish using the following options: In the “Save as type” dropdown, select “PDF”. In your workbook, head to File > Save As, or File > Save a copy.

The following steps are compatible with the following versions: Microsoft 365, Office 2021, Office 2019, and Office 2016: Let’s take a look at how to save your Excel as PDF for both Windows and macOS. What’s more, you can easily convert your Excel to PDF without a converter. This method is best for those using the Excel desktop app. It may be best to use “Save As” rather than “Save”, so you have your original format as well as the PDF version. This is possibly the most common way to turn your Excel workbook into a PDF.

Excel import table from pdf