Can I anchor pictures to specific cells in Excel?

N

nita

Can I anchor pictures to specific cells in Excel or do they just float about
on top of the page?
 
N

nita

Many thanks for your reply, Evan. I tried your suggestion and can see the
value in alt-dragging however, say I then wish to associate a picture with
other data in the same row, e.g like an image catalogue, do you know of a way
I can use the sort (or delete the row, even) and make the picture behave like
any other call in the same row?

Much appreciated.
 
G

Gord Dibben

The image will stay with the cell through sorting or filtering only if the image
is entirely within the cell and the image properties is set to "move and size
with cells"


Gord Dibben MS Excel MVP
 
N

nita

That's most helpful. Many thanks, Gord.

Gord Dibben said:
The image will stay with the cell through sorting or filtering only if the image
is entirely within the cell and the image properties is set to "move and size
with cells"


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can you anchor pictures to excel cells? 4
Help with Excel Hyperlinks macro? 6
How to fix the anchor point of a callout? 0
cursor is stuck 2
add hyperlink using sheet names and cells(i,j) 3
How to sort without including column headings in sort 4
Have a text box 'float' over a sheet 2
Sort messes up pictures 2

Top