Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do I associate an inserted picture with its row?

Hi! I'm using Excel for an inventory of images; I have each image inserted
into its own cell, and the count and sales in adjacent columns. When I sort
by the sales column, the images aren't moved with the rest of their row; it's
as if the image isn't really the contents of the cell - is that in fact the
case, and if so is there a way to associate an image w/ its cell so that
they'll move with the rest of their row under a sort operation? Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 118
Default how do I associate an inserted picture with its row?

You need to make sure that the row is "high" enough (row height) and the cell
is wide enough so that the image is contained completely in that cell. Then
put a "dummy" value in the cell like "0" and set the text color to white so
that you don't see the zero. Now when you sort your picture will move with
the row (if not, right click the image -- "Size and Properties" and on the
properties tab make sure one of the "Move with cells" options is selected).
--
If this helps, please click "Yes"
<<<<<<<<<<<<


" wrote:

Hi! I'm using Excel for an inventory of images; I have each image inserted
into its own cell, and the count and sales in adjacent columns. When I sort
by the sales column, the images aren't moved with the rest of their row; it's
as if the image isn't really the contents of the cell - is that in fact the
case, and if so is there a way to associate an image w/ its cell so that
they'll move with the rest of their row under a sort operation? Thanks!

Reply
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
Printing the inserted picture Wildan Excel Discussion (Misc queries) 0 December 13th 06 03:10 PM
display cells over an inserted picture display cells over a picture Excel Discussion (Misc queries) 0 October 25th 06 05:09 PM
associate picture files with names. Pic chgs when name is chgd Doyle Diener Excel Discussion (Misc queries) 2 June 21st 06 04:24 PM
picture 34 was inserted by excel? sophy2 Excel Discussion (Misc queries) 1 October 6th 05 02:23 PM
How to identify an inserted picture within a formula Jeff Melvaine Excel Discussion (Misc queries) 9 January 30th 05 01:02 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"