Explain how to drag picture to Excel please

Asked By John J Houston 30 points N/A Posted on - 08/18/2013

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.

• Status: Open
• Question Views: 824
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Kent Borland

Go To Solution

Best Answer

Best Answer

Answered By Kent Borland 0 points N/A #173806

Explain how to drag picture to Excel please

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

About Kent Borland

Questions
0

Answers
10

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/27/2013
• Question Category: MS Excel

Answered By Anica Macri 0 points N/A #173807

Explain how to drag picture to Excel please

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.

 

About Anica Macri

Questions
0

Answers
101

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/26/2013
• Question Category: MS Excel