Making first row Fixed/Static
 

Hi, I'm using Office XP. I have a long spread sheet in Excel having almost
1500 rows.

The first row is the Heading of every column, it's the name of every column.
When I scroll down the page the First row is also scrolled. But I want to see
the First row all the time when I'm working on the Excel sheet. So, how to
Fixed/make it Static?

What would be the changes in setting?

Making first row Fixed/Static
 

From Excel Help:
Freeze panes
Freezing panes allows you to select data that remains visible when scrolling
in a sheet. For example, keeping row and column labels visible as you
scroll.



1.. To freeze a pane, do one of the following:
The top horizontal pane Select the row below where you want the split
to appear.

The left vertical pane Select the column to the right of where you want
the split to appear.

Both the upper and left panes Click the cell below and to the right of
where you want the split to appear.

2.. On the Window menu, click Freeze Panes.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.




"anish11" wrote in message
...
Hi, I'm using Office XP. I have a long spread sheet in Excel having almost
1500 rows.

The first row is the Heading of every column, it's the name of every
column.
When I scroll down the page the First row is also scrolled. But I want to
see
the First row all the time when I'm working on the Excel sheet. So, how to
Fixed/make it Static?

What would be the changes in setting?

Making first row Fixed/Static
 

Sun, 1 Jul 2007 07:24:00 -0700 from anish11 <anish11
@discussions.microsoft.com:
Hi, I'm using Office XP. I have a long spread sheet in Excel having almost
1500 rows.

The first row is the Heading of every column, it's the name of every column.
When I scroll down the page the First row is also scrolled. But I want to see
the First row all the time when I'm working on the Excel sheet. So, how to
Fixed/make it Static?

Click in cell A2.

Window ... Split

The horizontal split should be just where you want it. There should
be no vertical split; but if there is, move it off the screen by
dragging it with your mouse.

Then
Window ... Freeze panes

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Making first row Fixed/Static
 

Select row 2, then Window/ Freeeze Panes.
--
David Biddulph

"anish11" wrote in message
...
Hi, I'm using Office XP. I have a long spread sheet in Excel having almost
1500 rows.

The first row is the Heading of every column, it's the name of every
column.
When I scroll down the page the First row is also scrolled. But I want to
see
the First row all the time when I'm working on the Excel sheet. So, how to
Fixed/make it Static?

What would be the changes in setting?