What this does is that it locks in place Column A. Here you can find the Freeze Panes function. If you want to freeze a specific row or just a specific column, you can go to the View tab in the Ribbon. One window or pane will be static or locked, while the other side can be moved and you can scroll through your worksheet to view your data. With this feature, you can freeze panes or freeze a set of row, a set of columns, or both, so that a separate window is created in the same worksheet. This is a View option that Excel has, which allows you to keep a select row or column locked in place so that you can scroll throughout your worksheet and easily view and recognize your cells.
#FREEZE PANES IN EXCEL HOW TO#
Let’s take a look at how to freeze panes to lock columns and rows in Excel. And this is where Microsoft Excel’s Freeze Pane can come in handy. You may have a hard time recognizing what row or column the cell you’re viewing belongs to. It can be easy to get lost, if this is the case. This video lesson is from our complete Excel tutorial, titled “ Mastering Excel Made Easy v.2019 and 365.When you’re working with spreadsheets, there can be a lot of data that your worksheet would take up many cells. The following video lesson, titled “ Freeze Panes,” shows how to freeze panes in Excel.
![freeze panes in excel freeze panes in excel](https://cdn.educba.com/academy/wp-content/uploads/2019/08/Freeze-Columns-in-excel.png)
Notice the other choices shown in the drop-down menu after you click the “Freeze Panes” button. After that, when you scroll through the worksheet, the information in the frozen panes will not scroll.įreeze Panes in Excel – Instructions: A picture of a user selecting the Freeze Panes button in Excel. Finally, choose the “Freeze Panes” command from the drop-down menu. You then click the “Freeze Panes” button in the “Window” button group.
![freeze panes in excel freeze panes in excel](https://www.tutorialspoint.com/excel/images/freezing_first_row.jpg)
One way is to select the cell below the row and to the right of the column to freeze. There are different ways to freeze panes in Excel. Then you can then scroll the unfrozen section of the worksheet to view two different worksheet sections at the same time. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously.