Floating block of cells at top of Spreadsheet

[Jim]

How do I make the first 10 rows float at the top of the spreadsheet float as
i scroll down the rows? I know it can be done, I have seen it before, Just
dont have a clue how to do it. thanks for the help

 

[DS-NTE]

Select A11, Window -> Freeze Panes

 

[Sandy Mann]

Select A11 and then select Window > freeze Panes

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Tom Hutchins]

Go to cell A1 (so all 10 top rows are visible). Now click on cell A11. Select
Freeze Panes from the Window menu.

Hope this helps,

Hutch