Hence, by freezing panes, the user knows the kind of data contained in these fixed rows (1, 2, and 3) and columns (A, B, and C). Rows 1, 2, and 3 and columns A, B, and C are frozen. Click the “freeze panes” drop-down from the View tab of the Excel ribbon.Freezing panes is helpful when the dataset is large and there is a need to view certain sections of the data at all times.įor example, to freeze the first three rows and the first three columns of a blank Excel worksheet, we undertake the following steps:

The final data in the excel sheet will look like the one on the sample below.Freezing panes in excel helps freeze one or more rows and/or columns so that they remain fixed while scrolling through the database. Upon clicking the freeze panes option, the top rows will be locked, this is to mean that they will remain visible even after scrolling top to bottom and vice-versa. Click on freeze panes, a list of three options will appear to select the first one which is freeze panes. Select the third row and click on view from the menu bar. The next step is now to select the rows that we would like to freeze. In case you are doing it for the first time, open a new or a blank excel sheet from your device and create the data. Open the excel sheet that you would like to freeze the rows if the data is already created. To lock the rows or to freeze the rows in excel, we have some procedures to go about that. This will enable you to save time as we all know time is expensive. In case you need to refer to that information each time you open excel sheets, it is good you freeze the rows of interest to you to avoid tedious scrolling up and down. Once the row is in the freeze, it will remain visible even when you browse up and down the excel sheet.įreezing in excel sheets can be done on rows, columns, and cells provided you need to freeze them to remain always visible throughout the entire excel sheet.

To keep this information visible even when we scroll to the bottom is what we refer to as locking rows or freezing. The information may be recorded in more than one row or a column. Each time we use excel sheets to do a recording of our collected data, there is some crucial information that we intend to keep visible all through the excel sheets.

How do i freeze first two rows in excel