Conrad Posted March 20, 2009 Share Posted March 20, 2009 I have a spreadsheet on Excel and I want to freeze the titles at the top of the page so that they continually appear at the top of the page when I scroll down. Also so that they appear at the top of each page when I print. I used to be able to do this on the old Excel but can't remember how to do it now, I have 2007 Excel. Link to comment Share on other sites More sharing options...
juanchan Posted March 20, 2009 Share Posted March 20, 2009 Select 'Window' --> Freeze Panes. Edit to add: That freezes all cells above and to the left of the cell you currently have selected Link to comment Share on other sites More sharing options...
tbourner Posted March 20, 2009 Share Posted March 20, 2009 It's 'window', 'Freeze panes' on 2003. On 2007 can't you click 'Alt' and get the normal menus up anyway? Link to comment Share on other sites More sharing options...
jim Posted March 20, 2009 Share Posted March 20, 2009 To print them, you need to select page setup from the file menu, go to the 'sheet' tab and click the 'rows to repeat at top' box. Link to comment Share on other sites More sharing options...
Conrad Posted March 20, 2009 Author Share Posted March 20, 2009 Thanks guys! Found it now, I must be blind! It's on the 'View' tab/menu and then Freeze Panes. I'm not a fan of Excel 2007!! Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now