View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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