Lock Rows
 

Hi,
I have a worksheet where the first 5 rows (A1:A5) hold a number of headings
which I want to be locked. ie when the user fills the current screen with
data and wishes to scroll down using the vertical scroll bar, the actual
headings don't dissapear from the screen.

Easy enough, but can't figure out how.
Thanks
Anthony

Go into A6 and then go to window/freeze panes

"Anthony" wrote:

Hi,
I have a worksheet where the first 5 rows (A1:A5) hold a number of headings
which I want to be locked. ie when the user fills the current screen with
data and wishes to scroll down using the vertical scroll bar, the actual
headings don't dissapear from the screen.

Easy enough, but can't figure out how.
Thanks
Anthony

Matthew,
yep - just found out how to do it by looking at old postings.
But thanks for posting ur help
regds
Anthony

"matthew" wrote:

Go into A6 and then go to window/freeze panes

"Anthony" wrote:

Hi,
I have a worksheet where the first 5 rows (A1:A5) hold a number of headings
which I want to be locked. ie when the user fills the current screen with
data and wishes to scroll down using the vertical scroll bar, the actual
headings don't dissapear from the screen.

Easy enough, but can't figure out how.
Thanks
Anthony