Fixed Heading

[bombayterror]

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

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

thank

 

[keithl816]

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

 

[bombayterror]

thanks larry.... that's exactly what I needed.

 

[keithl816]

your welcome, glad to be able to help

 

[JulieD]

Hi

the "feature" is called "freeze panes" 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
JulieD


julied_ng at hctsReMoVeThIs dot net dot au

 

[Medicgord]

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

 

[keithl816]

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

Larry

 

[Medicgord]

I didn't realize that that function worked like that. Thanks, that's exactly
what I was trying to achieve.

Gord