How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spr

  • Thread starter Thread starter Clubsprint
  • Start date Start date
C

Clubsprint

Hi all
How do I lock the top 2 rows (headings) so that they are always displayed
when moving around the spreadsheet?
Thanks
Mark
Aus
 
Mark, select cell A3 and then window freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

view column headings 2
Filter by criteria in one row - display that row and previous row 3
how to lock a row so that it stays on top when scrolling 2
How do I make the heading cells always display? 1
Freeze top 2 rows - how 3
Font size for row and column headings 2
Lock column/row in place 1
how do I sort data excluidng headings? 2

Back
Top