|
|
||||||
|
#1
10-07-06, 05:41 PM
|
|
|
|
|
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/a...crosoft-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. |
|
|
|
#2
10-07-06, 05:53 PM
|
|
|
|
|
Save the workbook once
|
|
#3
10-07-06, 06:57 PM
|
|
|
|
|
"Niek Otten" <nicolaus> wrote in message
news:4604 > 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. |
|
|
| Similar Threads | |
| Headers (or freezing rows) I have read the "help" section several times but am still not able to find out how I can freeze several opening lines at the top of a document as a header. I am sorry if I am... |
|
| Freezing headers and first column? Hi, I have a long and wide worksheet. I have frozen the header so that I can scroll down it and still see the headers but if I scroll sideways I lose sight of the first... |
|
| Freezing Datagrid Column Headers Hi, We have a datagrid with column headers. If the datagrid has more than say 25 rows the user needs to scroll down to be able to see the rest of the grid. When the user... |
|
| Freezing Columns, and Headers. Is there a grid control, or is it possible for Asp.Net to freeze the first column, and the headers where the headers would always display regardless of vertical scrolling? ... |
|
| Sql Reporting-Freezing the Headers Hi, Am creating reports using Sql Reporting Services. If the report has to be scrolled up and down, the column headers are also moving along with it. i need to freeze the... |
|
|
All times are GMT. The time now is 04:40 PM. | Privacy Policy
|
Freezing headers with Excel