Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Sort data with pictures in cells

There is already a post about this, but the advice didn't work for me.

I need to sort some data with pictures in some of the cells. I have made
sure the pictures can be "moved with cells", and the row height is enough to
include the whole picture in the cell.

But when I sort the data, the pictures remain static.

I can sort pictures perfectly in this way using Excel 2003, but not 2007.
Any other ideas?

Thanks very much.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default Sort data with pictures in cells

1) The sorting should work fine even with "2007" - as long as you keep the
pictures outer frame(s) away from the cells border(s) so they DO NOT(!) touch
each other.
2) You might consider to hold the pictures in cell "COMMENTS" instead of
inside cells.
This will also assure correct sorting of the data.
Micky


"Hobbes" wrote:

There is already a post about this, but the advice didn't work for me.

I need to sort some data with pictures in some of the cells. I have made
sure the pictures can be "moved with cells", and the row height is enough to
include the whole picture in the cell.

But when I sort the data, the pictures remain static.

I can sort pictures perfectly in this way using Excel 2003, but not 2007.
Any other ideas?

Thanks very much.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sort collumns and leave out pictures in rows not used? TobyS. Excel Worksheet Functions 0 March 11th 08 10:16 PM
how do I sort an excel list that includes pictures (name-picture) Angelke Excel Discussion (Misc queries) 1 January 29th 08 02:46 PM
Pictures don't move when I sort list Eric Excel Worksheet Functions 2 February 5th 07 06:58 AM
how do I sort, cut and copy pictures with cell? yellow submarine Excel Discussion (Misc queries) 1 December 31st 05 06:34 PM
Thumbnail pictures in cells don't sort with rest of row Don Excel Discussion (Misc queries) 3 February 26th 05 01:11 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"