maharetr: Comic and movie images of Aisha's eyebrow ring (The Losers) (Default)
maharetr ([personal profile] maharetr) wrote2009-04-05 07:43 pm
  • Add Memory
  • Share This Entry
Entry tags:

Excel 2007 -- freezing panes

*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?
Threaded | Flat

[identity profile] stephbg.livejournal.com 2009-04-05 11:55 am (UTC)(link)
Is it not letting you drag the heavy horizontal separation line like you could in previous versions?

[identity profile] caitlen.livejournal.com 2009-04-05 12:47 pm (UTC)(link)
Yeah I can do that. Let me think though. Highlight the row that you want to freeze down from, and then select "Window, Freeze panes" and it should work.

[identity profile] callistra.livejournal.com 2009-04-05 01:03 pm (UTC)(link)
Cait has it mostly right. Click where you want the X and Y to meet, and then go Window, Freeze frame, and then you should be fine to zoom around with the X and Y sections remaining in place.
Threaded | Flat