ChatterBank1 min ago
Tables in Excel
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
Answers
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.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.
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