If the first two columns of the worksheet need to be frozen, the same process can be followed. The option to “Freeze Top Row” should be selected. When this option is selected, a list of options will appear.
Under the “View” tab, there is an option to “Freeze Panes”. Once the row is selected, the “View” tab should be clicked on the top of the worksheet. This can be done by clicking on the row number. The first step in freezing the top two rows in Excel is to select the row below the two rows that need to be frozen. Freezing the top two rows in Excel is a simple process that can be completed in a few steps. This can be especially useful when creating reports or charts that contain a lot of data. When working with large and complex Excel worksheets, it is often necessary to freeze the top two rows to ensure that the data is always visible. Source: How to Freeze the Top Two Rows in an Excel Worksheet
Now, the top two rows and the first column will be frozen, allowing you to scroll through the rest of the document without losing your place. Select Freeze Panes > Freeze First Column.
Freezing the top two rows in Excel is easy.
0 kommentar(er)
