However, the cell must be not placed in the fixed area. Make a cell at the intersection of the fixed rows and columns active. You have a task – to freeze the selected area, which contains two columns and two rows.
How to freeze the row and column in Excel To freeze several columns, select the cell at the page bottom (to the right from the fixed column).
Freezing columns in Excelįor instance, the information in the table has a horizontal direction. There you must always (!) activate the cell under the freeze row. In earlier versions the “Lock areas” tool is located in the “Window” menu on the main page. Note: This method works for 20 Excel versions. Thus, you can fix two, three, four and more rows. When you perform horizontal and vertical scrolling, the cap and the top row of the table remain fixed. This action will help Excel to “understand”, which area should be fixed Select any cell under the line, which we will fix.Doing it is possible and easy, when you follow these steps: For instance, another row or even a couple of rows must be fixed when scrolling the document.
Let us suppose, a user needs to fix not only the cap. Locking several rows in Excel while scrolling