M
MS
Excel 2000.
A worksheet with names of people, and various data about them. Each row is a
record--the person's first name, last name, and various data, each column is
a field.
One column is labeled "Photo", and has a small photo of the person in it.
I notice that when I sort the rows, by data in one of the columns, such as
"first name", "last name", etc., the photos do not sort correctly with their
rows.
Why? Do photos just remember their place on the page, their cell position
(E7 or whatever), and not the row they are in, are not considered part of
the row's data? If so, any way to change that? A way to insert or format a
photo, so that it will move with its row, when the rows are sorted?
Has that problem been addressed in later versions of Excel?
Thank you for your help.
A worksheet with names of people, and various data about them. Each row is a
record--the person's first name, last name, and various data, each column is
a field.
One column is labeled "Photo", and has a small photo of the person in it.
I notice that when I sort the rows, by data in one of the columns, such as
"first name", "last name", etc., the photos do not sort correctly with their
rows.
Why? Do photos just remember their place on the page, their cell position
(E7 or whatever), and not the row they are in, are not considered part of
the row's data? If so, any way to change that? A way to insert or format a
photo, so that it will move with its row, when the rows are sorted?
Has that problem been addressed in later versions of Excel?
Thank you for your help.