insert picture to a specfic range of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i insert a picture to automatticaly go into a specific range of
cells every time. all the pictues will be the same resoulution.
 
There are ways to work with pictures in Excel, but a little more info would
be helpful.

Do you want an automatic method for those pictures to be selected or changed?
Will the pictures be stored in the workbook or are you hoping to retrieve
them from a network location?
Do you want the proces controlled by VBA or via formulas?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
When you insert a picture in Excel, the graphic will start in the active cell
on the active sheet and extend down and to the right according to the size of
the picture.

To change the size you can left-click and hold on any of the "sizing
handles" of the picture and and drag to resize it.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
the only thing that i want to be automatic is the placement of the picture,
like i want it to start at this cell and go to that one. what i am currently
doing is saying "insert" picture, so if that makes the file local to the
workbook then yes they will be local to the work book. i am not sure how to
awnser your last question. i am kind of new to excel.
 
yes, i know how to do that, i was wondering if i could put a formula in that
first cell that the picture starts from that will tell the photo where to
end, so i don't have to resize every photo i put in my report. it will
greatly reduce my time if i can have the photo automacially size to a
specific range of cells upon inseriton of the photo.

is this possible?
 
Still missing info, but based on what you've shared so far maybe this can work:

Check JE McGimpsey's excellent website:
http://www.mcgimpsey.com/excel/lookuppics.html

If you decide to use the VBA approach (highly recommended), just make sure
that the pictures in Excel are resized to the same dimensions. If you prefer
a non-VBA approach let us know.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
what i learned from that website was this:

"Since pictures in XL can't be placed in a cell, but rather float on top of
the sheet"

that is what i want to do, is place a pictue that spans from (for example)
E40 to Q61. it sounds like i can't do that. i don't really know anything
about VBA (i don't even know what that stands for)

cory
 
Ok, Cory

You now understand that you can't put a picture "in" a cell, but you can
place a picture over a cell, or cells, right? So, let's go from there.

For a non-VBA solution, see if this works for you:
Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture, put it in the sheet and
resize it).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant on cells A2:D10:
Select those cells
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.
If you need help: use Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
....or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
thank you for the extensive instructions, but i have no need for a pull down
situation that will change the picture. i just want one picture in one spot,
that will automatically size to a range of cells, and that picture has to
come from a jpg file not from another spot within the XL file. i have to try
to keep the file size down, my client is very specific about that.

from everything i have learned today, it seems to me the only way i can do
what i want to do is to manually scale each picture when i insert it.

thank you for trying.

Ron Coderre said:
Ok, Cory

You now understand that you can't put a picture "in" a cell, but you can
place a picture over a cell, or cells, right? So, let's go from there.

For a non-VBA solution, see if this works for you:
Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture, put it in the sheet and
resize it).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant on cells A2:D10:
Select those cells
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.
If you need help: use Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


CORY said:
what i learned from that website was this:

"Since pictures in XL can't be placed in a cell, but rather float on top of
the sheet"

that is what i want to do, is place a pictue that spans from (for example)
E40 to Q61. it sounds like i can't do that. i don't really know anything
about VBA (i don't even know what that stands for)

cory
Click to expand...
Click to expand...
 
Back
Top