Keep Excel's headers visible (A,B,C,etc.) when scrolling. NOT FREEZE PANES?

[9tanstaafl9]

For some reason when I scroll down now, Excel's column headers (A, B, C, etc, not the ones I type in first row), disappear. This is highly annoying, and not just because I'm a tad OCD about my workspace. If I'm trying to type a formula, I have to scroll back to the top to see what column I am in.

It appears that what is happening is that the table headders are replacing Excel's normal column headers and staying in view. I assume this a FEATURE of Excel 2010? My question would be is there any way to turn it off? If I had wanted to keep the table headers in view I could have used freeze panes, why would they do this?

Thanks for any help!

 

[JoeMo]

It's a feature that started with the introduction of Tables in Excel 2007. You can defeat it by putting an empty row above your table's headers and freezing the top row.