Ok so I have some files in Excel. One of them is a list of books, made for a friend of mine.
The only problem is, he wants the cover of the book added too. I have some of them, but I haven't been able to add them to Excel.
Can you please tell me how to drag picture to Excel because I should finish this task pretty soon, and I have no idea how to make it work.
Any help would be appreciated.
Hi,
You can add an image on the cell containing title name of the book, when you hover over you can see the image you want to add with it.
1. Right-click on the cell you want to add the image click on insert comment
2. Right-click on shaded (grey area) on outside of comment box click on Format Comment
3. Click on the Colors and Lines tab
4. Click on Fill option and then Color
5. Fill Effects > Picture > (Browse to picture) > Click OK
Also please check the Lock picture aspect ratio checkbox.
Thanks
Hi John
To be able to insert images to excel you should click first add ins then a pop up will show, click settings, click set path, then choose a file folder where you have put the images then click insert images.
Now select a column where you want the images to be placed but before inserting the images adjust first the height of the rows and width of the columns. Then click insert, you may choose to insert one picture at a time or insert them all.
Â
