Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments partially hidden due to "frozen" columns
I am using Excel 2007. I have "frozen" columns A thru C so they are always
visible when a user scrolls horizontally. I have also added Comments to several cells in column B. When a user hovers the mouse cursor over a cell containing a comment in column B, the comment always appears to the right beginning in column C (and extends sometimes into columns D & E). However, if a user has scrolled horizontally to column Z, for example, and then hovers the mouse cursor over a cell containing a comment in column B, the comment becomes partially hidden. Is this behavior "normal" or is there something I can do (without utilizing a macro) that will ensure the entire comment is visible even when a user has scrolled several columns horizontally to the right? Thanks in advance for any assistance. Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments partially hidden due to "frozen" columns
It is normal behaviour with Comments and Freeze Panes.
Annoying but normal. I do not know of a method......VBA or otherwise to overcome it. Gord Dibben MS Excel MVP On Sun, 13 Dec 2009 19:35:02 -0800, Bob wrote: I am using Excel 2007. I have "frozen" columns A thru C so they are always visible when a user scrolls horizontally. I have also added Comments to several cells in column B. When a user hovers the mouse cursor over a cell containing a comment in column B, the comment always appears to the right beginning in column C (and extends sometimes into columns D & E). However, if a user has scrolled horizontally to column Z, for example, and then hovers the mouse cursor over a cell containing a comment in column B, the comment becomes partially hidden. Is this behavior "normal" or is there something I can do (without utilizing a macro) that will ensure the entire comment is visible even when a user has scrolled several columns horizontally to the right? Thanks in advance for any assistance. Bob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments partially hidden due to "frozen" columns
Hi Gord,
Thanks for confirming my suspicion. Regards, Bob "Gord Dibben" wrote: It is normal behaviour with Comments and Freeze Panes. Annoying but normal. I do not know of a method......VBA or otherwise to overcome it. Gord Dibben MS Excel MVP On Sun, 13 Dec 2009 19:35:02 -0800, Bob wrote: I am using Excel 2007. I have "frozen" columns A thru C so they are always visible when a user scrolls horizontally. I have also added Comments to several cells in column B. When a user hovers the mouse cursor over a cell containing a comment in column B, the comment always appears to the right beginning in column C (and extends sometimes into columns D & E). However, if a user has scrolled horizontally to column Z, for example, and then hovers the mouse cursor over a cell containing a comment in column B, the comment becomes partially hidden. Is this behavior "normal" or is there something I can do (without utilizing a macro) that will ensure the entire comment is visible even when a user has scrolled several columns horizontally to the right? Thanks in advance for any assistance. Bob . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |