Thank You very much.
You are very helpfull so i have second question.
I have few rows and each of them has different colour. And i often use
SORTING funtion. But the colours changes with the rows. And i want to sort
without changing the colours. How can i do that??
Użytkownik "David McRitchie" napisał w wiadomości
...
Not in Excel.
What is the purpose?
Are you going to look for a name then bring up the picture.
Or look at the picture and then look at the name.
Or do a "slide show".
family pictures,
company pictures,
mug shots (ceramics),
Sound like something for a database.
Are you trying to do a catalog,
some have done catalogs in Excel and in MS Word, but
pictures will not be in same place. Lots of overhead in Excel.
What you could do in Excel just have a link
and let Excel bring up your picture in Internet Explorer
or your default browser.
If you just want to look at all of the pictures, you could
use a program like IrfanView (irfanview.com) which is Free
the problem is to get the name onto the picture, which you
could do if you renamed the filename then that could be
displayed on the picture. If you had the information internal
to the pictures you could look at IPTC (and EXIF) data with
the information button.
in Excel you could generate a helper column
<br<a href="c:\family\pc022.jpg"Uncle Harry</a,
from
C1: '<html<body
A2: pc022
B2: 'Uncle Harry
C2: ="<br<a href=""c:\family\" & A2 & ".jpg""" & B2 & "</a"
...
C50: '</body</html
use column C as your HTML source
Tell us what you ended up doing, or what more help you need.
or same as above but bring up the picture from Excel
from same spreadsheet:
D2: =HYPERLINK("c:\family\" & A2 & ".jpg",b2)
or if you are going to see the name in another column anyway
you could use
D2: =HYPERLINK("c:\family\" & A2 & ".jpg", "[photo]")
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"grupy dyskusyjne" wrote in message
...
Hello
How can i make in excel link to a picture, but i need to open it in
excel,
not other graphic program.
For example, i have list of people, and i need to show their photos, when
i
click on first person i see its picture, second i see second picture but
in
the same place in excel.
I have excel 2002.
Sorry if something is difficult to understand, but i cant speak english
well.