Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Freezing headers with Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
History Fan - 07 Oct 2006 17:41 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.