As the name suggests, this option locks the entire first row. The second Freeze Panes option is Freeze Top Row. This action allows you to see the first row and the column A, even when scrolling both ways. For example, to freeze both the first row and the first column, select the cell B2 and click on Freeze Panes.
![freeze panes in excel freeze panes in excel](https://support.content.office.net/en-us/media/0ac4d931-d85b-4016-b8b5-cd4e8509ff6a.png)
The first option, Freeze Panes, locks both rows and columns up to the selected cell. Freeze Panesįirst of all, all freezing options are listed under the Freeze Panes icon from the Window section of the View tab in the Ribbon. Let's see how you can apply these three variations on your worksheet.
#Freeze panes in excel how to#
In this guide, we are going to show you how to freeze panes in Excel (rows and columns) using three different methods.
![freeze panes in excel freeze panes in excel](https://4.bp.blogspot.com/-6Wjwxtinalg/U0xeyI1BwCI/AAAAAAAAELQ/-mC7Et71aho/s1600/freeze+pane.png)
Excel's Freeze Panes feature allows you to lock a number of rows and/or columns and make it easier to navigate other parts of your workbook and the frozen sections will remain visible as you scroll through.
#Freeze panes in excel free#
If you have any more questions, feel free to reach out using the comments section below.If you are working with a huge data, it can be difficult to recognize which cell is under which column or row. I hope you were easily able to freeze panes using the guide above. This would be the intersection point for your chosen rows and columns.Ĭlick on ‘Freeze panes’ again to freeze the rows and columns around your selected cell.Īnd that’s it! Your selected rows and columns should now be frozen in the concerned spreadsheet. For example, if you wish to select columns A, B, and C, and row 1, 2, and 3, then you need to select cell D4. Now select the cell beneath the intersection of your selection. Freeze Rows & Columnsįind the rows and columns you wish to freeze. They will remain static no matter how far you scroll horizontally. Now click and select the entire column to the right of your selection.Ĭlick on ‘View’ at the top of your screen.Ĭlick on ‘Freeze Panes’ to freeze all the columns to the left of your selection.Īnd that’s it! All the concerned columns should now be frozen in the spreadsheet. Open a spreadsheet and find all the columns you wish to freeze. They will always be visible regardless of your position in the spreadsheet. Once selected, click on ‘View’ at the top of your screen.Īnd that’s it! All the rows above your selected row will now be frozen and static on your screen. Once found, click and select the row beneath your selected rows by clicking on its number on the left side. Open the concerned Spreadsheet and find the rows you wish to freeze. Follow one of the guides below that best fits your needs. When it comes to freezing panes in Excel you get 3 options you can either freeze rows, columns, or a collection of rows and columns. This functionality helps with better viewing of data, emphasizing categories, verifying data, corroboration against other readings, and much more.
![freeze panes in excel freeze panes in excel](https://trumpexcel.com/wp-content/uploads/2015/12/Using-Excel-Freeze-Panes-Freeze-Panes-Demo.gif)
![freeze panes in excel freeze panes in excel](https://www.muhammadniaz.net/wp-content/uploads/2014/01/Microsoft-Excel-Freeze-Panes.gif)
This ensures that the data in these rows and columns are always visible on your screen regardless of the currently selected cell, row, or column in the spreadsheet. These rows and columns can be manually selected and turned into static elements. What is the ‘Freeze panes’ option in Excel?įreeze panes is a term in Excel used to denote static columns and rows.