Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
how do I display rows at top of page even when I scroll down??
- Thread starter paullaup
- Start date
Its called freezing. The following is from Excel help.
Keep row and column labels visible as you scroll
To freeze the top horizontal pane, select the row below where you want the split to appear.
To freeze the left vertical pane, select the column to the right of where you want the split to appear.
To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.
On the Window menu, click Freeze Panes.
Keep row and column labels visible as you scroll
To freeze the top horizontal pane, select the row below where you want the split to appear.
To freeze the left vertical pane, select the column to the right of where you want the split to appear.
To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.
On the Window menu, click Freeze Panes.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question