Thanks for that - have tried this but it just gives me a blank worksheet with
no undo option!!

"Dave O" wrote:

Place the cell pointer on the cell that will act as the intersection of
the rows and or columns you want to remain visible, then click Windows
Freeze panes. This may take some experimentation until you get it exactly right.