How to Insert a Multiple Page PDF into Excel – 2 Methods

Method 1 – Inserting a Multiple Page PDF File as a Text Object

Steps:

  • Open an excel file.
  • In the Insert tab, click Text and select Object.

A new window will be displayed.

  • In Create New, a new file is created based on the pdf reader installed on your computer.
  • In Create from File, a window will be displayed:

Insert Multiple Page PDF File as a Text object.

  • Choose the pdf file by browsing the file manager: click Browse.
  • Select the pdf file. Here, N-429(Theories).
  • Click Insert.

  • In the Object dialog box >> Click OK.

Insert Multiple Page PDF File as a Text object.

The first page of the pdf is displayed in the excel worksheet.

  • Double-click the file content to open the pdf file.

Insert Multiple Page PDF File as a Text object.

 


Display as icon

  • In the Object window, check Display as icon and click OK.

Insert Multiple Page PDF File as a Text object

This is the output.

  • Double-click the Icon to open the pdf viewer.

Link to file

  • You can link the file by checking Link to File.

Insert Multiple Page PDF File as a Text object.

The current version of the linked pdf file will be displayed.


Method 2 – Linking a Multiple Page PDF File with a Picture

Steps:

  • Go to Insert.
  • Click Illustrations and select Pictures. Link Multiple Page PDF File with a Picture
  • Choose an option. Here, Stock Images.
  • Insert a picture in the worksheet.

Link Multiple Page PDF File with a Picture

  • Right-click it.

Link Multiple Page PDF File with a Picture

  • Click Link.

  • Click as shown below to open the file explorer window.

Link Multiple Page PDF File with a Picture

  • Select All Files.
  • Choose the pdf file.

  • Click OK. The file is linked to the picture.

  • Hover your mouse pointer on the picture, to see the pdf link.
  • Click the picture to open the pdf file.

Link Multiple Page PDF File with a Picture

Read More: How to Attach Screenshot in Excel


Things to Remember

  • You must have PDF viewing software installed.

Download Practice Workbook

Download the practice workbook to exercise.


Related Articles


<< Go Back to Attach File in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo