hubieb
Technical User
- Jul 2, 2006
- 142
how do I do this? So the top row (the categories for me) stay there right at the top. No matter how many cells i scroll down, those categories always show at the top?
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Excel - "Pin" the top row to display at all times
- Thread starter hubieb
- Start date
- Status
SkipVought
Programmer
Hi,
Select in the cell BELOW and to the RIGHT of the ROWs/COLUMNs you want to freeze.
Windows/Freeze Panes
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
You have 2 options - either freeze panes "Windows" then "Freeze Panes" or on the right hand scroll bar theres a very small horizontal line above the up arrow. If you place the cursor over that line cursor should change to 2 horizontal lines with an up and down arrow.
If you drag that down, you will split the current window you are in. Stop where you need to and you can scroll the lower window as much as you need, and the upper window which will have your categories will always remain visible.
If you drag that down, you will split the current window you are in. Stop where you need to and you can scroll the lower window as much as you need, and the upper window which will have your categories will always remain visible.
- Status
Similar threads
- Question