Drag and Drop files into an Excel Spreadsheet

Question

Is there a way to drag and drop NON Excel files to cells in an Excel sheet? I'm trying to manage PDF and/or JPG files in an excel spreadsheet.

You can insert Pictures into Excel via the Insert tab but you cannot insert a PDF file. What you can insert is the link to a file on your PC.

CharlieRB · Answer 1 · 2012-02-06 22:01:17Z

up vote 2 down vote

Welcome to Superuser. Unfortunately, Excel doesn't support what you described.

As a work around, you could use the HYPERLINK function to link to files. This will keep the workbook size manageable too.

The syntax is; HYPERLINK(link_location,friendly_name)

You can find more information about how to use it here.

answered Feb 6 at 22:01

CharlieRB
2,7991113

	Thanks for the ridiculously fast responses! Can you think of any other platform that would allow this file storage technique? – zat Feb 6 at 22:26
	What OS are you thinking of using? Windows or Linux, or Mac ? – Darius Feb 6 at 22:48
	It's not a spreadsheet but Evernote will let you organize pdf and jpg in a similar fashion. – Jesse Feb 7 at 0:42
	Microsoft OneNote "delivers the flexibility to gather and organize text, pictures, digital handwriting, audio and video recordings, and more — all in one digital notebook on your computer". – CharlieRB Feb 7 at 14:21
	I'm working from Windows '07. – zat Feb 7 at 15:52

feedback

1 Answer