How do I make column headers viewable as I scroll down the workshe

[Guest]

Without hiding rows, how do I make column headers viewable as I scroll down
the worksheet?

 

[Bob Umlas]

Select a row below the text you want to show, then use Window/Freeze Panes
Bob Umlas
Excel MVP
FYI, I'll be leading a LIVE 1-hour FREE webinar on tips & tricks on January
27 from 4-5 PM est. It's done from your computer. To find out more &
register, go to http://www.iil.com, click on the yellowish rectangle on the
left "Try a free webinar", click the link for Microsoft Tips & Tricks. Maybe
I'll "see" you there!

 

[Gord Dibben]

You can Freeze the header row(s).

Select A2 and Window>Freeze Panes to freeze row 1.

The rule is......columns left of and rows above the selected cell will be
frozen when you Freeze Panes.

i.e. Select B2 to have Row 1 and Column A frozen.


Gord Dibben Excel MVP