Help with Excel

  sellewe 17:23 11 Oct 03

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.

  VoG II 17:25 11 Oct 03

Select a cell in the second row. Window/Freeze panes.

  sellewe 17:32 11 Oct 03

Thanks VoG, I worked a treat.

  Nosmas 17:39 11 Oct 03

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.

  daba 10:04 12 Oct 03

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

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This 2D animation about monsters is illustrated in a Van Gogh painterly style

How to get WWDC 2017 tickets