Friday, 22 April 2016

How to make unscrollable heading or some rows of sheet ?


Go to any cell, from which row you want to lock the rest of rows.
Click Windows > Freeze panes.

To unlock scrolling. Go to Windows > UnFreeze panes.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.