Last updated on November 6th, 2026 at 12:49 pm
When each spreadsheet row belongs to a PDF (an invoice, a contract, a spec sheet), link it: select the cell, press Ctrl+K (or Insert > Link), pick the PDF and select OK. Embed with Insert > Object only when the PDF must travel inside the workbook. The one catch: links break if the PDF is moved or renamed.
Applies to: Excel for Microsoft 365, 2024, 2021, 2019 and 2016 on Windows. Mac and web notes are further down.
Link, embed or formula: pick one first
All three approaches put something clickable in the sheet, but they behave very differently once the workbook is saved, moved or shared. Decide before you start, because switching later means redoing every row.
| What you need | Hyperlink (Ctrl+K) | Embedded object | HYPERLINK formula |
|---|---|---|---|
| Workbook size | Stays small | Grows, because a copy of each PDF is stored inside | Stays small |
| Shows the newest version of the PDF | Yes, it opens the file where it lives | No, it opens the copy you inserted (unless you tick Link to file) | Yes |
| Survives the PDF being moved | No | Yes, the copy is inside the workbook | No, but you can fix every link by changing one folder cell |
| Works when you email the workbook | Only if the recipient can reach the PDF’s location | Yes | Only if the recipient can reach the location |
| Excel for the web | Use web addresses (OneDrive, SharePoint); a file on your PC can’t be reached from the browser | You can’t insert objects there | Web addresses only |
| Best for | A handful of PDFs in a shared folder or OneDrive | One or two PDFs that must go wherever the workbook goes | Dozens or hundreds of PDFs with predictable file names |
A quick rule: if the PDFs already sit in a folder everyone can open, link them. If the workbook is going to a client who has no access to your files, embed. If you have a column of invoice numbers and a folder of matching PDFs, use the formula.
Link a PDF to a cell with Insert > Link
This is the method Microsoft describes in Work with links in Excel, and it suits most people.
- Select the cell that should hold the link, for example the cell next to an invoice number.
- Press Ctrl+K. You can also go to Insert > Link, or right-click the cell and choose Link.
- Under Link to, select Existing File or Web Page.
- Find the PDF with Current Folder or Recent Files, or paste a full path or web address into the Address box.
- In Text to display, type what the cell should say, such as “Invoice 1042 (PDF)”. If you leave it blank, Excel shows the address instead.
- Optionally select ScreenTip and add a short note that appears when someone hovers over the link, like “Signed copy, March”.
- Select OK. The text turns blue and underlined. Click it once to open the PDF in your default PDF app.
To select a link cell without opening the PDF, click and hold until the pointer changes, or select a neighboring cell and use the arrow keys. To change the target later, select the cell and press Ctrl+K (or right-click it and choose Edit Link). To turn the link off but keep the text, right-click the cell and choose Remove Link.
A link normally fills the whole cell. If you want a sentence where only part of it points to the PDF, see how to put a hyperlink in an Excel cell with other text. In Word and Outlook the same Ctrl+K box works on a selection instead, so you can turn a single word into a link inside a paragraph.
Keep PDF links from breaking
A link is only a pointer to a location. Most “my links stopped working” problems come from one of these situations, and each has a simple habit that prevents it.
- The PDF was renamed or moved. Decide on a final folder and file name before you link. If you must reorganize, update the links afterward (or use the formula method, where one cell holds the folder).
- The PDF is on your C: drive and someone else opens the workbook. Their PC has no such file. Store shared PDFs on a network share (a path that starts with two backslashes, like \\fileserver\finance) or in OneDrive or SharePoint and link to that address. Excel’s HYPERLINK documentation lists local paths, network (UNC) paths and web addresses as valid targets.
- The workbook and PDFs moved together. Keeping the workbook and its PDFs in one folder (or the PDFs in a subfolder beside it) gives the links the best chance of surviving a move, because Excel can store those links relative to the workbook’s location. This depends on how and where the file was saved, so test a link after any move. By default, Excel treats paths without a full address as relative to the workbook; the Hyperlink base under File > Info > Properties > Advanced Properties changes that.
- The cloud link needs permission. A OneDrive or SharePoint address only opens for people the file’s or folder’s sharing settings allow. Check those settings before you send the workbook.
A good check before sending: open the workbook on a second PC or ask a colleague to click two or three links. It takes a minute and catches path problems you can’t see from your own machine.
Embed the PDF as an icon with Insert > Object
Embedding stores a copy of the PDF inside the workbook and shows it as an icon on the sheet. Microsoft covers the dialog in Insert an object in your Excel spreadsheet.
Before you start: Microsoft notes that inserting an object turns off AutoSave for that workbook. Save manually (Ctrl+S) after embedding, especially if the file lives in OneDrive and others edit it.
- Select the cell where the icon should appear. The icon floats over the sheet with its top-left corner at that cell.
- Go to Insert and, in the Text group, select Object.
- Open the Create from File tab and select Browse. Pick the PDF.
- Tick Display as icon. Without it, Excel shows the first page of the PDF on the sheet instead of an icon.
- Leave Link to file unticked if you want a true copy inside the workbook. Tick it if you want the icon to open the original file instead.
- Select OK. Double-click the icon to open the PDF in your PDF app.
What Link to file changes: with it ticked, the icon opens the latest version of the original PDF, and Microsoft points out the connection breaks if that file is moved. Microsoft suggests keeping linked originals somewhere stable, like a SharePoint site or a network drive. In other words, a linked object has the same weakness as a hyperlink, just with an icon instead of blue text.
Keep the icon with its row. Icons don’t belong to a cell, so sorting or filtering can leave them stranded next to the wrong row. Right-click the icon, choose Format Object, open the Properties tab and select Move and size with cells (or Move but don’t size with cells if you want the icon to keep its size).
Change the icon or its label. When Display as icon is ticked, the Object dialog usually shows a Change Icon button where you can edit the caption under the icon, for example “Contract (signed)”.
Each embedded PDF adds its own copy to the workbook, so ten 3 MB scans make a noticeably heavier file to email and open. The same Insert > Object steps work for other documents, and you can embed a Word document in Excel the same way.
Build a column of PDF links with the HYPERLINK function
Clicking through the Link dialog 200 times isn’t practical. The HYPERLINK function builds a link from text, so one formula copied down a column handles every row. Its syntax is HYPERLINK(link_location, [friendly_name]).
Worked example. Priya keeps supplier invoices in a folder, each named after its invoice number (INV-1042.pdf, INV-1043.pdf and so on). Column A of her sheet lists those numbers. She puts the folder path in cell E1, ending with a backslash:
\\fileserver\finance\invoices\
Then in B2 she enters this formula and fills it down:
=HYPERLINK($E$1&A2&".pdf","Open "&A2)
Each cell in column B now reads “Open INV-1042” and opens the matching PDF. The $E$1 reference is the useful part: when the folder moves, she changes one cell and every link updates.
Things to get right with this method:
- File names must match exactly, including spaces and the .pdf extension. A trailing space in column A is enough to break a link. If the names already include “.pdf”, drop the &”.pdf” part.
- A wrong path doesn’t show an error in the cell. The formula still displays its text; Excel only complains when you click a link it can’t follow. Test a few rows from the top, middle and bottom.
- Web addresses work too. Put a OneDrive or SharePoint folder address in E1 instead of a network path. That is also the only kind of target the function supports in Excel for the web, according to Microsoft.
- Typing the names is the slow part. On recent versions of File Explorer you can select the files, right-click and choose Copy as path (on Windows 10, hold Shift while right-clicking), then paste into column A. Each pasted line includes the folder, quotation marks and the .pdf extension, so remove the folder and the quotes with Find and Replace and drop the &”.pdf” part of the formula.
Excel for Mac and Excel for the web
Microsoft’s link and object pages describe the Windows app, so check these against your version.
- Excel for Mac, link: select the cell, go to Insert > Link, choose Web Page or File, use Select to pick the PDF and select OK. Links to files in your Mac’s folders won’t open for Windows users, so use OneDrive or SharePoint for shared workbooks.
- Excel for Mac, embed: Microsoft doesn’t document embedding PDFs in Excel for Mac, and results vary by version, so a link is the safer choice, especially in offices that mix Mac and Windows.
- Excel for the web: you can add links with Insert > Link, but they need a web address. Microsoft says embedding and linking objects isn’t available in the Office Online apps, and HYPERLINK formulas only work with URLs there. For browser users, upload the PDFs to OneDrive or SharePoint and link those addresses.
When the link or icon won’t open
Excel says it can’t open the specified file
Excel followed the path and found nothing. The PDF was moved or renamed, the drive letter differs on this PC, or the network share isn’t connected. Press Ctrl+K on the cell and browse to the file again, or fix the folder cell if you used the formula.
A warning says links can be harmful
Office may show a security prompt the first time you open a file through a link. If you know where the PDF came from, continue. If you don’t recognize the location, cancel and check the path in the Ctrl+K dialog before opening anything.
Object is greyed out
Likely causes: you’re still editing a cell (press Enter or Esc first), the sheet is protected (go to Review > Unprotect Sheet if you have the password), or you’re in Excel for the web, which doesn’t offer objects. Open the file in the desktop app instead.
The PDF opens in the wrong app
Excel hands the file to whichever app Windows uses for PDFs, often Microsoft Edge. To use a different reader, change the default PDF viewer in Windows 11.
The embedded icon won’t insert
Some protected or password-secured PDFs may not embed, and a very large scan can slow the workbook badly. Link to that file instead, or ask the sender for an unsecured copy.
Questions people ask about PDFs in Excel
Can I show the PDF’s tables inside the cells instead?
Not with a link or an object; both only open the PDF. To pull its data into rows and columns, import it with Data > Get Data > From File > From PDF in Excel for Microsoft 365. The walkthrough on how to convert a PDF to Excel without losing formatting covers that route.
Will the links still work after I share the workbook?
Only if the people you share with can reach the PDFs. Put the workbook and PDFs in the same OneDrive or SharePoint folder and share the folder, then share the Excel file as a link rather than as an attachment.
Does an embedded PDF update when the original changes?
No. An embedded copy is frozen at the moment you inserted it. If the original keeps changing, tick Link to file when inserting or use a hyperlink instead.
Can I print the PDF with the sheet?
Printing the sheet prints only what the sheet shows: the link text, the icon, or the first-page view of an embedded PDF, never the whole document. Open the PDF and print it separately, or insert a picture of the page if it really must appear on the printout.
Which is better for a client handover?
If the client can’t reach your folders, embed the few PDFs they need and send one file. If you share a cloud folder with them, links keep the workbook small and always point to the current documents.
Once the PDFs are sorted, the same link and embed ideas carry across Office. You can link Excel to Word so a report updates with the sheet, or insert a PDF into Word when the document needs it.

Matt Jacobs writes and maintains the guides on Support Your Tech, which he started in 2017. He spent most of his career keeping small-business PCs running and still takes the occasional consulting job, so the steps here come from fixing the same problems on other people’s computers. Every guide is checked on his own Windows 11, Windows 10, Mac, iPhone and iPad before it goes up.