Excel automatically adds a dark grey horizontal line to indicate that the first three. Scroll down to the rest of the worksheet. On the View tab, in the Window group, click Freeze Panes. This will unfreeze all rows and columns in the Excel worksheet. To freeze rows, execute the following steps. Click on View > Freeze Panes > Unfreeze Panes: From the top menu, click on View and then click on Freeze Panes and then Unfreeze Panes from the dropdown menu.
HOW TO FREEZE A ROW IN EXCEL HOW TO
If you no longer want the rows or columns to be frozen, then here is how to unfreeze rows and columns in Excel.ġ. In our example column A is frozen because we selected column B in step 1. Click on Freeze Panes: To freeze the column/columns, click on Freeze Panes from the dropdown menu. Click on View > Freeze Panes: From the top click on View and then from the options click on Freeze Panes.ģ. If you want to freeze the first column, select the second column.Ģ. It can be applied to any number of rows and any number of. Below is an illustration of how to freeze row 1 and column 1 at the same time. Select Column: Select the column to the right of the columns you want to freeze. Then you click on View menu, Freeze Panes, Freeze Panes. Had we selected row 5, the first 4 row would have been frozen. Since we selected row 4, the first three rows are frozen. In the Zoom category, click on the Freeze panes drop down. Click on Freeze Panes: From the dropdown menu click on Freeze Panes. Freeze/Lock More than One Row in Excel Here is how to freeze rows in Excel: Select the left-most cell in the row which is just below the headers row. Click on View > Freeze Panes: From the top, click on View and then click on Freeze Panesģ. If you want to freeze the first three rows, select row 4.Ģ. Select Row: Select a row below the rows you want to freeze. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. A thin line also appears below row 1 to indicate that the rows above that line are frozen.Įxcel also allows you to freeze a custom number of rows.ġ. Details: To Freeze a row in Excel follow these easy steps: Select the row below the row (s) you wish to freeze. Click on Freeze Top Row: To freeze the top row, simply click on click on Freeze Top Row from the dropdown.Īs you can see in the example below, the first row is frozen and stays visible when scrolling down. Click on View > Freeze Panes: From the top menu, click on View and then click on Freeze Panes.Ģ. Freeze Top Row in ExcelĮxcel gives a quick option to freeze the top row, since most users are looking for this functionality.ġ. You can also freeze the first row and column so you can easily keep track of what each row and column in the dataset represents. Instead of scrolling back and forth between these two areas, you can simply freeze rows in Excel so that the data in those rows stays frozen as you scroll.
HOW TO FREEZE A ROW IN EXCEL CODE
You can see code comments for detailed explanations. There are 6 methods in the example python file, each method demos for one excel freeze function, all the method names are very straightforward. The example file name is freezesplitexcelpane.py. In Excel, quite often you will want to compare data in completely different areas of your worksheet. Freeze Excel Sheet Rows And Columns, Split Excel Sheet To Panes Example.