How To Create A Header

[cassy01]

i want rows 1-4 to be my header so that when i scroll down rows 1-4 wil
still be the top rows on show ??

is this possible ???

many thank

 

[Frank Kabel]

Hi
move the cursor to cell A5 and goto Windows - Freeze Panes

 

[icestationzbra]

lets say you have your column header in A1, B1, C1 etc... and ro
headers in A2, A3, A4 etc... when you scroll, you would like to be abl
to freeze column A as well as the row 1 (first row and first column). i
this case, you would click on cell B2 and go over to Windows menu an
select Freeze Panes. you can do something similar for your requiremen
by selecting a cell in 5th row (you have not mentioned the column) an
freezing panes

 

[cassy01]

thats great thanks !!!

but now is it possible to have a Row 104 froze at the bottem of th
page ????

many thank

 

[RagDyeR]

Click in A5, then,
<Windows> <FreezePanes>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

i want rows 1-4 to be my header so that when i scroll down rows 1-4 will
still be the top rows on show ??

is this possible ???

many thanks

 

[RagDyeR]

Can't do that, but you can insert a row in your headers, at the top, and
copy, paste special, link, the row 104, so that it will display the exact
info at the top that's actually at the bottom.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

thats great thanks !!!

but now is it possible to have a Row 104 froze at the bottem of the
page ????

many thanks

 

[icestationzbra]

on one sheet, you can only have 1 instance of a frozen pane (as far as
know). so the answer to you question is, it is not possible to freez
panes again at row 104 once it has been frozen at row 5

 

[David McRitchie]

You can open another window (Window, New Window) then resize
and align the two windows above and below each other, you will
have to scroll them both to the right or left yourself.
http://www.mvps.org/dmcritchie/excel/freeze.htm#multiview