I am using Excel 97 and would like to keep the top line fixed so that as I type it is always visable no matter how far down I use the page. I know this is possible but could someone please tell me how to do this.
Do as VoG says, but bear in mind that when you click on Freeze Panes all ROWS ABOVE, AND all COLUMNS TO THE LEFT OF, the selected cell will be 'fixed'. So if you only want to 'fix' the top row and not any columns, you will need to select cell A2 before clicking on Freeze Panes.
If you make a mistake or want to change which rows/columns are 'fixed' just click on Unfreeze Panes, select another (suitably located) cell and click on Freeze Panes again.
....if your columns have 'titles' at the top, and you want to Print out the sheet, then you can 'Page Setup->Sheet' and set 'Rows to Repeat at Top' (or 'Columns to repeat at Left'), to your header rows.
That way when your printout goes over one page, the title rows get put on again automatically on every page.
This thread is now locked and can not be replied to.