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.
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;
You can find more information about how to use it here.
|show 1 more comment|
I realize this is an old post, but in case someone else gets here with the same question...
You cannot drag and drop, but you CAN do exactly what the OP is asking by inserting the files as objects within the spreadsheet.
Go to the "Insert" tab
Click "Object" in the "Text" group
In the resulting dialog box, click the "Create from File" tab
Check the box that says "Display as Icon"
Browse to the file you want and select it
"Okay" your way out
Now your file will be embedded in the Excel file as a clickable icon, and it will move with the cell you put it in if you reorganize the worksheet. This works with practically any type of file, including JPEGs and PDFs. However, embedding a large number of files can make your spreadsheet file size huge.
By default, the icon will show the entire path to the file in the icon label, which can make it unreadable. You can edit this to be shorter. While still in the dialog box noted above, click the "Change Icon" button, and you will have the opportunity to edit the label. I usually just cut out all the path information and leave the original file name so I can actually read it.
Hope this helps someone.