excel split screen

Hello
I have got this legacy worksheet and when i scroll it everything beyong row11 scrolls, while rows 1-10 stay in place. how is this done?

also i can't see the "headers" i.e. A,B,C,D,E,F,G,H,I,.....Y,Z and 1,2,3,4,5,6,...23,24,25,26,....

can you guys tell me how to turn on this option?

Good afternoon Excel student

To free up the screen and scroll all of it go to Windows > Unfreeze Panes.

To show you row and column headers go to Tools > Options and under the View tab find (and check) the Row & column headers box.

HTH

DominicB

thanks dominic

You're welcome Excel student. Thanks for the feedback.

DominicB