LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
ISUTUBBS
 
Posts: n/a
Default

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



 
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
macro help thephoenix12 Excel Discussion (Misc queries) 4 July 15th 05 05:57 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 11:22 AM.

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"