Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
At the moment I have a sreadsheet with comments explaing columns headings.
However as the comment box always lies to the right of the cell, the comment boxes of my last 2 columns are not visible on the screen and one has to scroll to the right to read them. Is it not possible to have the comment box to the left? I have tried moving it, when hiding and unhiding it, but afterwards it always returns to the righ. Any help would be appreciated. |
#2
![]() |
|||
|
|||
![]()
I don't think we have any control over where the comment box appears on a
mouse over. As an alternative to cell comments you might try using the Input Message part of the Data Validation feature. Although we cannot control where that appears it doesn't matter as it is floats on top of the screen and is not blocked by window edges, etc. The cell does have to be selected however for the message to appear, but to me this is another plus. -- Jim "Frederic" wrote in message ... | At the moment I have a sreadsheet with comments explaing columns headings. | However as the comment box always lies to the right of the cell, the comment | boxes of my last 2 columns are not visible on the screen and one has to | scroll to the right to read them. | Is it not possible to have the comment box to the left? I have tried moving | it, when hiding and unhiding it, but afterwards it always returns to the | righ. | Any help would be appreciated. |
#3
![]() |
|||
|
|||
![]()
Debra Dalgleish has some code to put them back closer:
http://www.contextures.com/xlcomments03.html#Reset Frederic wrote: At the moment I have a sreadsheet with comments explaing columns headings. However as the comment box always lies to the right of the cell, the comment boxes of my last 2 columns are not visible on the screen and one has to scroll to the right to read them. Is it not possible to have the comment box to the left? I have tried moving it, when hiding and unhiding it, but afterwards it always returns to the righ. Any help would be appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
how to change default comment format in excel (2000) | Excel Discussion (Misc queries) | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
Comment position..?? | Excel Discussion (Misc queries) | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel |