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?
|