

When you embed a PDF file in Excel, it is inserted as an object that sits above the worksheet cells. To insert multiple PDFs, follow the same steps (as shown above). The PDF icon inserted using the above steps is an object (just like charts or shapes) and you can resize it and place it anywhere in the worksheet. You can close the PDF file and continue to work with Excel. These steps would insert a PDF file in the worksheet.Īs soon as the PDF is inserted in the worksheet, it also gets opened by default.

Go to Insert tab and click on the Object icon in the Text group.Here are the steps to embed a PDF File in Excel: How to Embed a PDF File in an Excel Worksheet How to Embed a PDF File in an Excel Worksheet.If you have any older version of Office, such as office 2010, head to the Microsoft Support page for more information.

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.
