Title row to stay in place when scrolling down

M

MS

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

T. Valko

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 tab>Freeze Panes>Freeze Panes

In earlier versions of Excel goto the menu Window>Freeze Panes
 
T

tompl

Select the cell just below the title area (e.g. cell A3). Then on the menu
select Window then Freeze Panes. That should do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top