Comments problem
 

I've created a number of comments. When I position the comments where I
want them, they only reflect their positions on "Show" or "Edit"
comment. All the comments default to the same relationship to the cells
when you pass over them. This is a problem because I've also used data
vaildation (with lists) on these cells and you can't display the
comment with the list pulled down at the same time because the comments
are tool close to the validated cell.

Thanks in adavance.

The comment usually appears to the right of the cell, and should still
allow you to see the data validation list. If it's covering the dropdown
arrow, you can press the Alt key, and down arrow key, to open the list.

wrote:
I've created a number of comments. When I position the comments where I
want them, they only reflect their positions on "Show" or "Edit"
comment. All the comments default to the same relationship to the cells
when you pass over them. This is a problem because I've also used data
vaildation (with lists) on these cells and you can't display the
comment with the list pulled down at the same time because the comments
are tool close to the validated cell.

Thanks in adavance.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra Dalgleish wrote:
The comment usually appears to the right of the cell, and should still
allow you to see the data validation list. If it's covering the dropdown
arrow, you can press the Alt key, and down arrow key, to open the list.

wrote:
I've created a number of comments. When I position the comments where I
want them, they only reflect their positions on "Show" or "Edit"
comment. All the comments default to the same relationship to the cells
when you pass over them. This is a problem because I've also used data
vaildation (with lists) on these cells and you can't display the
comment with the list pulled down at the same time because the comments
are tool close to the validated cell.

Thanks in adavance.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


Thanks for your help. This will work.

You're welcome. Thanks for letting me know that it will help.

wrote:

Debra Dalgleish wrote:

The comment usually appears to the right of the cell, and should still
allow you to see the data validation list. If it's covering the dropdown
arrow, you can press the Alt key, and down arrow key, to open the list.

wrote:

I've created a number of comments. When I position the comments where I
want them, they only reflect their positions on "Show" or "Edit"
comment. All the comments default to the same relationship to the cells
when you pass over them. This is a problem because I've also used data
vaildation (with lists) on these cells and you can't display the
comment with the list pulled down at the same time because the comments
are tool close to the validated cell.

Thanks in adavance.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Thanks for your help. This will work.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html