How do I freeze a row other than the top one? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
  
 
 
 
AnneG 4/19/2007 11:24 AM PST
  Question
  My column headers are rarely in the top row of a spreadsheet. How do I
freeze the header row so that I can still see it as I scroll down the page?
This seems to have changed in Excel 2007.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
PCLIVE 4/19/2007 12:00 PM PST
  Answer
  Click on the row below the one that you want to remain visible. Then Freeze
Panes from the 'Window' menu.

HTH,
Paul

"AnneG" <AnneG@discussions.microsoft.com> wrote in message
news:5F274A85-D850-4D35-AB4C-110E9FC151AD@microsoft.com...
> My column headers are rarely in the top row of a spreadsheet. How do I
> freeze the header row so that I can still see it as I scroll down the
> page?
> This seems to have changed in Excel 2007.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies