Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I freeze a row other than the top one?

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default How do I freeze a row other than the top one?

Click on the row below the one that you want to remain visible. Then Freeze
Panes from the 'Window' menu.

HTH,
Paul

"AnneG" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 freeze panes won't freeze top row only macbone2002 Excel Discussion (Misc queries) 3 April 22nd 23 02:07 AM
FREEZE PANES Lucy Excel Discussion (Misc queries) 3 May 30th 06 01:16 PM
freeze content jiang Excel Worksheet Functions 0 September 16th 05 12:47 PM
how to freeze only one row huggybear Excel Discussion (Misc queries) 2 June 21st 05 06:51 PM
Id like to freeze the first row for headers and freeze the very b. Bill Charts and Charting in Excel 2 December 17th 04 09:13 PM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"