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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/86938-how-do-i-lock-top-2-rows-headings-so-they-always-displayed-when-moving-around-spreadsheet.html)

Clubsprint

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

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

Paul B

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

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

"Clubsprint" wrote in message
...
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

All times are GMT +1. The time now is 11:34 PM.