Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list. In Microsoft Excel 2019, 2016, and, you can freeze rows and columns so that when you scroll, those panes stay in place. There are various ways to freeze cells in excel. When you scroll down in the table, the column headings should be locked at the top of the table automatically. Freeing in excel will turn some cells (rows or columns) to be stagnant. Ideally, your table should always have headers. Table headers display default names if you do not select the My table has headers check box.
In the Window group of the View tab, choose Freeze PanesUnfreeze Panes to unlock the fixed rows and columns.