It is often difficult to maintain an overview when working with big tables in Excel: What information is in column D? What name is in row 19? In such instances it is useful to lock the first row or the first column, so that it is always visible, even when you scroll down or to the left in the table. In this learning module “((fett)) Excel: Lock ((fettende)) rows and columns”you will learn how to lock rows and columns.
Excel: Lock rows and columns – HOW DOES IT WORK?
Excel: Lock the top row
It is helpful to lock the first row containing the column heading when you are preparing a long list in Excel. This ensures that it is always visible, even when you scroll down in the table. To lock the top row, go to the View tab and click on Freeze Panes in the Window group.
Select Freeze Top Row.
If you now scroll down, you will see that the first row with the column heading remains visible.
You can lock the first column containing the row description in the same way.
Excel: Lock the first column
Click once more on Freeze Panes and select Freeze First Column.
If you now scroll to the right, you will see that the first column remains visible.
Excel: Unlock panes
If you want to unlock the panes again, select Unfreeze Panes by clicking on Freeze Panes in the Window group in the View tab.
Excel: Locking multiple rows and columns
You can also freeze and lock several rows and columns at the same time. Select the cell to the top and left of which all rows and columns should be locked.
Click again on Freeze Panes and select Freeze Panes.
If you now scroll down, all rows above the selected cell remain locked, as do all columns to the left of the selected cell if you scroll right.