Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pictures in a cell.
I've read on this board that you can only insert pictures into a sheet, not a
cell as cells can only have text or formula. Is there any way to insert a picture and associate it with a row of data such that if the data rows are sorted, the pictures sort with it? I can do this in Word tables, but want to use some of the features of Excel in what I'm doing. Kind Regards |
#2
|
|||
|
|||
The only workaround I can think of is to add the picture as a fill effect in
the comment for the cell in question. The picture would be visible when you mouse over the cell or all the time if set comments to always be visible under Tools, Options, View. To add a picture to a cell comment: - Create a comment for the cell (Shift-F2 is the shortcut) - Clear the default text that appears in the comment - Right click the comment border and pick Format Comment - Select the "Colors and Lines" tab - In the Fill section open the Color drop down and pick Fill Effects. - Click the Picture tab and select the picture file. -- Jim "ISUTUBBS" wrote in message ... | I've read on this board that you can only insert pictures into a sheet, not a | cell as cells can only have text or formula. Is there any way to insert a | picture and associate it with a row of data such that if the data rows are | sorted, the pictures sort with it? | | I can do this in Word tables, but want to use some of the features of Excel | in what I'm doing. | | Kind Regards |
#3
|
|||
|
|||
Jim,
Awesome! I very cleaver approach that will work for me. Thanks! "Jim Rech" wrote: The only workaround I can think of is to add the picture as a fill effect in the comment for the cell in question. The picture would be visible when you mouse over the cell or all the time if set comments to always be visible under Tools, Options, View. To add a picture to a cell comment: - Create a comment for the cell (Shift-F2 is the shortcut) - Clear the default text that appears in the comment - Right click the comment border and pick Format Comment - Select the "Colors and Lines" tab - In the Fill section open the Color drop down and pick Fill Effects. - Click the Picture tab and select the picture file. -- Jim "ISUTUBBS" wrote in message ... | I've read on this board that you can only insert pictures into a sheet, not a | cell as cells can only have text or formula. Is there any way to insert a | picture and associate it with a row of data such that if the data rows are | sorted, the pictures sort with it? | | I can do this in Word tables, but want to use some of the features of Excel | in what I'm doing. | | Kind Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro help | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |