How to lock scroll area

[lezawang]

Hi
I just watched a video on how to change the scoll area:

Developer tab -->Properties-->Scroll Area

I change it to 1:70

so it locked row 1 to 70.
Then I tried 1:70;A:N

but did not work. I wanted to lock the column A to N as well. How can I do that, locking both vertically and horizontally . Thank you very much

 

[HaHoBe]

Hi, lezawang,

maybe use

A1:N70

Ciao,
Holger