A large amount of data can fit on an Excel sheet. It can become quite cumbersome with hundreds upon thousands of rows and columns. Row and column freezing is one minor feature that makes managing all of that data simpler. This indicates that particular rows or columns will always be shown when you browse the spreadsheet. In this article we will try to tech you how to Freeze or Unfreeze Rows and Columns in Excel.
It might be challenging to stay organised while dealing with a lot of spreadsheet data on your laptop. When working with a small subset of data, it is one thing to compare one or two rows of data, but when twelve rows are involved, things become cumbersome. Even so, we haven’t even begun to discuss columns. There is just one thing you can do when your spreadsheets get too big: freeze the rows and columns.
How to Freeze/Unfreeze Rows and Columns in Excel
How to freeze the first column:
- Choose View > Freeze Window.
- Select Freeze First Column.
How to freeze the first two columns:
- Select the third column.
- Select View > Freeze Panes > Freeze Panes.
How to freeze columns and rows:
- Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
- Select View > Freeze Panes > Freeze Panes.
How to unfreeze rows or columns:
- On the View tab > Window > Unfreeze Panes.
Final Words
We hope our article on Freeze/Unfreeze Rows and Columns in MS Excel will help you and resolve all your problems. When working on a large spreadsheet, it can be helpful to “freeze” specific rows or columns so they stay on screen while you scroll through the rest of the spreadsheet.
I hope you understand this article, How to Freeze or Unfreeze Rows and Columns in Excel.