MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Freeze the Headers

May 21, 2002 - by Juan Pablo Gonzalez

Arthur asks:

Hi, I've got to believe there's a way to keep the row of column heading always visible on the screen as I scroll down through many deeper rows and row 1 disappears. I know I can print a new page always with a header row, but I'm just concerned about having it visible on the screen while viewing rows too deep to show row 1 headers (or may even column headers on row 5, etc.).

Sure, for example, select B2, go to Window | Freeze Panes.

Now, scroll to the right, then scroll down, see what happens...