Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add a small .gif in an Excel cell?
I'm trying to add a couple of small pictures in cells, but having no luck.
I want to have (for each song entry) a pdf picture that will link to a PDF file with lyrics and chords. And the same with another picture of a Word document that links to custom made lead sheets. The problem is that I can't put a picture inside a cell. This may not seem like a problem to most, but I'm using the AutoFilter function, and I want to be able to filter by whether an entry has the picture in the cell or not. If you can help me, that would be great! Thanks in advance for your time and efforts! ~JOSh-X |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add a small .gif in an Excel cell?
Put a character in the cell behind the .gif, and AutoFilter on that
character......if it's appearance offends you, change it's font color to the same as the background..........this works in XL2k, but for some reason I can't even put a .gif in XL97,,,,,too tired now to try any more tonight.....bedtime in St. Petersburg..... Vaya con Dios, Chuck, CABGx3 "~JOSh-X" wrote in message ... I'm trying to add a couple of small pictures in cells, but having no luck. I want to have (for each song entry) a pdf picture that will link to a PDF file with lyrics and chords. And the same with another picture of a Word document that links to custom made lead sheets. The problem is that I can't put a picture inside a cell. This may not seem like a problem to most, but I'm using the AutoFilter function, and I want to be able to filter by whether an entry has the picture in the cell or not. If you can help me, that would be great! Thanks in advance for your time and efforts! ~JOSh-X |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add a small .gif in an Excel cell?
But when I go to use the filter part, all the images just bunch up because
they're not actually attached to that cell, they just sorta float above the cell... At least, that's what's happening as best I can describe it... ~JOSh-X "CLR" wrote: Put a character in the cell behind the .gif, and AutoFilter on that character......if it's appearance offends you, change it's font color to the same as the background..........this works in XL2k, but for some reason I can't even put a .gif in XL97,,,,,too tired now to try any more tonight.....bedtime in St. Petersburg..... Vaya con Dios, Chuck, CABGx3 "~JOSh-X" wrote in message ... I'm trying to add a couple of small pictures in cells, but having no luck. I want to have (for each song entry) a pdf picture that will link to a PDF file with lyrics and chords. And the same with another picture of a Word document that links to custom made lead sheets. The problem is that I can't put a picture inside a cell. This may not seem like a problem to most, but I'm using the AutoFilter function, and I want to be able to filter by whether an entry has the picture in the cell or not. If you can help me, that would be great! Thanks in advance for your time and efforts! ~JOSh-X |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add a small .gif in an Excel cell?
Whick Version of Excel are you using?
I'll check it out again tonight.....in the mean time, check to be sure each image is smaller than the cell itself.... Vaya con Dios, Chuck, CABGx3 "~JOSh-X" wrote in message ... But when I go to use the filter part, all the images just bunch up because they're not actually attached to that cell, they just sorta float above the cell... At least, that's what's happening as best I can describe it... ~JOSh-X "CLR" wrote: Put a character in the cell behind the .gif, and AutoFilter on that character......if it's appearance offends you, change it's font color to the same as the background..........this works in XL2k, but for some reason I can't even put a .gif in XL97,,,,,too tired now to try any more tonight.....bedtime in St. Petersburg..... Vaya con Dios, Chuck, CABGx3 "~JOSh-X" wrote in message ... I'm trying to add a couple of small pictures in cells, but having no luck. I want to have (for each song entry) a pdf picture that will link to a file with lyrics and chords. And the same with another picture of a Word document that links to custom made lead sheets. The problem is that I can't put a picture inside a cell. This may not seem like a problem to most, but I'm using the AutoFilter function, and I want to be able to filter by whether an entry has the picture in the cell or not. If you can help me, that would be great! Thanks in advance for your time and efforts! ~JOSh-X |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add a small .gif in an Excel cell?
I checked it out in XL97 using .jpg's and the sorting feature works fine, (
based on a character or word in the cell in the background) as long as the picture is smaller than the cell and wholly contained therein. The picture just goes with the cell. That's the same way it worked with .gif's in XL2k.............if it's still not working for you, post back and we'll try to figure it out, or maybe someone else will have another idea........ Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Whick Version of Excel are you using? I'll check it out again tonight.....in the mean time, check to be sure each image is smaller than the cell itself.... Vaya con Dios, Chuck, CABGx3 "~JOSh-X" wrote in message ... But when I go to use the filter part, all the images just bunch up because they're not actually attached to that cell, they just sorta float above the cell... At least, that's what's happening as best I can describe it... ~JOSh-X "CLR" wrote: Put a character in the cell behind the .gif, and AutoFilter on that character......if it's appearance offends you, change it's font color to the same as the background..........this works in XL2k, but for some reason I can't even put a .gif in XL97,,,,,too tired now to try any more tonight.....bedtime in St. Petersburg..... Vaya con Dios, Chuck, CABGx3 "~JOSh-X" wrote in message ... I'm trying to add a couple of small pictures in cells, but having no luck. I want to have (for each song entry) a pdf picture that will link to a file with lyrics and chords. And the same with another picture of a Word document that links to custom made lead sheets. The problem is that I can't put a picture inside a cell. This may not seem like a problem to most, but I'm using the AutoFilter function, and I want to be able to filter by whether an entry has the picture in the cell or not. If you can help me, that would be great! Thanks in advance for your time and efforts! ~JOSh-X |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |