Donate SIGN UP

Tables in Excel

Avatar Image
sarahbowen82 | 10:16 Wed 30th Nov 2005 | Technology
8 Answers

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

Gravatar

Answers

1 to 8 of 8rss feed

Best Answer

No best answer has yet been selected by sarahbowen82. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Click on any cell one line below your headings and choose
"Window > Freeze Panes"
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

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.

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.

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

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


;o)

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.

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

1 to 8 of 8rss feed

Do you know the answer?

Tables in Excel

Answer Question >>