Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

Thanks for responding to my question.

I see what you're after, and I hadn't thought of it that way. In Excel's
"mind", the photos aren't what's important, it's their attributes that are.

If I understand you though, I won't be able to see the photos unless I mouse
over them, correct? If so, that would be a problem, as this human user needs
to be able to look at the results of the filter to make further evaluations.
:-)

Any other ideas?

Thanks again.

"CLR" wrote:

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

They could just draw the mouse down the photo column to show them one at a
time. Or, if the picture were contained completely within a cell, it will
sort with the row......but this makes for tiny pictures or fat rows......or,
if perhaps the attributes could also be coded in to the filename, then
sorting might could occur that way.

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Thanks for responding to my question.

I see what you're after, and I hadn't thought of it that way. In Excel's
"mind", the photos aren't what's important, it's their attributes that are.

If I understand you though, I won't be able to see the photos unless I mouse
over them, correct? If so, that would be a problem, as this human user needs
to be able to look at the results of the filter to make further evaluations.
:-)

Any other ideas?

Thanks again.

"CLR" wrote:

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

You're right about the fat rows, but that's no problem, since the most
important thing for us is to be able to see the photos.

I did take care to size all of the rows so that they were big enough to
contain the largest photo, which definitely helped with the sorting function,
but for some reason the photos still won't stay with their cells for the
Autofilter function. Wierd.

Anyway, I appreciate your thoughts.

Julie



"CLR" wrote:

They could just draw the mouse down the photo column to show them one at a
time. Or, if the picture were contained completely within a cell, it will
sort with the row......but this makes for tiny pictures or fat rows......or,
if perhaps the attributes could also be coded in to the filename, then
sorting might could occur that way.

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Thanks for responding to my question.

I see what you're after, and I hadn't thought of it that way. In Excel's
"mind", the photos aren't what's important, it's their attributes that are.

If I understand you though, I won't be able to see the photos unless I mouse
over them, correct? If so, that would be a problem, as this human user needs
to be able to look at the results of the filter to make further evaluations.
:-)

Any other ideas?

Thanks again.

"CLR" wrote:

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

ONly other ting I can think of is to use a rectangle drawing object inside
each cell and fill it with the picture........then it will follow the
Autofilter......

Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

You're right about the fat rows, but that's no problem, since the most
important thing for us is to be able to see the photos.

I did take care to size all of the rows so that they were big enough to
contain the largest photo, which definitely helped with the sorting function,
but for some reason the photos still won't stay with their cells for the
Autofilter function. Wierd.

Anyway, I appreciate your thoughts.

Julie



"CLR" wrote:

They could just draw the mouse down the photo column to show them one at a
time. Or, if the picture were contained completely within a cell, it will
sort with the row......but this makes for tiny pictures or fat rows......or,
if perhaps the attributes could also be coded in to the filename, then
sorting might could occur that way.

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Thanks for responding to my question.

I see what you're after, and I hadn't thought of it that way. In Excel's
"mind", the photos aren't what's important, it's their attributes that are.

If I understand you though, I won't be able to see the photos unless I mouse
over them, correct? If so, that would be a problem, as this human user needs
to be able to look at the results of the filter to make further evaluations.
:-)

Any other ideas?

Thanks again.

"CLR" wrote:

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

I just tried the rectangle idea. The only hitch is (there's always a hitch),
the photo now completely fills the rectangle, which makes all of the photos
look like they're the same size.

I know, picky, picky! :-)

I'll just keep plugging away, there's got to be a solution.

Julie


"CLR" wrote:

ONly other ting I can think of is to use a rectangle drawing object inside
each cell and fill it with the picture........then it will follow the
Autofilter......

Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

You're right about the fat rows, but that's no problem, since the most
important thing for us is to be able to see the photos.

I did take care to size all of the rows so that they were big enough to
contain the largest photo, which definitely helped with the sorting function,
but for some reason the photos still won't stay with their cells for the
Autofilter function. Wierd.

Anyway, I appreciate your thoughts.

Julie



"CLR" wrote:

They could just draw the mouse down the photo column to show them one at a
time. Or, if the picture were contained completely within a cell, it will
sort with the row......but this makes for tiny pictures or fat rows......or,
if perhaps the attributes could also be coded in to the filename, then
sorting might could occur that way.

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Thanks for responding to my question.

I see what you're after, and I hadn't thought of it that way. In Excel's
"mind", the photos aren't what's important, it's their attributes that are.

If I understand you though, I won't be able to see the photos unless I mouse
over them, correct? If so, that would be a problem, as this human user needs
to be able to look at the results of the filter to make further evaluations.
:-)

Any other ideas?

Thanks again.

"CLR" wrote:

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

Just figured out that I could specify the size of the rectangle to correspond
to the photo size. But you know what? The rectangles (filled with the
photos) STILL won't stay in their cells.

Hmmmm.

Unless you have a zillion different sizes, you could have a few different
size rectangles of purpotionate sizes and use the appropriate one in each
case..........other than that, I'm about outta gas.........

Vaya con Dios,
Chuck, CABGx3





"Julie" wrote:

I just tried the rectangle idea. The only hitch is (there's always a hitch),
the photo now completely fills the rectangle, which makes all of the photos
look like they're the same size.

I know, picky, picky! :-)

I'll just keep plugging away, there's got to be a solution.

Julie


"CLR" wrote:

ONly other ting I can think of is to use a rectangle drawing object inside
each cell and fill it with the picture........then it will follow the
Autofilter......

Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

You're right about the fat rows, but that's no problem, since the most
important thing for us is to be able to see the photos.

I did take care to size all of the rows so that they were big enough to
contain the largest photo, which definitely helped with the sorting function,
but for some reason the photos still won't stay with their cells for the
Autofilter function. Wierd.

Anyway, I appreciate your thoughts.

Julie



"CLR" wrote:

They could just draw the mouse down the photo column to show them one at a
time. Or, if the picture were contained completely within a cell, it will
sort with the row......but this makes for tiny pictures or fat rows......or,
if perhaps the attributes could also be coded in to the filename, then
sorting might could occur that way.

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Thanks for responding to my question.

I see what you're after, and I hadn't thought of it that way. In Excel's
"mind", the photos aren't what's important, it's their attributes that are.

If I understand you though, I won't be able to see the photos unless I mouse
over them, correct? If so, that would be a problem, as this human user needs
to be able to look at the results of the filter to make further evaluations.
:-)

Any other ideas?

Thanks again.

"CLR" wrote:

Personally, I would put the images into the comment boxes(which will pop-up
when moused over), in a column with a link in the cell to the actual file.
The links can be created easily with Jim Cone's fine add-in called
ListFiles.............both the links and the commentboxes will sort/filter
with the rows.....

hth
Vaya con Dios,
Chuck, CABGx3



"Julie" wrote:

Hi,

I'd very much appreciate any help anyone could offer....

I'm in the process of creating a worksheet with the goal of being able to
filter and sort several hundred of photographs based on their various
attributes (ie: size, vertical, horizontal, black & white, color, etc.).

For example, I'd like to be able to look at only the 4x6 photos, or only the
black and white photos, etc.

The problem is, when I apply the autofilter, the photos from the rows which
should not be displayed get all stacked on top of one another at the bottom
of the document.

For example, if I use auto filter to view all of the black and white photos,
the color photos appear in a "pile" at the bottom of the document.

Here's how the worksheet is layed out - each entry is in it's own cell:

photo 4x6 horizontal black and white
photo 3x5 horizontal black and white
photo 4x6 vertical color
photo 4x6 horizontal black and white


Any ideas? I'm running Windows XP Pro, Excel 2000.

Thanks so much,
Julie

They seem to do ok in my XL97.....just be sure they are really smaller than
the cell, not touching any edge..........

Vaya con Dios,
Chuck, CABGx3




"Julie" wrote:

Just figured out that I could specify the size of the rectangle to correspond
to the photo size. But you know what? The rectangles (filled with the
photos) STILL won't stay in their cells.

Hmmmm.

Yes, I did check to make sure they're smaller than the cell. It's really
very strange...

But I do thank you very much for your help.

Best regards,
Julie

"CLR" wrote:

They seem to do ok in my XL97.....just be sure they are really smaller than
the cell, not touching any edge..........

Vaya con Dios,
Chuck, CABGx3




"Julie" wrote:

Just figured out that I could specify the size of the rectangle to correspond
to the photo size. But you know what? The rectangles (filled with the
photos) STILL won't stay in their cells.

Hmmmm.

One more guess.

Right click on the picture.
Choose Format picture
Under the Properties tab, do you have "move and size with cells" checked?



Julie wrote:

Yes, I did check to make sure they're smaller than the cell. It's really
very strange...

But I do thank you very much for your help.

Best regards,
Julie

"CLR" wrote:

They seem to do ok in my XL97.....just be sure they are really smaller than
the cell, not touching any edge..........

Vaya con Dios,
Chuck, CABGx3




"Julie" wrote:

Just figured out that I could specify the size of the rectangle to correspond
to the photo size. But you know what? The rectangles (filled with the
photos) STILL won't stay in their cells.

Hmmmm.

--

Dave Peterson

Wow! You know, I had tried that at one point, but it must have been BEFORE
I made all the rows big enough to contain the largest photo. It seems I
neglected to try it again until now - and it worked! All of the photos are
the correct size and are moving with their cells. Hey thanks, you made my
day! :-)

Julie

"Dave Peterson" wrote:

One more guess.

Right click on the picture.
Choose Format picture
Under the Properties tab, do you have "move and size with cells" checked?



Julie wrote:

Yes, I did check to make sure they're smaller than the cell. It's really
very strange...

But I do thank you very much for your help.

Best regards,
Julie