Photo Directory in Excel
January 24, 2008 8:12 AM Subscribe
I'd like to create what amounts to a photo directory in Excel, and be able to sort by last name. Is this possible? If so, how?
I'm trying to create a document with names and photos of all the (50-ish) candidates we've interviewed for a number of positions. In the past I've done this in Word, which is fine for each of the nine interview days, but now I want to combine all of the folks into one document and be able to sort the list a couple different ways (by last name, interview date, etc.). I thought Excel would be great for this, but I can't seem to get it to make the photo the actual contents of a cell. It only places the photo on top of the spreadsheet.
Can anyone help? Oh, and I should mention that I'd like to be able to just copy and paste the photos in from the 9 word documents I have. I don't have them saved as individual files.