freeze a column, but scroll up?

If freeze panes doesn't work then maybe Split would would.

http://www.bettersolutions.com/excel...E215138332.htm

If it doesn't reply with ranges you need to freeze

VBA Noob

Hi -- I really appreciate the quick response -- I tried that, and it still forces the scrolling in the opposite axis from the info. I'm trying to make it act like an electronic slide rule (that was the closest I could come up with) so like

http://tinyurl.com/33qbf7

where one line is fixed, but you can slide along that same direction. So top row fixed, second row slides horizontally -- or left column fixed, right column slides vertically. I could probably make one that is paper, but I'm thinking there has to be a way to do it electronically.

actually, like this: http://www.antiquark.com/sliderule/s...l-n909-es.html

but with dates and assignments, not actual math.

Sorry example didn't make sense to me. I need excel references as stated.

If you want to freeze Col A and Row 1 then select B2 and freeze panes. If it's not this then I don't think I can help as Freeze Panes and Split are all you can do without maybe doing some fancy VBA.

VBA Noob