When creating spreadsheets, it is often important that the column headings remain visible at all times, regardless of page scrolling. However, with a large number of lines that do not fit vertically on the screen, headings often end up behind the top edge along with the top of the sheet. The spreadsheet editor Microsoft Office Excel provides functions that allow you to freeze any number of rows by excluding them from the scrollable area of the table.
It is necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
If you need to freeze only one top line, then go to the "View" tab in the spreadsheet editor menu and open the "Freeze areas" drop-down list. It is placed in the "Window" group of commands and contains three options for "freezing" cells. You need the middle item - "Freeze the top line". By selecting this line, you will complete the procedure for fixing the table heading.
Step 2
The third item ("Freeze the first column") in this dropdown disables scrolling of the first column of the table in a similar way.
Step 3
If you need to fix not only one or several top rows, but also a certain number of columns on the left side of the table, then the procedure will become a little more complicated. Select the very first (top left) cell of the scrollable area - anything left or above it will be fixed when the document is scrolled. Then, in the same "Freeze Areas" drop-down list on the "View" tab, select the top row ("Freeze Areas").
Step 4
Use the same list item if you need to pin not one, but several top lines. To do this, proceed in the same way as in the previous step, but do not leave any column to the left of the selected cell. Several columns are fixed in the same way at the left edge of the table - to do this, select the cell in the topmost row.
Step 5
If you made a mistake or want to undo the previously fixed areas, the same drop-down list will help. If there is such a “frozen” range of cells on the table page, an additional item is added to the list - “Unpinned areas”.
Step 6
In addition to fixing a specific area of the document in Excel, it is possible to split the sheet into several frames, each of which will have its own scrolling. To split the table into two vertical windows, hover over the thin bar above the vertical scroll bar between the up arrow button and the formula bar. The cursor will then change its appearance - it will become a double-headed vertical arrow. Press the left button and drag this strip down to the desired height of the top frame. Similarly, you can split the table vertically.
