split and freeze option in excel


1 Answer(s)


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.

Use the split box in Excel to split the screen vertically and/or horizontally into sections allowing you to see multiple copies of a worksheet.