#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Sorting with photos

I am using Excel 2000. I have a spread sheet of 10 columns one of which has
..jpg photos related to items that we wich to track.

When I try to sort the spread sheet by any column the photos end up as a
jumbled up mess and do not sort as do the other columns.

Is there a solution to this?

Thanks
Lewis


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Sorting with photos

XL sorts the cells. If you want the photos to sort properly you need to
ensure that each photo resides entirely in a single cell. If it spans
multiple cells then XL does not know where you would like the piture to land.
--
HTH...

Jim Thomlinson


"Lewis SHanks" wrote:

I am using Excel 2000. I have a spread sheet of 10 columns one of which has
..jpg photos related to items that we wich to track.

When I try to sort the spread sheet by any column the photos end up as a
jumbled up mess and do not sort as do the other columns.

Is there a solution to this?

Thanks
Lewis



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
Photos Sam Excel Worksheet Functions 1 July 9th 08 04:00 PM
Photos in cells? Ray[_5_] Excel Worksheet Functions 11 January 10th 08 12:49 AM
Photos quality? Karim Mounir Excel Discussion (Misc queries) 3 October 24th 07 12:21 AM
Embedding Photos John H Excel Discussion (Misc queries) 0 January 27th 07 12:43 AM
linking photos Smitty Links and Linking in Excel 1 July 28th 05 11:50 PM


All times are GMT +1. The time now is 04:14 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"