how do I keep the top line static in excel files

  • Thread starter Thread starter Guest
  • Start date Start date
Click on the 1 (or 2, or 3...) row header (the numbers at far left)
Use command Windows | Freeze
Later use Windows | Unfreeze
best wishes
 
Clicking on row 2 or 3 is OK, but for me clicking on row 1 (or column A)
puts the freeze pont at the centre of the window. For other conditions it
freezes everything above and to the left of the selected cell.
 
Many thanks thats great

David Biddulph said:
Clicking on row 2 or 3 is OK, but for me clicking on row 1 (or column A)
puts the freeze pont at the centre of the window. For other conditions it
freezes everything above and to the left of the selected cell.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Static Chart Data Range 2
Excel Excel spreadsheets opening at top instead of bottom. 4
Making Static Lines in Chart 1
Static 5
Excel Spreadsheets keep moving 0
Excel How to Fix Damaged Excel File That Won't Open? 3
Change the slope of line graph with the use of spinbutton in Excel VBA 1
Saving in Excel 2010 2

Back
Top