Tables in Excel

[sarahbowen82]

Hi, Can anyone tell me how to fix headers on the top of a table in Exel, so that when you scroll down you can still see the headers and what the columns relate to?

Thanks

[stevie21]

Click on any cell one line below your headings and choose
"Window > Freeze Panes"

[Hammer]

Or highlight the entire row below your heading and do the same. This is almost the same as Stevie's but this way you won't freeze the left side of your screen. Try it and you'll see what I mean

[brachiopod]

Ok, does anyone know how to freeze the column headers and, say, a 'Totals' row, that is 150 rows below the headers, so that when you scroll you just scroll between these rows (ie header stays at the top and the 'totals' stays in view at the bottom).

I used to be able to do it with Office 98, but they've upgraded to Office XP and I can't seem to do it now.

[stevie21]

I've just figured out what Hammer means although it took my brain a while.

If you click ANY cell on the row below then everything above that cell counts as a heading when you scroll down AND everything to the left of it acts in a similar fashion when you scroll to the right.
If you either click the furthest left cell under your heading (or even the beige number at the far left which highlights the entire row) then when you scroll from left to right, there isn't a *column* which is "frozen"

Hammer? Is that what you mean?
Thanks for the tip : I didn't know this.

[stevie21]

brachiopod - at the top right of the page, just above where the scroll bar is, there's a tiny horizontal bar - drag this down to the top of your Totals row and that'll always be visible at the bottom of the screen

[brachiopod]

Cheers, stevie, excellent diagram and love the technical terms !!

;o)

[brachiopod]

No, it's still not having it. You can't seem to have a split and frozen pane together in XP Excel - it's either one or the other.

[Hammer]

Stevie, that's exactly what I meant. Didn't think of clicking the left-most cell, but it does the same job.