Excel 2003 - Problem With Freezing Panes And Comments

[Mattiekrome]

Hello, problem here and its driving me crazy!

I am building an excel spreadsheet that will be used to track attendance. I have dates along the top (columns), and names down the left side (rows). Both of these panes (Names + Dates) are frozen in place, this way I can scroll through the records and still see my column headings.

I have decided to start tracking minor amounts of additional information, so I have begun adding comments to some of my name entries (along the left side, column A). I can view the comment data as long as the first series of dates is viewable. It looks like the "frozen pane" is cutting my comment field in half, and whenever I scroll away from the first date it cuts some more of the data off, until eventually its nearly all gone (except for what is to the left of the "frozen pane" line.) Whew, thats hard to explain in words, so hopefully someone will get it.

Or maybe I'll just learn how to build something like this in Access :/

Thanks all!

 

[SkipVought]

Hi,

Make sure that ALL of your Comment Block is within the confines of COlumn A.

Skip,
[sub]
[red][/red]
[/sub]

 

[xlhelp]

What Skip suggests above works only if under Tools, Options, View, you have "Comments and Indicator" selected.

This is one of Excel annoyances.

Member- AAAA Association Against Acronym Abusers