![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://cdn.ablebits.com/_img-blog/freeze-excel/freeze-top-row-excel.png)
HOW TO FREEZE TOP 3 ROWS IN EXCEL 2013 HOW TO
Here we discuss how to freeze rows and columns using Freeze Panes in excel with some examples and a downloadable excel template.A simple solution to this problem is to simply Freeze the entire Row containing Columns headings. This has been a guide to Freeze Cells in Excel. We don’t have to select the entire row & the Entire Column together for locking.
HOW TO FREEZE TOP 3 ROWS IN EXCEL 2013 MANUAL
![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2013/06/excel-2013-freeze-top-row-2.jpg)
Hence with the explanation of examples above, we make use of the freezing of rows and columns in excel. Similarly, we can use the ‘Unfreeze Pane’ command from the View tab to unlock the cells which we have frozen. Let us take a practical example of the Weekly attendance report of a class. If we use the Freezing Panes command to freeze the columns and rows of excel cells, they will remain displayed on the screen regardless of the magnification settings that we select or how we scroll through the cells. Use of Rows & Column Freezing in Excel Cell
![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://media.gcflearnfree.org/ctassets/topics/234/freeze_window4_done.png)
There are two other commands as well in the Freeze panes options, which are ‘Freeze Top Row’ & ‘Freeze First Column.’ As we can see in the snapshot below, the columns beside the grey line are frozen and do not move after we scroll the worksheet.įor unfreezing the columns, we use the same process as we did in the case of Rows, i.e., by using the unfreeze panes command from the view tab. We can scroll the entire worksheet & continuing viewing the frozen Columns.
![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://dummytech.com/wp-content/uploads/2019/11/excel-freeze-panes.png)