View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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