Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
Cell comments and Terminal font: BIG problem | Excel Discussion (Misc queries) | |||
Comments | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |