How do you lock rows when filtering?

[silversnake588]

Start by selecting the row below the last row you want to freeze. For example, if you wish to lock the top two rows, place the mouse cursor in cell A3 or select the entire row 3. Head over to the View tab and click Freeze Panes

[tinytiger956]

Here is how you do it:

1. This moment is the key - select the cell just below the rows you want to freeze, and to the right of such columns if needed.
2. Open the View tab in Excel and find the Freeze Panes option in the Window group.
3. Click on the little arrow next to it to see all the options, and choose to Freeze Panes.

Similarly, how do you link rows in Excel so they will stay together during sort? Highlight/select all of the columns you have data entered in (or that you want included in the sort). Select data and select auto filter. This will place double arrows in the top row that will allow you to sort each column while keeping corresponding data in the same row.

Simply so, how do you lock a row?

To freeze rows:

1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so well select row 3.
2. Click the View tab on the Ribbon.
3. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
4. The rows will be frozen in place, as indicated by the gray line.

How do I lock a few rows in Excel?

Press the Keyboard Shortcut Ctrl A to select all the cells of the sheet. Right click and choose Format cells. Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect.