Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I easily link a block of cells in one spreadsheet to anothe | Excel Discussion (Misc queries) | |||
Floating Cells | Excel Worksheet Functions | |||
FLOATING CELLS | New Users to Excel | |||
FLOATING CELLS | Excel Worksheet Functions | |||
floating cells | Excel Discussion (Misc queries) |