Freezing headers with Excel

[History Fan]

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-microsoft-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]

Save the workbook once

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

 

[History Fan]

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.