Open PDF from Excel

Add to Favorites
Author: | Edits: don

How to open a PDF file from a clickable button, link, or image in Excel.  This allows you to seamlessly link PDF files with a spreadsheet.

Sections:

Steps to Open PDF from Excel

Open a PDF when an Image or Button is Clicked

Notes

Steps to Open PDF from Excel

  1. Right-click the cell that contains the text that you want to use to open the PDF when it is clicked and then click Hyperlink
    5da6746b7c8e384ec01ac8ceb9023588.png
  2. Find the PDF on your computer and select it and then hit OK
    91bb799176a69504372c5c0bd0ff477c.png
  3. Click away from the cell by selecting another one and now any time you click the original cell, the PDF will open.
    2c10c9b7782dc087577a10e53e3944c1.png

Open a PDF when an Image or Button is Clicked

  1. Right-click the image or button and click Hyperlink
    3b99d0e8d2526f532f4f2dfbb9f931eb.png
  2. Find the PDF on your computer, select it, and hit OK.
    5446ac329f05473c919bd760d9aba5b6.png
  3. Select an empty cell and, now, any time you click that image, the PDF will open.
    27a9bb818f0f2d0a698975bc94251251.png

Notes

I find it nice to include and image and a text link for files like PDFs so that users know what kind of file they will open.

The process of linking to a PDF file from Excel is easy but the user must, of course, have a program that can open a PDF file already on their computer.

The link to the PDF in the attached spreadsheet for this tutorial might not work when you download it due to the fact that it was linked on my computer before being uploaded.  In that case, just follow the steps above to relink it on your computer and test it out.

Make sure to download the accompanying spreadsheet and PDF to test this out.


Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Send Email Invoices from Excel (in PDF format)
Tutorial: How to email your invoices from Excel with the click of a button. This method will export...
Open a Word Document from Excel
Macro: This Microsoft Excel macro will open a Microsoft Word document from excel. With this m...
Open a PowerPoint Presentation from Excel
Macro: This free macro for Microsoft Excel allows you to open any PowerPoint presentation fro...
Open any Program from Excel
Macro: This free excel macro allows you to open any program on your computer from excel. You...
Macro to Open a Website from Excel
Tutorial: How to open a website in the browser from Excel using a Macro and VBA. This is the same as...
Open Microsoft Outlook from Excel
Macro: This free macro will open the Microsoft Outlook program on your computer. You do need...
Tutorial Details
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course