Making first row Fixed/Static

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 to expand...

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
 
Back
Top