Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frederic
 
Posts: n/a
Default How to change the position of a comment box

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   Report Post  
Jim Rech
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell comment boxes shouldn't change size/shape unless changed by u sam Excel Discussion (Misc queries) 1 March 3rd 05 05:23 PM
how to change default comment format in excel (2000) superiorparties Excel Discussion (Misc queries) 1 February 3rd 05 12:43 AM
Where to stick macro to change default comment font? [email protected] Excel Discussion (Misc queries) 1 January 1st 05 12:57 AM
Comment position..?? RJH Excel Discussion (Misc queries) 1 December 29th 04 04:00 PM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 2 December 24th 04 12:51 PM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"