Excel 2007 -- freezing panes

[maharetr]

*resists the urge to scream with frustration* Can someone tell me how to freeze panes in Excel 2007? I've found the View -> Freeze Panes option, but that's only giving me top row/side/top and side. What I want to be able to do is freeze the top two rows. Any ideas?

Comments

[stephbg.livejournal.com]

Is it not letting you drag the heavy horizontal separation line like you could in previous versions?

[maharetr.livejournal.com]

I... didn't know previous versions did that. Cool. (My knowledge of excel is entirely based on isolated 'there's gotta be a way to do X...' rather than any systematic training). It doesn't appear to in 2007, but I shall totally remember that for 2003 when I go to work tomorrow ;)