| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a picture-using sort function
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting a picture-using sort function
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 "amast" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting a picture-using sort function
You got it spot on Tom.
"Must fit entirely within the cell" Gord Dibben MS Excel MVP On Tue, 1 Apr 2008 13:20:02 -0700, Tom Hutchins wrote: 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 "amast" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting picture to brochure | Excel Discussion (Misc queries) | |||
| Inserting a picture | Excel Discussion (Misc queries) | |||
| inserting a picture into a cell | Excel Discussion (Misc queries) | |||
| Inserting a picture | Excel Discussion (Misc queries) | |||
| Inserting Picture | New Users to Excel | |||
Linear Mode
