Fixed Heading

  • Thread starter Thread starter bombayterror
  • Start date Start date
B

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
 
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
 
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
 
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
 
Try clicking on cell d4 then go to Windows/Freeze Panes Is this what you
are trying to do?

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

Gord
 
Back
Top