ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I control the positioning of the Comments field? (https://www.excelbanter.com/excel-discussion-misc-queries/63971-how-can-i-control-positioning-comments-field.html)

GregRTI

How can I control the positioning of the Comments field?
 
I have a worksheet that contains lengthy comments that are used to describe
column headers. However when the comments fields display, they are often off
the page, or broken by the freeze window line. Is there a way to anchor the
comments field for each column so that it displays consistently each time?
Or is there a better way to do this?

Dave Peterson

How can I control the positioning of the Comments field?
 
I don't think you can really control them.

But Debra Dalgleish has a way to reposition them when they move where you don't
want them:

http://contextures.com/xlcomments03.html#Reset

GregRTI wrote:

I have a worksheet that contains lengthy comments that are used to describe
column headers. However when the comments fields display, they are often off
the page, or broken by the freeze window line. Is there a way to anchor the
comments field for each column so that it displays consistently each time?
Or is there a better way to do this?


--

Dave Peterson


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com