Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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 "CORY" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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 "CORY" wrote: 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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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? "Ron Coderre" wrote: 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 "CORY" wrote: 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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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 "CORY" wrote: 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? "Ron Coderre" wrote: 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 "CORY" wrote: 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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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 "Ron Coderre" wrote: 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 "CORY" wrote: 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? "Ron Coderre" wrote: 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 "CORY" wrote: 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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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 (ToolsOptionsView tab:Uncheck Grid Lines) 1)For each picture to be displayed: 1a. InsertPicture 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 InsertNameDefine 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: InsertNameDefine 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" wrote: 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 "Ron Coderre" wrote: 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 "CORY" wrote: 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? "Ron Coderre" wrote: 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 "CORY" wrote: 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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert picture to a specfic range of cells
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" wrote: 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 (ToolsOptionsView tab:Uncheck Grid Lines) 1)For each picture to be displayed: 1a. InsertPicture 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 InsertNameDefine 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: InsertNameDefine 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" wrote: 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 "Ron Coderre" wrote: 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 "CORY" wrote: 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? "Ron Coderre" wrote: 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 "CORY" wrote: 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. "Ron Coderre" wrote: 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 "CORY" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
how to format only specific characters or numbers within each cellwithin a range of cells | Excel Discussion (Misc queries) | |||
Count occurances in range of cells | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |