In case you want to lock several rows (starting with row 1), carry out these steps: You can determine that the top row is frozen by a grey line below it: This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet. To lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row. Freeze Top Row - to lock the first row.You just click View tab > Freeze Panes and choose one of the following options, depending on how many rows you wish to lock: Other ways to lock columns and rows in Excelįreezing rows in Excel is a few clicks thing.This can be easily done by using the Freeze Panes command and a few other features of Excel. When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. Below you will find the detailed steps on how to lock a row or multiple rows, freeze one or more columns, or freeze column and row at once. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc.The tutorial shows how to freeze cells in Excel to keep them visible while you navigate to another area of the worksheet. Note: to unlock all rows and columns, click the Freeze button again. Scroll down to the rest of the worksheet. To freeze the top row, select row 2 and click the magic Freeze button.ħ. Under Choose commands from, select Commands Not in the Ribbon.Ħ. The orange region above row 3 and to the left of column C is frozen.Īdd the magic Freeze button to the Quick Access Toolbar to freeze the top row, the first column, rows, columns or cells with a single click.ģ. To freeze cells, execute the following steps. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen. All columns to the left of column E are frozen. To freeze columns, execute the following steps. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. On the View tab, in the Window group, click Freeze Panes.Ĥ. To freeze rows, execute the following steps.Ģ. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. To freeze the first column, execute the following steps. On the View tab, in the Window group, click Freeze Panes. To unlock all rows and columns, execute the following steps.ġ. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.

Excel how many rows can you freeze