With this time saving add-in you can easily insert pictures into Excel cells or comments, one by one or multiple at once. More info and free download at excel-image-ass...
Пікірлер: 25
@SigitaKliukas10 жыл бұрын
tried this : Don't know about tool but there is easy way to finish that: 1. In column A write the path to your images e.g. C:\images\ and copy down 2. In column B place your file names(with or without Excel Image Assistant) 3. In column C write file extension e.g. .jpg and also copy down 4. In column D write following formula =A1&B1&C1, formula result will be C:\images\file name.jpg and also copy down to suit your needs. 5 In column E place following formula =HYPERLINK(D1;B1) and also copy down. Enjoy :-) does not hyperlink... probably I need to buy exel for dummies :)
@XlsAddin10 жыл бұрын
There is no need to buy Excel for dummies :-) I'll mail you sample file where you can see formulas....
@XlsAddin11 жыл бұрын
Don't know about tool but there is easy way to finish that: 1. In column A write the path to your images e.g. C:\images\ and copy down 2. In column B place your file names(with or without Excel Image Assistant) 3. In column C write file extension e.g. .jpg and also copy down 4. In column D write following formula =A1&B1&C1, formula result will be C:\images\file name.jpg and also copy down to suit your needs. 5 In column E place following formula =HYPERLINK(D1;B1) and also copy down. Enjoy :-)
@dwhutchins193011 жыл бұрын
yes it is. In Excel 2011 for Mac: Insert New Comment, Format Comment, Colors & Lines, Color, Fill Effects, Picture, Select Picture. You may want to adjust the Size to keep Aspect Ratio of picture correct. Have fun!
@XlsAddin11 жыл бұрын
Yes sure, sorting will work fine in both cases(cells & comments)...Probably the best way to embed images with cells is to insert images into comments according to cell value(image file name) then you can sort it and filter it according to image name... If you insert images into cells sorting will work fine but please note, images are not treated as data in cells and beside images you'll need some data for proper sorting.
@XlsAddin11 жыл бұрын
Works fine with all versions from Excel 2000 to Excel 2013 32/64 bit.
@XlsAddin11 жыл бұрын
Easy: 1.Download Excel Image Assistant (you can find link on video description) 2.install 3.Start Excel & Excel Image Assistant and enjoy
@XlsAddin11 жыл бұрын
Download Excel Image Assistant, install and enjoy :-)
@patriciaocampo25739 жыл бұрын
Great!!! Thanks for sharing! :)
@Lgrayguthrie11 жыл бұрын
I am trying to create a mail merge using the inserted pictures but it wont' recognize them in the mail merge. Work around?
@XlsAddin11 жыл бұрын
Yes, sure.....no more switching between Excel and external picture viewer.
@maclaurin2111 жыл бұрын
Thank you very much! It is really useful :) Do you know if exists a similar tool to create hyperlinks automatically? For example a tool that create a link in every cell whose text is exactly the name of a file in the selected folder (obviously the hyperlink created refers this file). Thanks in advance!
@RatishTVOfficial11 жыл бұрын
i dont have "add-ins" to insert picture. what shall i do ???
@AashishOla11 жыл бұрын
I hope it works with Excel 2010 as well as Excel 2007
@XlsAddin11 жыл бұрын
Thank you :-)
@jacquelinefernandez330711 жыл бұрын
I tried several addins. The best part is its user friendliness
@drewbierut846911 жыл бұрын
is this possible on a mac?
@XlsAddin11 жыл бұрын
worth to check is Microsoft knowledge base article KB 909132
@XlsAddin11 жыл бұрын
Not yet :(
@sagasso10 жыл бұрын
Does it work for Excel for Mac 2011?
@XlsAddin10 жыл бұрын
Yes but not this video, please check my youtube channel for Mac version.