software

I was wondering is anyone can tell me to how to have a fixed header
row.

By that I mean, I have a pretty long spreadsheet. I want the first row
(row 1) that has my headers in it to remain fixed when I go down the
page. The rest of the rows (row 2 onwards) need to scroll down when I
move my scroll bar.

thanks--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=498573
How about Freezing the row.

Click the number 2 on the left, Make sure the row is highlighted then
go to Windows/Freeze Pane

Hope this helps

Larry--
keithl816
------------------------------------------------------------------------
keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=498573
thanks larry.... that's exactly what I needed.--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=498573
your welcome, glad to be able to help--
keithl816
------------------------------------------------------------------------
keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=498573Hi

the quot;featurequot; is called quot;freeze panesquot; and is found on the window menu.

Click in cell B1 choose window / freeze panes from the menu.
(to clear just choose window / unfreeze panes)
note - this does not affect how the spreadsheet prints (to print a header
row use file / page setup / sheet tab - rows to repeat at top).

--
Cheers
JulieDjulied_ng at hctsReMoVeThIs dot net dot auquot;bombayterrorquot; wrote:

gt;
gt; I was wondering is anyone can tell me to how to have a fixed header
gt; row.
gt;
gt; By that I mean, I have a pretty long spreadsheet. I want the first row
gt; (row 1) that has my headers in it to remain fixed when I go down the
gt; page. The rest of the rows (row 2 onwards) need to scroll down when I
gt; move my scroll bar.
gt;
gt; thanks
gt;
gt;
gt; --
gt; bombayterror
gt; ------------------------------------------------------------------------
gt; bombayterror's Profile: www.excelforum.com/member.php...oamp;userid=22855
gt; View this thread: www.excelforum.com/showthread...hreadid=498573
gt;
gt;

I'm having a similar problem.

I have a large spreadsheet, with multiple rows and columns, and I want to
freeze columns A,B and C along the horizontal plane, but not the vertical.
Conversely I want to freeze rows 1,2 and 3 vertically, but not horizontally.

Is this possible?

Gord

quot;keithl816quot; wrote:

gt;
gt; your welcome, glad to be able to help
gt;
gt;
gt; --
gt; keithl816
gt; ------------------------------------------------------------------------
gt; keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
gt; View this thread: www.excelforum.com/showthread...hreadid=498573
gt;
gt;


Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you
are trying to do?

Larry--
keithl816
------------------------------------------------------------------------
keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=498573I didn't realize that that function worked like that. Thanks, that's exactly
what I was trying to achieve.

Gord
quot;keithl816quot; wrote:

gt;
gt; Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you
gt; are trying to do?
gt;
gt; Larry
gt;
gt;
gt; --
gt; keithl816
gt; ------------------------------------------------------------------------
gt; keithl816's Profile: www.excelforum.com/member.php...oamp;userid=21287
gt; View this thread: www.excelforum.com/showthread...hreadid=498573
gt;
gt;