Office Tips

Freeze or lock rows and columns

Freeze or lock rows and columns

To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes.