Floating block of cells at top of Spreadsheet
 

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

Floating block of cells at top of Spreadsheet
 

Select A11, Window - Freeze Panes
"Jim" skrev i melding
...
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

Floating block of cells at top of Spreadsheet
 

Select A11 and then select Window freeze Panes

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Jim" wrote in message
...
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

Floating block of cells at top of Spreadsheet
 

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

"Jim" wrote:

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