The photo shows that when scrolling, the selected areas remain at the same place. Pick the first option in Excel Locking Areas. It should have the position right under the required lines (to the right of the required columns). 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 a row in excel how to#
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). Now, when the document is scrolled to the right horizontally, the needed column will be fixed.Pin the first column in the menu you will see. Select any cell of the chosen table so that Excel understands with what data it will work.
It is some kind of pointer that informs you the row above is locked. As a result, you will see a grey line below the first row. Step 3: Now choose the Freeze Top Row option. Step 2: Go to the Window group and click the Freeze Panes command. For his comfort, the user must freeze the first column, containing the lines’ names in horizontal scrolling. Step 1: On the Excel ribbon click the View tab. It is not concentrated in columns, but located in rows. 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
0 kommentar(er)
