I have a sheet where I want the first four rows to be frozen and be able to scroll through the rest. There dowsn't appear to be a way of doing this in 2007 Excel - well, at learst I can't find it. I've tried view/freeze panes - no joy there.
Thanks VOG but that doesn't work I'm afraid. When I select view/freeze panes I get three items, "Unfreeze Panes", "Freeze To Row" and "Freeze First Column" With the cursor in A5 as I need and then select the middle item results in Row 1 being frozen only.