displaying comments

[HGood]

Is there any way to force comments to appear where I want them to appear
instead of where Excel thinks they should appear. I want them displayed only
when the cursor moves over them.

Excel seems to always display comments to the right of the cell, but if the
cell is on the right side of the spreadsheet, displaying it to the right may
put half of it beyond the visible screen to the right. How can I force
comments to display on the left of the cell so the users won't need to
scroll right to read the comment?

Thanks,

Harold

 

[David McRitchie]

There is no way to force cell comments to appear anywhere. You can
move them around but that is only temporary. You might get something
a bit more to your liking with a cell validation comment, but that requires you to
go into input mode. You could use a Text Box to place something in
a permantly visible location.

 

[Debra Dalgleish]

You can't change the popup location of a cell's comment. You could use
programming to show a cell's comment near the centre of the screen, when
the cell is selected.