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 make JUST the header row always visible in Excel?

I'm trying to manipulate data in a very large spreadsheet and need to keep
just the header row visible at all times while scrolling. The freeze option
freezes too many rows at one time. Can I adjust that somehow to freeze one
row and one column?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default How do I make JUST the header row always visible in Excel?

Click on cell B2. Then Freeze Panes.

Regards,
Paul

"t.261" wrote in message
...
I'm trying to manipulate data in a very large spreadsheet and need to keep
just the header row visible at all times while scrolling. The freeze
option
freezes too many rows at one time. Can I adjust that somehow to freeze
one
row and one column?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I make JUST the header row always visible in Excel?

The rule for freezing rows and columns is...........

Rows and columns above and left of the selected cell will be frozen.

Select B2 then WindowFreeze Panes.

Row 1 and Column A will be frozen.

If you select A1 then the freeze line will be at mid-window.


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 09:04:01 -0800, t.261
wrote:

I'm trying to manipulate data in a very large spreadsheet and need to keep
just the header row visible at all times while scrolling. The freeze option
freezes too many rows at one time. Can I adjust that somehow to freeze one
row and one column?


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
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Sort does not recognize the header row Notbefore10 New Users to Excel 4 October 25th 06 02:27 AM
Can I use a header or footer more than 255 characters in Excel? Jin Qingfeng Excel Discussion (Misc queries) 1 December 15th 05 01:07 PM
Can I use a header or footer more than 255 characters in Excel? Jin Qingfeng Excel Worksheet Functions 0 December 15th 05 03:22 AM
Default header in Excel under page set-up Melanie Excel Discussion (Misc queries) 2 December 15th 04 02:37 AM


All times are GMT +1. The time now is 09:55 AM.

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

About Us

"It's about Microsoft Excel"