Floating block of cells at top of Spreadsheet

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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
 
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
 
Back
Top