I'm using Excel 2000 on a Windows XP SP2 computer. I have created a
simple spreadsheet, with lots of data regarding my exercise routine on a
treadmill. There are several headings at the top of the page, such as
minutes, miles, calories, and comments . So far, the spreadsheet is about 3
pages in length. How do I configure this Excel document so that those
headings are always at the top of the page, even if I'm on the 2nd or 3rd
page?
I did some searching on the Internet and came up with this:
<<This URL has a solution:
http://blog.taragana.com/index.php/archive/how-to-create-frozen-header-rows-in-m
icrosoft-excel/
And I found these steps: Highlight the row under the row that you want to
remain on top and go to Windows, Freeze Panes.>>
However, I cannot make this formatting PERMANENT. Everytime I reopen
the Excel spreadsheet, the frozen headers are unfrozen.
Niek Otten - 07 Oct 2006 17:53 GMT
Save the workbook once

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| I'm using Excel 2000 on a Windows XP SP2 computer. I have created a
| simple spreadsheet, with lots of data regarding my exercise routine on a
[quoted text clipped - 14 lines]
| However, I cannot make this formatting PERMANENT. Everytime I reopen
| the Excel spreadsheet, the frozen headers are unfrozen.
History Fan - 07 Oct 2006 18:57 GMT
> Save the workbook once
That was the trick. For some reason, Excel didn't prompt me to save the
changes after I froze a row and closed out the document. Doing so on my own
preserves the changes.