pdfpix

Insert a PDF into excel

Excel embeds a PDF as an object sitting on top of the sheet, not inside a cell. It opens when the reader double-clicks it, it travels with the workbook, and it makes the file as heavy as the PDF. There are two alternatives that behave better, and this guide covers all three.

What embedding does to a workbook

The PDF becomes an object floating above the grid, anchored near a cell rather than in it. Double-clicking opens it in the reader on that machine. Nothing about the PDF is converted and nothing of it appears in any cell.

The whole file is stored inside the workbook, so a heavy PDF makes a heavy spreadsheet. A few embedded scans turn a small sheet into something a mail server refuses, which is the complaint that usually brings people to this question.

Insert the file as an object

Look under the insert commands for the object control, and use its create from file tab. Microsoft moves the ribbon around between versions, so trust the control rather than a menu path written for a different release.

The dialogue offers a display as icon option, which is usually the right choice in a spreadsheet. A page preview stretched over the grid hides rows; an icon with a clear caption does not.

Link instead of embed

The same dialogue can link to the file rather than copy it in. The workbook stays small and the link opens the PDF from wherever it sits. It also breaks the moment the file moves, gets renamed, or reaches somebody who cannot see that folder.

Linking works inside a team with a shared drive and a stable folder structure. It does not survive being emailed, so if the workbook leaves your organisation, embed a copy or send the PDF alongside it.

Anchor it to a cell

An embedded object has properties controlling whether it moves and sizes with the cells underneath. Set it to move with cells and the icon follows its row when somebody sorts, filters or inserts rows above it.

Skip this and the object stays where it was dropped while the data moves underneath it, which quietly attaches the wrong document to the wrong row. On a sheet anybody else will sort, it is the step that matters most.

Page images in a sheet

If the point is to show what the PDF says rather than to attach it, insert pictures of the pages instead. The export tool renders the pages you pick as JPG or PNG at 96, 150 or 300 dots per inch, in your browser.

A picture sits on the sheet like any other image, and it prints. It is also not selectable text, so nothing in it can be searched or referenced by a formula. For a single certificate or receipt that is a fair trade.

What breaks when the workbook is shared

Embedded objects survive being emailed but not everything else. Opening the workbook in Google Sheets, in Excel for the web, or on a phone often shows a placeholder where the object should be, because those clients do not open embedded files.

Test the path the workbook will actually take. If it is going into a browser-based sheet or onto phones, a link in a cell is the only approach that works everywhere.

When a link is the better answer

A hyperlink in a cell pointing at a file on a shared drive or a document store keeps the workbook small, works in every client, and updates when the document is replaced. It needs the reader to have access, which is a permissions question rather than a file format one.

The link sharing guide covers the free places to put a file and what each one exposes. The Google Docs guide covers the same job outside Microsoft's software.

Questions people ask

Why does the embedded PDF show as an icon?
Excel stores the file as an object and draws either an icon or a picture of the first page, depending on the option chosen at insert time. Neither view scrolls. A reader who needs the rest of the pages has to open the object.
How do I insert a PDF into an Excel spreadsheet?
Use the insert object command and its create from file tab. The PDF becomes an object on top of the sheet, not inside a cell, and displaying it as an icon keeps it from covering rows.
Does an embedded PDF make the Excel file bigger?
Yes. The whole PDF is stored inside the workbook, so the spreadsheet grows by the size of every file you embed. A few embedded scans are enough to make it too heavy to email.
Why does my embedded PDF disappear when I share the workbook?
Browser-based and mobile spreadsheet apps often show a placeholder instead of an embedded object. If the workbook is going to those clients, put a hyperlink in a cell instead.
Can I make a PDF open from a cell?
A hyperlink in a cell does it, pointing at the file on a shared drive or a document store. The workbook stays small and every client understands a link.

Where to go next