Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two problems sorting a database containing pictures
I seem to have solved one problem.
I had the pictures exactly the same size as the size of the cells they occupied, locking them to the cell boundaries by resizing using the Alt key. If the pictures are resized, so that there's some white space all around the picture, the sorting works OK. Don't ask me how or why this works, I don't have a clue! :-) "Peter Rooney" wrote: Good morning, all - hope someone can help. I have a product database in B7:L46 with headers in row 6. Column B contains the Product ID and Column D contains a picture of each product. The pictures are formatted to "Move and Size with cells". When I click on B7 (the first field Header - Product ID) and do Data Sort, the sort highlight only goes as far as column I, even though the database follows the normal rule of no blank columns and field headers for each column, with the whole database bordered by empty rows and columns. THEN (as if it couldn't get any worse), if I do a GoTo or select the data manually, then sort, all columns are correctly included in the sort highlight, but when I sort on column B (Product ID), the pictures in column D stay where they are, instead of being sorted with their respective rows. I'm not sure if the two problems are related in any way, but I'd really appreciate some advice as to what's causing either, or preferably both of them. As always, thanks in advance for your interest and help Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Problems | Excel Discussion (Misc queries) | |||
Inserting pictures then sorting | Excel Discussion (Misc queries) | |||
how do I embed/Link pictures onto excel database cells? | Excel Discussion (Misc queries) | |||
Excel as a database and sorting information | Excel Discussion (Misc queries) | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) |