joethin Posted July 20, 2006 Share Posted July 20, 2006 This is my first year creating my own excel spreadsheet. I'm pasting my favs on separate tabs within the same file. However, I don't know how to make the categories line stay put (in the same place) so that when I scroll down the players I don't have to go up all the time to look at the category. I can copy and paste the line into every new page but that is kind of anoying. Sorry if this is the wrong forum! Quote Link to comment Share on other sites More sharing options...
Chief Dick Posted July 20, 2006 Share Posted July 20, 2006 This is my first year creating my own excel spreadsheet. I'm pasting my favs on separate tabs within the same file. However, I don't know how to make the categories line stay put (in the same place) so that when I scroll down the players I don't have to go up all the time to look at the category. I can copy and paste the line into every new page but that is kind of anoying. Sorry if this is the wrong forum! Maybe post this in the tailgate. Good help there. Quote Link to comment Share on other sites More sharing options...
Chief Dick Posted July 20, 2006 Share Posted July 20, 2006 Maybe post this in the tailgate. Good help there. Wow, how did I do that? Quote Link to comment Share on other sites More sharing options...
DO Jaded Posted July 20, 2006 Share Posted July 20, 2006 (edited) You want to freeze the column headers in their own pane. (Under the Windows menu) http://office.microsoft.com/en-us/assistan...2001021033.aspx Short version: Select the row below the headers, then select Windows/Freeze Panes on the menu. Edited July 20, 2006 by DO Jaded Quote Link to comment Share on other sites More sharing options...
joethin Posted July 20, 2006 Author Share Posted July 20, 2006 Thanks both of you! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.