View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Title row to stay in place when scrolling down

What version of Excel are you using?

Let's assume you want row 1 to remain visible when you scroll.

Select cell A2

In Excel 2007 goto the View tabFreeze PanesFreeze Panes

In earlier versions of Excel goto the menu WindowFreeze Panes

--
Biff
Microsoft Excel MVP


"MS" wrote in message
...
I want to make the first few lines of my chart stay put when scrolling down
the page, for ex: in the excel template on Microsoft office called 'Loan
amortization Schedule', lines 1-17 stay put when scrolling down. Can
anybody
tell me how to do that?