Freeze Row and Column / Lock Rows and Columns In Excel
To save an place of a worksheet visible even if you scroll to choice place of the worksheet, mount happening the View bank account, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to make sever windows of the linked worksheet.
Freezing panes versus splitting panes
When you under panes, Microsoft Excel keeps specific rows or columns visible along with you scroll in the worksheet. For example, if the first choice in your spreadsheet contains headers, you might asleep that argument to make certain that the column headers remain visible as you scroll all along in your spreadsheet.
A solid pedigree out cold clash 1 indicates that the argument is asleep to keep column headers in place considering than you scroll.
Splitting panes is a variation concerning freezing panes, in that taking into account you split panes, Excel creates either two or four cut off worksheet areas that you can scroll within, even though rows or columns in the non-scrolled place remain visible.
Freeze rows or columns
Before you choose to freeze rows or columns in a worksheet, it’s important to consider the following:
- You can under on your own rows at the peak and columns concerning the left side of the worksheet. You cannot out cold rows and columns in the center of the worksheet.
- The Freeze Panes command is not closely when you regarding in cell editing mode (that is, you’re speaking entering a formula or data in a cell) or following a worksheet is protected. To dissolve cell editing mode, press Enter or Esc.
Freeze the top row and the first column at the same time
To freeze the top row and the first column at the same time, click the View tab > Freeze Panes > Freeze Panes.
Freeze the top row
Notice that the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.
Freeze the first column
If you’d rather freeze the leftmost column instead, click the View tab > Freeze Panes > Freeze First Column.
Now, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen.
Unfreeze rows or columns
- On the View tab > Window > Unfreeze Panes.