Output: How to lock top row in Excel How to unfreeze cells in Excel When we scroll down our data, notice that the top row (row 1) is locked such that it is always displayed on screen.įigure 4. We can click anywhere on our data and follow these steps: Suppose we have a large set of data and we want to freeze rows and columns in the following manner:įreezing only the top row is rather easy.
The Freeze Panes toolbar under View tab in Excel offers three options:įigure 2. Final result: How to freeze cells in Excel How to freeze cells in Excel This step by step tutorial will assist all levels of Excel users to freeze rows and columns in Excel, Google sheets and Mac.įigure 1. How to Freeze Rows and Columns in Google Sheets and ExcelĮxcel and Google sheets provide us with several options to freeze cells so they don’t disappear in the screen when we scroll through our data.
