Inserting a picture-using sort function

  • Thread starter Thread starter amast
  • Start date Start date
A

amast

How do I "tie" a picture to a cell so when I use a sort functions in another
column the picture will stay with the proper data?
 
As far as I know (which may not be very far):
- The picture must fit entirely within the cell. If it covers more than one
cell, it won't move when the cells are sorted.
- Right-click on the picture and select Format Picture. On the Properties
tab, click "Move but don't size with cells", then click OK.

Hope this helps,

Hutch
 
You got it spot on Tom.

"Must fit entirely within the cell"


Gord Dibben MS Excel MVP
 

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

Sorting Pictures 2
Sort messes up pictures 2
Sort data with pictures in cells 1
inserting clip art into cells 4
Using clips in Excel 3
Insert Picture into a cell 1
Grouping cell and picture?? 1
Sorting with pictures 5

Back
Top